●1)GI_HOMEにDBBP適用（ディスク使用量は６GB増えた）
●2)DB_HOMEの個別パッチをロールバック
set lines 10000
set pages 10000
select PATCH_ID ,ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;
PATCH_ID ACTION STATUS ACTION_TIME
---------- --------------------------------------------- ------------------------
26717470 APPLY SUCCESS 20-05-21 00:07:52.262289
25139545 APPLY SUCCESS 20-05-21 00:33:38.168848
[oracle@fordbbp 25139545]$ opatch lsinventory
[oracle@fordbbp 25139545]$ opatch rollback -id 25139545
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.9
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-22_23-45-59PM_1.log
Patches will be rolled back in the following order:
25139545
The following patch(es) will be rolled back: 25139545
Rolling back patch 25139545...
RollbackSession rolling back interim patch '25139545' from OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
RollbackSession removing interim patch '25139545' from inventory
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-05-22_23-45-59PM_1.log
OPatch succeeded.
SQL> select PATCH_ID ,ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;
PATCH_ID ACTION STATUS ACTION_TIME
---------- --------------------------------------------- ------------------------------
26717470 APPLY SUCCESS 20-05-21 00:07:52.262289
25139545 APPLY SUCCESS 20-05-21 00:33:38.168848
25139545 ROLLBACK BEGIN 20-05-22 23:49:22.138312
[oracle@fordbbp 25139545]$ cd /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/
[oracle@fordbbp OPatch]$ unset NLS_LANG
[oracle@fordbbp OPatch]$ datapatch -verbose
SQL> select PATCH_ID ,ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;
PATCH_ID ACTION STATUS ACTION_TIME
---------- --------------------------------------------- ------------------------------
26717470 APPLY SUCCESS 20-05-21 00:07:52.262289
25139545 APPLY SUCCESS 20-05-21 00:33:38.168848
25139545 ROLLBACK SUCCESS 20-05-23 00:01:39.985511
●3)DB_HOMEにDBBP適用（ディスク使用量は２GB増えた）
[root@fordbbp 29698629]# . /home/oracle/.bash_profile
[root@fordbbp 29698629]# opatchauto apply /work/29698629 -oh $ORACLE_HOME
[oracle@fordbbp ~]$ cd $ORACLE_HOME/OPatch
[oracle@fordbbp OPatch]$ unset NLS_LANG
[oracle@fordbbp OPatch]$ ./datapatch -verbose
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
失敗した。↑のようなエラーがログファイルに書かれており、
↓の措置を行ったところ、成功した。
12.1: ORA-20001: Latest Xml Inventory Is Not Loaded Into Table, KUP-04017: OS message: Picked up _JAVA_OPTIONS: (Doc ID 2172655.1)
1)unset _JAVA_OPTIONS
$ unset _JAVA_OPTIONS
2)Verify it does not give any output:
env|grep -i _JAVA_OPTIONS
3) Verify the Queryable Patch Inventory is fine :
SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;
SQL> select * from OPATCH_XML_INV ;
4)Re-run datapatch
＝＝datapatch成功後＝＝
set lines 10000
set pages 10000
select PATCH_ID ,ACTION, STATUS, ACTION_TIME from DBA_REGISTRY_SQLPATCH;
PATCH_ID ACTION STATUS ACTION_TIME
---------- --------------------------------------------- ------------------------
26717470 APPLY SUCCESS 21-MAY-20 12.07.52.262289 AM
25139545 APPLY SUCCESS 21-MAY-20 12.33.38.168848 AM
25139545 ROLLBACK SUCCESS 23-MAY-20 12.01.39.985511 AM
29496791 APPLY WITH ERRORS 23-MAY-20 12.39.21.907289 AM
29496791 APPLY SUCCESS 23-MAY-20 01.27.23.915953 AM