RAC Rolling Patch - Oracle Database 12c Release 12.1.0.2.0 - PLSQL Patch for Bug# 21519686 for Linux-x86-64 Platforms
[oracle@rac1-12c ~]$
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 9973 1 0 01:53 ? 00:00:00 ora_pmon_orcl1
oracle 10278 1 0 01:53 ? 00:00:00 ora_pmon_corcldb1
oracle 15951 13690 0 01:57 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ ls -lrth p*
-rw-r--r-- 1 oracle oinstall 114K Sep 15 01:52 p21519686_121020_Linux-x86-64.zip
[oracle@rac1-12c ~]$ scp p21519686_121020_Linux-x86-64.zip oracle@192.168.2.102:/home/oracle
p21519686_121020_Linux-x86-64.zip 100% 113KB 113.4KB/s 00:00
[oracle@rac1-12c ~]$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch
[oracle@rac1-12c OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-03-07AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-03-07AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac1-12c
Remote node = rac2-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac1-12c OPatch]$ . oraenv
ORACLE_SID = [orcl1] ? orcl1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1-12c OPatch]$ srvctl stop instance -d orcl -i orcl1 -f
[oracle@rac1-12c OPatch]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 10278 1 0 01:53 ? 00:00:00 ora_pmon_corcldb1
oracle 19007 13690 0 02:05 pts/1 00:00:00 grep pmon
[oracle@rac1-12c OPatch]$ srvctl stop instance -d corcldb -i corcldb1 -f
[oracle@rac1-12c OPatch]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 19314 13690 0 02:06 pts/1 00:00:00 grep pmon
[oracle@rac1-12c OPatch]$ cd
[oracle@rac1-12c ~]$
[oracle@rac1-12c ~]$ cd /home/oracle/
[oracle@rac1-12c ~]$ unzip p21519686_121020_Linux-x86-64.zip
Archive: p21519686_121020_Linux-x86-64.zip
creating: 21519686/
creating: 21519686/files/
creating: 21519686/files/lib/
creating: 21519686/files/lib/libserver12.a/
inflating: 21519686/files/lib/libserver12.a/kkxm.o
creating: 21519686/etc/
creating: 21519686/etc/config/
inflating: 21519686/etc/config/actions.xml
inflating: 21519686/etc/config/inventory.xml
creating: 21519686/online/
creating: 21519686/online/files/
creating: 21519686/online/files/hpatch/
inflating: 21519686/online/files/hpatch/bug21519686.pch
creating: 21519686/online/etc/
creating: 21519686/online/etc/config/
inflating: 21519686/online/etc/config/inventory.xml
inflating: 21519686/online/etc/config/deploy.xml
inflating: 21519686/online/etc/config/actions.xml
creating: 21519686/online/etc/xml/
inflating: 21519686/online/etc/xml/GenericActions.xml
inflating: 21519686/online/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 21519686/README.txt
[oracle@rac1-12c ~]$ cd 21519686/
[oracle@rac1-12c 21519686]$ pwd
/home/oracle/21519686
[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-07-01AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 21519686
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21519686' to OH '/u01/app/oracle/product/12.1.0.2/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patch 21519686 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-07-01AM_1.log
OPatch succeeded.
[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
21519686;
OPatch succeeded.
[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-08-40AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-08-40AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 21519686 : applied on Fri Sep 15 02:07:26 IST 2017
Unique Patch ID: 20178159
Created on 9 May 2016, 09:28:22 hrs PST8PDT
Bugs fixed:
21519686
Rac system comprising of multiple nodes
Local node = rac1-12c
Remote node = rac2-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 21486 13690 0 02:10 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ srvctl start instance -d orcl -i orcl1
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 21704 1 0 02:11 ? 00:00:00 ora_pmon_orcl1
oracle 22112 13690 0 02:11 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ srvctl start instance -d corcldb -i corcldb1
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5192 1 0 01:51 ? 00:00:00 asm_pmon_+ASM1
oracle 9881 1 0 01:53 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 21704 1 0 02:11 ? 00:00:00 ora_pmon_orcl1
oracle 22885 1 0 02:12 ? 00:00:00 ora_pmon_corcldb1
oracle 23551 13690 0 02:14 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ . oraenv
ORACLE_SID = [orcl1] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 15 02:14:13 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect sys/oracle@orcl as sysdba
Connected.
SQL> select instance_name,instance_number from gv$instance;
INSTANCE_NAME INSTANCE_NUMBER
---------------- ---------------
orcl2 2
orcl1 1
SQL> exit
Login to Node-2
==================
[oracle@rac1-12c ~]$ ssh rac2-12c
Last login: Fri Sep 15 01:59:43 2017 from 192.168.2.1
[oracle@rac2-12c ~]$ ls -la p*
-rw-r--r-- 1 oracle oinstall 116093 Sep 15 01:59 p21519686_121020_Linux-x86-64.zip
[oracle@rac2-12c ~]$ chmod -R 777 p21519686_121020_Linux-x86-64.zip
[oracle@rac2-12c ~]$ unzip p21519686_121020_Linux-x86-64.zip
Archive: p21519686_121020_Linux-x86-64.zip
creating: 21519686/
creating: 21519686/files/
creating: 21519686/files/lib/
creating: 21519686/files/lib/libserver12.a/
inflating: 21519686/files/lib/libserver12.a/kkxm.o
creating: 21519686/etc/
creating: 21519686/etc/config/
inflating: 21519686/etc/config/actions.xml
inflating: 21519686/etc/config/inventory.xml
creating: 21519686/online/
creating: 21519686/online/files/
creating: 21519686/online/files/hpatch/
inflating: 21519686/online/files/hpatch/bug21519686.pch
creating: 21519686/online/etc/
creating: 21519686/online/etc/config/
inflating: 21519686/online/etc/config/inventory.xml
inflating: 21519686/online/etc/config/deploy.xml
inflating: 21519686/online/etc/config/actions.xml
creating: 21519686/online/etc/xml/
inflating: 21519686/online/etc/xml/GenericActions.xml
inflating: 21519686/online/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 21519686/README.txt
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 11098 1 0 01:53 ? 00:00:00 ora_pmon_corcldb2
oracle 12326 1 0 01:55 ? 00:00:00 ora_pmon_orcl2
oracle 22816 22605 0 02:15 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ srvctl stop instance -d orcl -i orcl2 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d corcldb -i corcldb2 -f
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 23780 22605 0 02:16 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ cd /home/oracle/21519686/
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/12.1.0.2/db_1".
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-06AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-17-06AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = rac2-12c
Remote node = rac1-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-16AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 21519686
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21519686' to OH '/u01/app/oracle/product/12.1.0.2/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
Patch 21519686 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-16AM_1.log
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
21519686;
OPatch succeeded.
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-51AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-17-51AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 21519686 : applied on Fri Sep 15 02:17:28 IST 2017
Unique Patch ID: 20178159
Created on 9 May 2016, 09:28:22 hrs PST8PDT
Bugs fixed:
21519686
Rac system comprising of multiple nodes
Local node = rac2-12c
Remote node = rac1-12c
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@rac2-12c 21519686]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 24957 22605 0 02:17 pts/1 00:00:00 grep pmon
[oracle@rac2-12c 21519686]$ srvctl start instance -d orcl -i orcl2
[oracle@rac2-12c 21519686]$ srvctl start instance -d corcldb -i corcldb2
[oracle@rac2-12c 21519686]$ ps -ef | grep pmon
oracle 5238 1 0 01:52 ? 00:00:00 asm_pmon_+ASM2
oracle 25197 1 0 02:18 ? 00:00:00 ora_pmon_orcl2
oracle 25829 1 0 02:19 ? 00:00:00 ora_pmon_corcldb2
oracle 26892 22605 0 02:20 pts/1 00:00:00 grep pmon
[oracle@rac2-12c 21519686]$ . oraenv
ORACLE_SID = [orcl2] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac2-12c 21519686]$ cd
[oracle@rac2-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 15 02:21:10 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect sys/oracle@orcl as sysdba
Connected.
SQL> select instance_name,instance_number from gv$instance;
INSTANCE_NAME INSTANCE_NUMBER
---------------- ---------------
orcl1 1
orcl2 2
SQL> exit
[oracle@rac2-12c ~]$ srvctl status database -d orcl
Instance orcl1 is running on node rac1-12c
Instance orcl2 is running on node rac2-12c
[oracle@rac2-12c ~]$ srvctl status database -d corcldb
Instance corcldb1 is running on node rac1-12c
Instance corcldb2 is running on node rac2-12c
Thursday, September 14, 2017
RAC Rolling Patch - Oracle Database 12c Release 12.1.0.2.0 - PLSQL Patch for Bug# 21519686 for Linux-x86-64 Platforms
Subscribe to:
Post Comments (Atom)
Sap ABAP On Hana online online training
ReplyDeleteSAP Grc online training
SAP Secrity online training