oracle 11g patch(PSU) 的回退方法
資料庫要安裝新的補丁，發現新補丁中的某些包和原有補丁衝突，需要將原有補丁進行回退。
1、進行新補丁安裝前的衝突檢查，發現與原有補丁衝突。
[oracle@PJKMISDB patch]$ cd 20760982/
[oracle@PJKMISDB 20760982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-11-23_16-11-26PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
16902043, 20760982
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
16902043
Conflicts/Supersets for each patch are:
Patch : 20760982
Bug Conflict with 16902043
Conflicting bugs are:
17332800
Conflict with 16619892
2、檢視安裝補丁的補丁 ID。
[oracle@PJKMISDB OPatch]$ ./opatch lsinventory -patch_id
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-11-23_14-19-55PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-11-23_14-19-55PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (1) :
Patch 16902043 : applied on Sun Mar 02 11:41:20 CST 2014
Unique Patch ID: 16676143
Patch description: "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Created on 24 Sep 2013, 23:20:58 hrs PST8PDT
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
3、關閉資料庫和監聽。
4、將衝突的補丁包回退。
執行下面命令的時候報錯，這是由於 oracle 的程式沒有被關閉乾淨，需要把 oracle 程式關閉乾淨。
[oracle@PJKMISDB OPatch]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 16619892
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Argument(s) Error... ERROR: OPatch would not rollback a sub-patch that is not active. The patch id 16619892 is a sub-patch of the active composite 16902043. OPatch will not rollback patch(es) 16619892 until you have rolled back 16902043.
Please check the arguments and try again.
OPatch failed with error code 135
找到沒有關閉的 oracle 程式，使用 kill -9 將其殺掉。
[oracle@PJKMISDB OPatch]$ ps -ef |grep oracle
oracle 3466 9981 0 Sep11 ? 01:06:59 /u01/app/oracle/product/11.2.0/db_1/bin/emagent
root 6481 1 0 2014 ? 00:00:01 /usr/local/oracle/backup/.etc.linux86_64/observiced -b
oracle 9981 1 0 May13 ? 00:32:46 /u01/app/oracle/product/11.2.0/db_1/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/bin/emwd.pl dbconsole /u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb/sysman/log/emdb.nohup
root 11189 6416 0 13:23 ? 00:00:00 sshd: oracle [priv]
oracle 11194 11189 0 13:23 ? 00:00:00 sshd: oracle@pts/2
oracle 11195 11194 0 13:23 pts/2 00:00:00 -bash
root 11379 6416 0 13:26 ? 00:00:00 sshd: oracle [priv]
oracle 11383 11379 0 13:26 ? 00:00:00 sshd: oracle@pts/3
oracle 11384 11383 0 13:26 pts/3 00:00:00 -bash
root 12726 6416 0 13:36 ? 00:00:00 sshd: oracle [priv]
oracle 12731 12726 0 13:36 ? 00:00:00 sshd: oracle@pts/4
oracle 12732 12731 0 13:36 pts/4 00:00:00 -bash
root 14545 6416 0 13:50 ? 00:00:00 sshd: oracle [priv]
oracle 14549 14545 0 13:50 ? 00:00:00 sshd: oracle@pts/1
oracle 14550 14549 0 13:50 pts/1 00:00:00 -bash
oracle 17234 14550 0 14:14 pts/1 00:00:00 vim 01.txt
root 17722 6416 0 14:18 ? 00:00:00 sshd: oracle [priv]
oracle 17726 17722 0 14:18 ? 00:00:00 sshd: oracle@pts/5
oracle 17727 17726 0 14:18 pts/5 00:00:00 -bash
oracle 19613 12732 0 14:25 pts/4 00:00:00 vim /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/16902043_Nov_23_2015_14_24_23/rollback2015-11-23_14-24-23PM_1.log
oracle 20088 9981 43 14:28 ? 00:00:20 /u01/app/oracle/product/11.2.0/db_1/jdk/bin/java -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 -Doracle.home=/u01/app/oracle/product/11.2.0/db_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb/sysman -DEMSTATE=/u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_PJKMISDB.localdomain_misdb/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_PJKMISDB.localdomain_misdb/config/java2.policy -Djavax.net.ssl.KeyStore=/u01/app/oracle/product/11.2.0/db_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0/db_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0/db_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_PJKMISDB.localdomain_misdb/config/server.xml
kill -9 20088
之後再次執行回退命令。
[oracle@PJKMISDB OPatch]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 16902043
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/16902043_Nov_23_2015_14_31_43/rollback2015-11-23_14-31-43PM_1.log
Patches will be rolled back in the following order:
16902043 16619892 16056266 14727310 14275605 13923374 13696216 13343438
The following patch(es) will be rolled back: 16902043 16619892 16056266 14727310 14275605 13923374 13696216 13343438
Sub-patches of a composite series are being rolled back. The system will be returned to a state where all subpatches are rolled back.
The following bug fixes will be removed: 14523004,16902043,14198511,12865902,14695377,14191508,16710324,17333197,13072654,13834065,11868640,13605839,14189694,16372203,14007968,13686047,13092220,14003090,14095982,16024441,17333200,12755231,9397635,13440516,13723052,17230530,12784406,15910002,17333202,16362358,13040943,12748538,13843646,12747437,17082364,14128555,14755945,14393728,14762511,17333198,14751895,14188650,13945708,13591624,12899768,12744759,13725395,13642044,16710363,12821418,17333203,12621588,13972394,14791477,16344758,13483354,12796518,12312133,13060271,14351566,16212405,17333199,12815057,17332800,9547706,16794239,14053457,16794240,13790109,12772404,13791364,9095696,16279211,13814739,12395918,12912137,16619892,14512189,16794238,13063120,13907462,16742095,15841373,12731940,16382448,12925089,14571027,16794244,16794241,13855490,16794242,14467061,16703112,15869211,14398795,13489024,13493847,13561750,16694777,12755116,16794243,12940620,14127231,6690853,13015379,7509451,13579992,16306019,16279401,13724193,16014985,15905421,14668670,14301592,13848402,16530565,13857111,13923995,13427062,12974860,11071989,14207317,16344871,16231699,14841558,14176879,14273397,13913630,16056266,13496884,13914613,16382353,16299830,14589750,16314469,14841812,13632809,11715084,16314466,13812031,10242202,13910420,14207163,14644185,13680405,14110275,13584130,16175381,16314467,14220725,14472647,13860201,13561951,16314468,8547978,16314470,14088346,16368108,13582702,9706792,13911821,13786142,13616375,13958038,16294378,12983611,13596521,14459552,14226599,13810393,13098318,15862019,10263668,14040433,13448206,13645875,15862023,15862017,14841409,13719081,13685544,15862016,14023636,12791981,13026410,12857027,14263073,13732226,12873183,13011409,13534412,12345082,13038684,12959852,9659614,13787482,12964067,15853081,14262913,13399435,13559697,15862018,13593999,14546575,13524899,14258925,15862021,14546638,15862020,14546673,15862022,14263036,14727310,14205448,14035825,15862024,14052474,13454210,13936424,13544396,13645917,13807411,14469008,14138130,13099577,14076523,13699124,13612575,13566938,13358781,13773133,13705338,14480675,14409183,13059165,14613900,14664355,13430938,12585543,13624984,12794305,14548763,12594032,13377816,13397104,13080778,13649031,13257247,11708510,14480676,13250244,13476583,12583611,14275605,14480674,13804294,13464002,13484963,13550185,13385346,12693626,13737746,12971775,13384182,13718279,14390252,13572659,13467683,14062793,14062794,14062795,12401111,14062796,13502183,14062797,12797420,12913474,10133521,12678920,13340388,12976376,12617123,13923374,13457582,13103913,11840910,13527323,13035360,12879027,13588248,13419660,14038787,13001379,13370330,12658411,9761357,14063280,9858539,14063281,13981051,13366202,13903046,13657605,13338048,12535346,13916709,12646784,12880299,13326736,14062792,13036331,11877623,12845115,12829021,13554409,12923168,13742464,13332439,12780098,12656535,13070939,12960925,10350832,12612118,13696216,12919564,13632717,12780983,13742433,13742434,13742435,13742436,13742437,13742438,12588744,12748240,12894807,12764337,12582664,12662040,12849688,13354082,13420224,11063191,13772618,13503598,12998795,13466801,13492735,12834027,12620823,13035804,13362079,12718090,13528551,13041324,13343438,12917230,12847466,9703627,12797765,12950644,12905058,13499128,12861463,9873405,12938841
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Rolling back patch 16902043...
RollbackSession rolling back interim patch '16902043' from OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.ldap.rsf, 11.2.0.3.0...
Deleting "ssl_modifycountermeasurescbcchosenplaintextattack.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.a"
Deleting "ssl_setcountermeasurescbcchosenplaintextattack.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.a"
Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...
Patching component oracle.owb.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/DatabaseObjectsSearchController.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/ResponseController.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/storage/tablespace/TSDatafiles.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/storage/tablespace/TablespaceSQLList.class"
RollbackSession removing interim patch '16902043' from inventory
Rolling back patch 16619892...
RollbackSession rolling back interim patch '16619892' from OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.marvel, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Deleting "kstst.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libserver11.a"
Deleting "kststqad.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libserver11.a"
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sysman.agent, 10.2.0.4.3...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16619892_Jun_23_2013_09_03_20/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/showdep/DependQuery.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16619892_Jun_23_2013_09_03_20/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/showdep/TableDependQuery.class"
Patching component oracle.sysman.repository.core, 10.2.0.4.4...
Patching component oracle.xdk, 11.2.0.3.0...
Patching component oracle.xdk.parser.java, 11.2.0.3.0...
Patching component oracle.xdk.rsf, 11.2.0.3.0...
RollbackSession removing interim patch '16619892' from inventory
Rolling back patch 16056266...
RollbackSession rolling back interim patch '16056266' from OH '/u01/app/oracle/product/11.2.0/db_1'
5、開啟登入資料庫，執行相關的包。
[oracle@PJKMISDB admin]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
[oracle@PJKMISDB admin]$ ls -l catbundle*
-rw-r----- 1 oracle oinstall 1498 Mar 2 2014 catbundle_PSU_MISDB_APPLY.sql
-rw-r----- 1 oracle oinstall 1507 Mar 2 2014 catbundle_PSU_MISDB_ROLLBACK.sql
-rw-r--r-- 1 oracle oinstall 29922 Aug 8 2011 catbundle.sql
[oracle@PJKMISDB admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 23 16:35:44 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> @catbundle_PSU_MISDB_ROLLBACK.sql
1、進行新補丁安裝前的衝突檢查，發現與原有補丁衝突。
[oracle@PJKMISDB patch]$ cd 20760982/
[oracle@PJKMISDB 20760982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-11-23_16-11-26PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
There are no patches that can be applied now.
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
16902043, 20760982
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
16902043
Conflicts/Supersets for each patch are:
Patch : 20760982
Bug Conflict with 16902043
Conflicting bugs are:
17332800
Conflict with 16619892
2、檢視安裝補丁的補丁 ID。
[oracle@PJKMISDB OPatch]$ ./opatch lsinventory -patch_id
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-11-23_14-19-55PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-11-23_14-19-55PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (1) :
Patch 16902043 : applied on Sun Mar 02 11:41:20 CST 2014
Unique Patch ID: 16676143
Patch description: "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Created on 24 Sep 2013, 23:20:58 hrs PST8PDT
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
4、將衝突的補丁包回退。
執行下面命令的時候報錯，這是由於 oracle 的程式沒有被關閉乾淨，需要把 oracle 程式關閉乾淨。
[oracle@PJKMISDB OPatch]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 16619892
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Argument(s) Error... ERROR: OPatch would not rollback a sub-patch that is not active. The patch id 16619892 is a sub-patch of the active composite 16902043. OPatch will not rollback patch(es) 16619892 until you have rolled back 16902043.
Please check the arguments and try again.
OPatch failed with error code 135
[oracle@PJKMISDB OPatch]$ ps -ef |grep oracle
oracle 3466 9981 0 Sep11 ? 01:06:59 /u01/app/oracle/product/11.2.0/db_1/bin/emagent
root 6481 1 0 2014 ? 00:00:01 /usr/local/oracle/backup/.etc.linux86_64/observiced -b
oracle 9981 1 0 May13 ? 00:32:46 /u01/app/oracle/product/11.2.0/db_1/perl/bin/perl /u01/app/oracle/product/11.2.0/db_1/bin/emwd.pl dbconsole /u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb/sysman/log/emdb.nohup
root 11189 6416 0 13:23 ? 00:00:00 sshd: oracle [priv]
oracle 11194 11189 0 13:23 ? 00:00:00 sshd: oracle@pts/2
oracle 11195 11194 0 13:23 pts/2 00:00:00 -bash
root 11379 6416 0 13:26 ? 00:00:00 sshd: oracle [priv]
oracle 11383 11379 0 13:26 ? 00:00:00 sshd: oracle@pts/3
oracle 11384 11383 0 13:26 pts/3 00:00:00 -bash
root 12726 6416 0 13:36 ? 00:00:00 sshd: oracle [priv]
oracle 12731 12726 0 13:36 ? 00:00:00 sshd: oracle@pts/4
oracle 12732 12731 0 13:36 pts/4 00:00:00 -bash
root 14545 6416 0 13:50 ? 00:00:00 sshd: oracle [priv]
oracle 14549 14545 0 13:50 ? 00:00:00 sshd: oracle@pts/1
oracle 14550 14549 0 13:50 pts/1 00:00:00 -bash
oracle 17234 14550 0 14:14 pts/1 00:00:00 vim 01.txt
root 17722 6416 0 14:18 ? 00:00:00 sshd: oracle [priv]
oracle 17726 17722 0 14:18 ? 00:00:00 sshd: oracle@pts/5
oracle 17727 17726 0 14:18 pts/5 00:00:00 -bash
oracle 19613 12732 0 14:25 pts/4 00:00:00 vim /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/16902043_Nov_23_2015_14_24_23/rollback2015-11-23_14-24-23PM_1.log
oracle 20088 9981 43 14:28 ? 00:00:20 /u01/app/oracle/product/11.2.0/db_1/jdk/bin/java -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 -Doracle.home=/u01/app/oracle/product/11.2.0/db_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb/sysman -DEMSTATE=/u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_PJKMISDB.localdomain_misdb/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_PJKMISDB.localdomain_misdb/config/java2.policy -Djavax.net.ssl.KeyStore=/u01/app/oracle/product/11.2.0/db_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/11.2.0/db_1/PJKMISDB.localdomain_misdb -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0/db_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0/db_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_PJKMISDB.localdomain_misdb/config/server.xml
之後再次執行回退命令。
[oracle@PJKMISDB OPatch]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch rollback -id 16902043
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/16902043_Nov_23_2015_14_31_43/rollback2015-11-23_14-31-43PM_1.log
Patches will be rolled back in the following order:
16902043 16619892 16056266 14727310 14275605 13923374 13696216 13343438
The following patch(es) will be rolled back: 16902043 16619892 16056266 14727310 14275605 13923374 13696216 13343438
Sub-patches of a composite series are being rolled back. The system will be returned to a state where all subpatches are rolled back.
The following bug fixes will be removed: 14523004,16902043,14198511,12865902,14695377,14191508,16710324,17333197,13072654,13834065,11868640,13605839,14189694,16372203,14007968,13686047,13092220,14003090,14095982,16024441,17333200,12755231,9397635,13440516,13723052,17230530,12784406,15910002,17333202,16362358,13040943,12748538,13843646,12747437,17082364,14128555,14755945,14393728,14762511,17333198,14751895,14188650,13945708,13591624,12899768,12744759,13725395,13642044,16710363,12821418,17333203,12621588,13972394,14791477,16344758,13483354,12796518,12312133,13060271,14351566,16212405,17333199,12815057,17332800,9547706,16794239,14053457,16794240,13790109,12772404,13791364,9095696,16279211,13814739,12395918,12912137,16619892,14512189,16794238,13063120,13907462,16742095,15841373,12731940,16382448,12925089,14571027,16794244,16794241,13855490,16794242,14467061,16703112,15869211,14398795,13489024,13493847,13561750,16694777,12755116,16794243,12940620,14127231,6690853,13015379,7509451,13579992,16306019,16279401,13724193,16014985,15905421,14668670,14301592,13848402,16530565,13857111,13923995,13427062,12974860,11071989,14207317,16344871,16231699,14841558,14176879,14273397,13913630,16056266,13496884,13914613,16382353,16299830,14589750,16314469,14841812,13632809,11715084,16314466,13812031,10242202,13910420,14207163,14644185,13680405,14110275,13584130,16175381,16314467,14220725,14472647,13860201,13561951,16314468,8547978,16314470,14088346,16368108,13582702,9706792,13911821,13786142,13616375,13958038,16294378,12983611,13596521,14459552,14226599,13810393,13098318,15862019,10263668,14040433,13448206,13645875,15862023,15862017,14841409,13719081,13685544,15862016,14023636,12791981,13026410,12857027,14263073,13732226,12873183,13011409,13534412,12345082,13038684,12959852,9659614,13787482,12964067,15853081,14262913,13399435,13559697,15862018,13593999,14546575,13524899,14258925,15862021,14546638,15862020,14546673,15862022,14263036,14727310,14205448,14035825,15862024,14052474,13454210,13936424,13544396,13645917,13807411,14469008,14138130,13099577,14076523,13699124,13612575,13566938,13358781,13773133,13705338,14480675,14409183,13059165,14613900,14664355,13430938,12585543,13624984,12794305,14548763,12594032,13377816,13397104,13080778,13649031,13257247,11708510,14480676,13250244,13476583,12583611,14275605,14480674,13804294,13464002,13484963,13550185,13385346,12693626,13737746,12971775,13384182,13718279,14390252,13572659,13467683,14062793,14062794,14062795,12401111,14062796,13502183,14062797,12797420,12913474,10133521,12678920,13340388,12976376,12617123,13923374,13457582,13103913,11840910,13527323,13035360,12879027,13588248,13419660,14038787,13001379,13370330,12658411,9761357,14063280,9858539,14063281,13981051,13366202,13903046,13657605,13338048,12535346,13916709,12646784,12880299,13326736,14062792,13036331,11877623,12845115,12829021,13554409,12923168,13742464,13332439,12780098,12656535,13070939,12960925,10350832,12612118,13696216,12919564,13632717,12780983,13742433,13742434,13742435,13742436,13742437,13742438,12588744,12748240,12894807,12764337,12582664,12662040,12849688,13354082,13420224,11063191,13772618,13503598,12998795,13466801,13492735,12834027,12620823,13035804,13362079,12718090,13528551,13041324,13343438,12917230,12847466,9703627,12797765,12950644,12905058,13499128,12861463,9873405,12938841
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Rolling back patch 16902043...
RollbackSession rolling back interim patch '16902043' from OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.ldap.rsf, 11.2.0.3.0...
Deleting "ssl_modifycountermeasurescbcchosenplaintextattack.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.a"
Deleting "ssl_setcountermeasurescbcchosenplaintextattack.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.a"
Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...
Patching component oracle.owb.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/DatabaseObjectsSearchController.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/ResponseController.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/storage/tablespace/TSDatafiles.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16902043_Sep_24_2013_23_20_58/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/storage/tablespace/TablespaceSQLList.class"
RollbackSession removing interim patch '16902043' from inventory
Rolling back patch 16619892...
RollbackSession rolling back interim patch '16619892' from OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.marvel, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Deleting "kstst.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libserver11.a"
Deleting "kststqad.o" from archive "/u01/app/oracle/product/11.2.0/db_1/lib/libserver11.a"
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sysman.agent, 10.2.0.4.3...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16619892_Jun_23_2013_09_03_20/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/showdep/DependQuery.class"
Updating jar file "/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/db_1/.patch_storage/16619892_Jun_23_2013_09_03_20/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/showdep/TableDependQuery.class"
Patching component oracle.sysman.repository.core, 10.2.0.4.4...
Patching component oracle.xdk, 11.2.0.3.0...
Patching component oracle.xdk.parser.java, 11.2.0.3.0...
Patching component oracle.xdk.rsf, 11.2.0.3.0...
RollbackSession removing interim patch '16619892' from inventory
Rolling back patch 16056266...
RollbackSession rolling back interim patch '16056266' from OH '/u01/app/oracle/product/11.2.0/db_1'
[oracle@PJKMISDB admin]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin/
[oracle@PJKMISDB admin]$ ls -l catbundle*
-rw-r----- 1 oracle oinstall 1498 Mar 2 2014 catbundle_PSU_MISDB_APPLY.sql
-rw-r----- 1 oracle oinstall 1507 Mar 2 2014 catbundle_PSU_MISDB_ROLLBACK.sql
-rw-r--r-- 1 oracle oinstall 29922 Aug 8 2011 catbundle.sql
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 23 16:35:44 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> @catbundle_PSU_MISDB_ROLLBACK.sql
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28211342/viewspace-2136262/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- List of Oracle Database Patch Set Updates (PSU)OracleDatabase
- 老託的Oracle 資料庫Patch概念性小常識 PSU，CPU，bundle patchOracle資料庫
- Quick Reference to Patch Numbers for Database PSUUIDatabase
- AIX7.1下oracle RAC PSU 11.2.0.4.8 Patch 失敗AIOracle
- Oracle Database常用補丁集Patch號及各版本PSUOracleDatabase
- 關於Oracle Database PSU/SPU/Bundle Patch的補丁號的變化OracleDatabase
- ORACLE 11g 升級補丁（Patch）Oracle
- 關於 Oracle 資料庫 PSU/SPU/Bundle Patch的補丁號變化Oracle資料庫
- Oracle 11G PSU 31326410 PSU apply failed 處理-拾億OracleAPPAI
- Oracle 11g升級PSU詳細步驟Oracle
- PSU的GI升級，ERROR: This patch is not applicable to GI home.ErrorAPP
- Oracle 11g RAC自動打GI PSU補丁Oracle
- Oracle 10g/11g 升級psu步驟Oracle 10g
- My Oracle Support上搜尋Patch Set的方法Oracle
- Oracle PSU （Patch Set Update）- 10g補丁列表及如何檢視補丁Oracle
- zt_oracle psu_cpu_bundle補丁patch升級upgrade相關概念Oracle
- 補丁集PSU、Bundle Patch大致安裝步驟
- Linux 11g rac PSULinux
- Oracle 11g RAC 環境打PSU補丁的詳細步驟Oracle
- Oracle 11g RAC自動打GI PSU補丁(11.2.0.4.8)Oracle
- 【PSU】Oracle打PSU及解除安裝PSU（單例項）Oracle單例
- git 版本回退方法Git
- Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets_1454618.1Database
- oracle 11g Oracle Database Vault 的配置方法OracleDatabase
- 【PSU】Oracle11g_psu_include_gridOracle
- Oracle PSU 簡介Oracle
- Oracle psu查詢Oracle
- Oracle 11G PSU命名變化及Oracle 12.2.0.2開始以年度來命名版本Oracle
- goldengate 11g patch set 1的新特性Go
- oracle安裝patchOracle
- Oracle ebs patch typeOracle
- 單機 Oracle 11g(11.2.0.4)手動打補丁PSU(11.2.0.4.8)Oracle
- ORACLE 11g R2 RAC 11.2.0.2.12 PSU 安裝升級Oracle
- Oracle11g 11.2.0.3升級失敗後的兩種回退方法Oracle
- 資料庫Oracle 11g RAC手動打GI PSU補丁(11.2.0.4.8)資料庫Oracle
- oracle 11g racscan IP 方法Oracle
- oracle 10g patchOracle 10g
- Oracle 11.2.0.2.0 patch setOracle