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



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

1 comment: