Rollback interim patch in Oracle 12c R1 (12.1.0.2.0) - 21519686 patch
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5046 1 0 00:17 ? 00:00:00 asm_pmon_+ASM1
oracle 7259 1 0 00:18 ? 00:00:00 ora_pmon_corcldb1
oracle 7261 1 0 00:18 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 7275 1 0 00:18 ? 00:00:00 ora_pmon_orcl1
[oracle@rac1-12c ~]$ srvctl stop instance -d orcl -i orcl1 -f
[oracle@rac1-12c ~]$ srvctl stop instance -d corcldb -i corcldb1 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d orcl -i orcl2 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d corcldb -i corcldb2 -f
OR
[oracle@rac2-12c ~]$ srvctl stop database -d orcl
[oracle@rac2-12c ~]$ srvctl stop database -d corcldb
[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686
21519686;
[oracle@rac1-12c ~]$ /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-17_00-28-38AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-28-38AM.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 ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch rollback -id 21519686
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-17_00-28-51AM_1.log
Patches will be rolled back in the following order:
21519686
The following patch(es) will be rolled back: 21519686
This node is part of an Oracle Real Application Cluster.
Remote nodes: 'rac2-12c'
Local node: 'rac1-12c'
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
Rolling back patch 21519686...
RollbackSession rolling back interim patch '21519686' from OH '/u01/app/oracle/product/12.1.0.2/db_1'
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '21519686' from inventory
Patching in rolling mode.
The node 'rac2-12c' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'rac2-12c'.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'rac2-12c'
Rollback-related files are:
FR = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt"
DR = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt"
FP = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt"
MP = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt"
RC = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remote_cmds.txt"
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt" with actual path.
Removing files on remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt" with actual path.
Removing directories on remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt" with actual path.
Running command on remote node 'rac2-12c':
cd /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1 || echo REMOTE_MAKE_FAILED::>&2
The node 'rac2-12c' has been patched. You can restart Oracle instances on it.
Finished patching in rolling mode.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-28-51AM_1.log
OPatch succeeded.
[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686
[oracle@rac1-12c ~]$ /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-17_00-30-20AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-30-20AM.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 ~]$ ps -ef | grep pmon
oracle 5046 1 0 00:17 ? 00:00:00 asm_pmon_+ASM1
oracle 7261 1 0 00:18 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 19112 16276 0 00:30 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ ssh rac2-12c
Last login: Sun Sep 17 00:25:37 2017 from 192.168.2.1
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 4969 1 0 00:17 ? 00:00:00 asm_pmon_+ASM2
oracle 19012 18954 0 00:30 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686
[oracle@rac2-12c ~]$ /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-17_00-31-19AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-31-19AM.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 ~]$ ps -ef | grep pmon
oracle 4969 1 0 00:17 ? 00:00:00 asm_pmon_+ASM2
oracle 20365 18954 0 00:32 pts/1 00:00:00 grep pmon
[oracle@rac2-12c ~]$ srvctl start database -d orcl
[oracle@rac2-12c ~]$ srvctl start database -d corcldb
[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle 4969 1 0 00:17 ? 00:00:00 asm_pmon_+ASM2
oracle 20479 1 0 00:32 ? 00:00:00 ora_pmon_orcl2
oracle 20794 1 0 00:32 ? 00:00:00 ora_pmon_corcldb2
oracle 21357 18954 0 00:33 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle 5046 1 0 00:17 ? 00:00:00 asm_pmon_+ASM1
oracle 7261 1 0 00:18 ? 00:00:00 mdb_pmon_-MGMTDB
oracle 20259 1 0 00:32 ? 00:00:00 ora_pmon_orcl1
oracle 20706 1 0 00:32 ? 00:00:00 ora_pmon_corcldb1
oracle 21183 16276 0 00:33 pts/1 00:00:00 grep pmon
[oracle@rac1-12c ~]$
Saturday, September 16, 2017
Rollback interim patch in Oracle 12c R1 (12.1.0.2.0) - 21519686 patch
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment