Monthly Archives: July 2019

Java (1.6) could not be located

Posted by antonionavarror on

Executing the command opatch lsinventory I get the next error;

 
Java (1.6) could not be located. OPatch cannot proceed!
OPatch returns with error code = 1

Check the current Java version with java -version return the next output;

 
java version "1.8.0_172"
Java(TM) SE Runtime Environment (build 1.8.0_172-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.172-b11, mixed mode)

It looks like don’t found the java 1.6, however 1.8 must work fine. In this case I haven’t time to investigate the problem. I solved it by using the java into the ORACLE_HOME. With flag -jdk you can set up the path to a specified java you want to use.

opatch lsinventory -jdk $ORACLE_HOME/jdk

HTH – Antonio NAVARRO

Install PSU July.2019 For 12.1.0.2 (linux)

Posted by antonionavarror on

I installing PSU 29494060 July.2019 (Included on 29698592). First of all check conficts. In my case I have a conflict

 
[oracle@localhost 29494060]$ cd /oracle/product/12.1.0.2/db_1/OPatch                                                                       
[oracle@localhost OPatch]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/soft12/29698592/29494060 -jdk $ORACLE_HOME/jdk
Oracle Interim Patch Installer version 12.2.0.1.17                                                                                         
Copyright (c) 2019, Oracle Corporation.  All rights reserved.                                                                              

PREREQ session                                                                                                                             

Oracle Home       : /oracle/product/12.1.0.2/db_1                                                                                          
Central Inventory : /oracle/oraInventory                                                                                                   
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc                                                                              
OPatch version    : 12.2.0.1.17                                                                                                            
OUI version       : 12.1.0.2.0                                                                                                             
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_13-23-51PM_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 :                                  
22467685, 29494060                                                                                                                         

Whole composite patch Conflicts/Supersets are:                                                                                             

Composite Patch : 29494060                                                                                                                 

	Conflict with 22467685                                                                                                                   

Detail Conflicts/Supersets for each patch are:                                                                                             

Sub-Patch : 26925311                                                                                                                       

	Conflict with 22467685                                                                                                                   
	Conflict details:                                                                                                                        
	/oracle/product/12.1.0.2/db_1/lib/libserver12.a:kta.o                                                                                    

OPatch succeeded.

In this case Composite Patch 29494060 conflict with 22467685
Rollback one-off (29494060);

 
[oracle@localhost 22467685]$ opatch rollback -id 22467685 -jdk $ORACLE_HOME/jdk                       
Oracle Interim Patch Installer version 12.2.0.1.17                                                    
Copyright (c) 2019, Oracle Corporation.  All rights reserved.                                         

Oracle Home       : /oracle/product/12.1.0.2/db_1                                                     
Central Inventory : /oracle/oraInventory                                                              
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc                                         
OPatch version    : 12.2.0.1.17                                                                       
OUI version       : 12.1.0.2.0                                                                        
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_14-22-35PM_1.log

Patches will be rolled back in the following order:                                                   
   22467685                                                                                           
The following patch(es) will be rolled back: 22467685                                                 

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.                 
(Oracle Home = '/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 22467685...                                                                        

RollbackSession rolling back interim patch '22467685' from OH '/oracle/product/12.1.0.2/db_1'         

Patching component oracle.rdbms, 12.1.0.2.0...                                                        
RollbackSession removing interim patch '22467685' from inventory                                      
Log file location: /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_14-22-35PM_1.log 

OPatch succeeded.

Check again;

 
[oracle@localhost 29494060]$  cd /oracle/product/12.1.0.2/db_1/OPatch 
[oracle@localhost OPatch]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/soft12/29698592/29494060 -jdk $ORACLE_HOME/jdk
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_14-33-47PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Apply the PSU;

 
[oracle@localhost 29494060]$ opatch apply -jdk $ORACLE_HOME/jdk
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_14-38-26PM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_14-39-46PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   19769480  20299023  20831110  21359755  21948354  22291127  23054246  24006101  24732082  25171037  25755742  26609783  26713565  26925311  27338041  27547329  28259833  28729169  29141015  29494060  

Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/product/12.1.0.2/db_1')

Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying sub-patch '19769480' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.util, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf.ic, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20831110' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '21359755' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '21948354' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...
Applying sub-patch '22291127' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Applying sub-patch '23054246' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.install.deinstalltool, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.ctx.atg, 12.1.0.2.0...
Applying sub-patch '24006101' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '24732082' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying sub-patch '25171037' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...

Patching component oracle.ordim.jai, 12.1.0.2.0...

Patching component oracle.ordim.server, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...

Patching component oracle.javavm.containers, 12.1.0.2.0...
Applying sub-patch '25755742' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26609783' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...
Applying sub-patch '26713565' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] , [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...
Applying sub-patch '26925311' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying sub-patch '27338041' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.assistants.asm, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.rsf, 12.1.0.2.0...
Applying sub-patch '27547329' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ctx.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '28259833' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...
Applying sub-patch '28729169' to OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '29141015' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '29494060' to OH '/oracle/product/12.1.0.2/db_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.ctx.rsf, 12.1.0.2.0...

OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of ‘/oracle/product/12.1.0.2/db_1/bin/extjobO’: Operation not permitted
make: [iextjob] Error 1 (ignored)

Composite patch 29494060 successfully applied.
OPatch Session completed with warnings.
Log file location: /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_14-39-46PM_1.log

OPatch completed with warnings.

Apply the one-off again (22467685);

 
[oracle@localhost 22467685]$ opatch apply -jdk $ORACLE_HOME/jdk
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_15-05-02PM_1.log

Verifying environment and performing prerequisite checks...

Whole composite patch Conflicts/Supersets are:

Patch : 22467685

	Conflict with Composite Patch 29494060

Detail Conflicts/Supersets for each patch are:

Patch : 22467685

	Conflict with Sub-Patch 26925311
	Conflict details:
	/oracle/product/12.1.0.2/db_1/lib/libserver12.a:kta.o

Following patches have conflicts: [   22467685   29494060 ]
Use the MOS Patch Conflict Checker "https://support.oracle.com/epmos/faces/PatchConflictCheck" to resolve.
See MOS documents 1941934.1 and 1299688.1 for additional information and resolution methods.

UtilSession failed: Inter-conflict checking failed in apply incoming patches
Log file location: /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_15-05-02PM_1.log

OPatch failed with error code 73

Deinstall PSU (29494060)

 
[oracle@localhost 29698592]$ cd 29494060
[oracle@localhost 29494060]$ pwd
/oracle/soft12/29698592/29494060
[oracle@localhost 29494060]$ opatch rollback -id 29494060 -jdk $ORACLE_HOME/jdk 
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_21-40-31PM_1.log

Patches will be rolled back in the following order: 
   29494060   29141015   28729169   28259833   27547329   27338041   26925311   26713565   26609783   25755742   25171037   24732082   24006101   23054246   22291127   21948354   21359755   20831110   20299023   19769480

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_21-41-26PM_1.log

Patches will be rolled back in the following order: 
   29494060   29141015   28729169   28259833   27547329   27338041   26925311   26713565   26609783   25755742   25171037   24732082   24006101   23054246   22291127   21948354   21359755   20831110   20299023   19769480
The following patch(es) will be rolled back: 29494060  29141015  28729169  28259833  27547329  27338041  26925311  26713565  26609783  25755742  25171037  24732082  24006101  23054246  22291127  21948354  21359755  20831110  20299023  19769480  
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: 17495022,18548433,18818069,19297917,19330795,19354794,19450116,19548064,19601762,19809171,19871910,19930276,19931367,20169408,20354900,20554364,20657411,20677974,20684983,20757079,20768076,21101873,21159665,21425496,21566639,21695575,21698350,22018363,22205263,22250006,22495062,22515353,22606521,22690648,22820579,22836801,23061702,23177923,23209741,23272045,23328639,24303148,24792678,24907917,24966594,25042823,25051465,25107334,25248384,25417056,25695903,25699321,25997810,26198757,26203182,26482376,27710072,27846298,28026866,28357401,28390273,28501075,28612674,28986231,29189889,29200700,29378913,29379978,29388020,29437712,29511611,14705949,16875041,17258582,18373438,18382302,18628388,18904062,19017309,19180394,19332396,19339555,19373893,19445860,19516448,19523462,19663176,19781326,19790243,19995869,20001168,20011515,20134113,20298413,20582405,20766180,21061354,21157728,21186167,21197626,21502702,21893235,22243983,22517782,22533631,22782647,23002524,23101501,23184263,23854396,24385625,24457597,25300427,25722055,25986062,26007010,26324206,26439748,26556014,26654363,26875822,27255377,27348081,27634991,27751755,27986817,28023399,28420042,28432129,28578164,28587723,28849751,29006527,29027694,29030780,29142109,29408136,13787015,18475439,18742258,19375649,19529868,20087383,20144019,20229001,20468401,20468490,20613079,20978259,21383171,21967197,22475617,22568177,22568797,23148260,23326313,23571055,23628685,25047724,25093872,25240188,25489367,25599425,25616268,25822410,26110259,26121990,26248143,26336977,26412540,27097854,27223075,27397048,27445727,27567477,27995248,28022101,28636676,28683167,28708023,28950969,28993590,16354467,18272672,18604692,19718981,19891090,20273319,20493163,20725343,20736227,20856766,21063322,21147908,21522582,21656630,21842740,22007324,22305887,22364044,22654475,22808310,22894949,22901797,22972770,22977256,23061453,23115139,23140259,23151677,23302839,23315153,23514710,23567857,23642282,23709062,24326444,24737064,24737581,24848928,25058080,25307368,25489342,25492379,25555252,25634317,25635149,25670786,25775213,25780343,25879984,25914276,26153977,26243698,26318627,26633558,26637824,26822620,26828994,27012701,27052607,27229389,27314390,27351628,27375542,27726780,28000269,28174827,18308268,18868646,19578247,20118035,20302006,20641666,21174504,21260397,21641414,22228324,22760595,23008056,23172924,23195445,24321547,24393981,24589081,24600330,24683149,24717859,24790914,25029423,25353983,25417958,25495682,25639019,25653109,25669791,25760195,25789277,25790353,25919622,26029780,26039623,26089440,26245237,26262953,26263721,26714910,26784509,27199245,27207110,27314206,27370965,27534509,27847259,27938623,27997875,23725036,6418158,17533661,18604493,18774543,19932634,20505778,21828126,21913183,22232606,22730454,22734547,22922076,23019710,24350620,24563422,24713381,24737403,24801152,25123585,25357142,25392535,25437699,25551676,25575628,25633101,25856821,26187943,26256131,26513709,26658759,27034890,27060167,27086138,27169796,27213224,27337759,27441326,27548131,27620950,18419520,18849970,19211433,19370504,20324049,20382309,20470877,20480209,20717359,21281607,21641760,21773465,22256560,22366322,22492533,22518784,22536802,22645009,22707866,22721409,22729345,22826718,23007241,23065323,23088803,23105538,23237313,23528412,23543183,23572982,24365589,24385983,24401351,24415926,24461826,24509056,24570598,24624166,24718260,24796092,24831514,24929210,25150925,25165496,25178179,25192729,25313154,25764020,26024732,26366517,26569225,26758193,26898563,18110491,18371441,18542562,19285025,19708342,20144308,20424183,20830459,20860659,20938170,21241052,21429602,21492036,21532755,21623164,21625179,21794615,21795111,21842017,21863727,22068305,22087683,22179537,22238921,22256431,22454326,22503297,22519146,22707244,22806698,22816287,22842151,22855193,22862134,22897344,22950945,22961508,23003979,23035249,23053606,23068169,23084507,23108128,23125826,23149541,23240358,23315889,23338911,23492665,23521523,23548817,23713236,24341675,24421668,24555417,24642295,24652769,24662775,24719736,25034396,25429959,25489607,25654936,25861398,25897615,25947799,26088426,26111842,26198926,26430737,26444887,26446098,25602488,26546664,26546754,26544823,26575788,17409174,18007682,18051556,18090142,18866977,19207117,19404068,19562381,20076781,20172151,20432873,20437153,20513399,20557786,20603431,20671094,20717081,20828947,20835241,21080143,21132297,21514877,21626377,21644640,21780146,22624709,23026585,23294548,23533807,24560906,24573817,24674955,24835538,24908321,25091141,25110233,25423453,25427662,25459958,25484507,25547060,25600342,25600421,25606091,25612095,25643931,25655390,25766822,25823754,25957038,25982666,16756406,16941434,17008068,18440095,19124336,19213447,19383839,19503821,19593445,20171986,20250147,20322560,20368850,20543011,20569094,20673810,20703000,20862087,20878790,21142837,21164318,21297872,21299490,21419850,21422580,21868720,21889720,21911701,21977392,22062517,22351572,22520320,22905130,23096938,24350831,24411921,25079710,25093739,25330273,25475853,25483815,25490238,25539063,25546608,16777441,18254023,18307021,18510194,18840932,18974476,19469538,19475971,19818513,20031873,20181030,20315311,20401975,20562898,20591183,20677396,20803014,20879709,20882568,20936731,21059919,21060755,21072646,21106027,21133343,21172913,21196809,21285458,21294938,21354456,21380789,21476308,21542577,21575362,21896069,22022760,22077517,22165897,22294260,22359063,22365117,22458049,22496904,22529728,22695831,22809871,23025340,23089357,23170620,23197103,23220453,23314180,23324000,23501901,23533524,24285405,24308635,24397438,24413809,24437510,24523374,24690216,24693382,24739928,24808595,24812585,24825843,25056052,25161298,25264559,22160989,21479753,21387964,20844426,22175564,20212067,22657942,22465352,18705806,20581111,20328248,21785691,22865673,20627866,20475845,20139391,24316947,22148226,20734332,21239530,21097043,19171086,22083366,20466322,21266085,20464614,21632821,20907061,18122373,23124895,19461270,20217801,22757364,20922010,22223463,20859910,19188927,21387128,18819908,21960504,20842388,20603378,20704450,20560611,17210525,19908836,19363645,20598042,24386767,22916353,22024071,20017509,20428621,22243719,24577566,21322887,20669434,20832516,19662635,18899974,18043064,6599380,20897759,23260854,20009833,18191823,17867700,20228093,19578350,17319928,19534363,21241829,20898997,19308965,20848335,20267166,21373076,21450666,19402853,20920911,17532734,17414008,22178855,19931709,20977794,23229229,22815955,22551446,21373473,21296029,19524158,20880215,21649497,21629064,14283239,18851894,20378086,22923409,22380919,21665897,22507210,21184223,21220620,19201867,18740837,20528052,22075064,20868862,21099555,22507234,22366558,17722075,21188584,16863642,21263635,20898391,22296366,21246723,18549238,21291274,19366375,19013183,18797519,20708701,20798891,22168163,18893947,19333670,20825533,20879889,21756677,16439813,20466628,22173980,21899588,19883092,21329301,13542050,20711718,18499088,20596234,22528741,18914624,21915719,19835133,20117253,20904530,18990023,21273804,20936905,20356733,22046677,21756661,22353199,21260431,20952966,21315084,19354335,19777862,19990037,21153266,21917884,21091431,20373598,22762046,21744290,19639483,19258504,21847223,19888853,22374754,19450314,16923858,20043616,20124446,19676012,22353346,19721304,20831538,19591608,20447445,20794034,19490948,19689979,19902195,19869255,21787056,17655240,21517440,21300341,20173897,21668627,21526048,16887946,17551063,19879746,20101006,20618595,22092979,20318889,19326908,18973548,18799063,20877664,21756699,21875360,18886413,21188532,20869721,20890311,20446883,20509482,17890099,20588502,19604659,20951038,18799993,19141838,19243521,20048359,19571367,20397490,20476175,20925795,21442094,20245930,20134339,21281532,21421886,20413820,18966843,20441797,20281121,21620471,19791273,20361671,18411216,19587324,19032777,19468991,17365043,22062026,20471920,18743542,20688221,20122715,20424899,19307662,20746251,20919320,20331945,20657441,20387265,20294666,19703301,20165574,20899461,20558005,19399918,20402832,21225209,19284031,20474192,19699191,20093776,19989009,20440930,18306996,19865345,19536415,18607546,19487147,19035573,19873610,19081128,19606174,19272708,17274537,19358317,19291380,19012119,19687159,19547370,20348653,20425790,19524384,19385656,19928926,18681056,19512341,18856999,16619249,19018447,19393542,20235511,19627012,19649152,19670108,19684504,18417036,20347562,19658708,19896336,19805359,19637186,18940497,19183343,19978542,19644859,18202441,19023822,19791377,18909599,19335438,19238590,19841800,19619732,19315691,19730508,19597583,19065677,19915271,20284155,19157754,18885870,19303936,19708632,19371175,18618122,19329654,19075256,19074147,19044962,19289642,19068610,18988834,19028800,19561643,19058490,19390567,18967382,19174942,19174521,19176223,19501299,19178851,18948177,18674047,19723336,19189525,19001390,19176326,19280225,19143550,18250893,19180770,19155797,19016730,19185876,18354830,19067244,18845653,18849537,18964978,19065556,19440586,19439759,19024808,18952989,18990693,19052488,19189317,19409212,19124589,19154375,19279273,19468347,19054077,19048007,19248799,19018206,18921743,14643995,18456643,16870214,19434529,19706965,17835294,20074391,18791688,19197175,19134173,19174430,19050649,19769480,19077215,19577410,18288842,18436647,19520602,19149990,19076343,19195895,18610915,19068970,19518079,19304354,19001359,19676905,19309466,19382851,18964939,16359751,19022470,19532017,19597439,18674024,19430401

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/product/12.1.0.2/db_1')

Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y

Rolling back patch 29494060...

RollbackSession rolling back interim patch '29494060' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...
Deleting "slmeset.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libcore12.a"

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.ctx.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '29494060' from inventory

Rolling back patch 29141015...

RollbackSession rolling back interim patch '29141015' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
RollbackSession removing interim patch '29141015' from inventory

Rolling back patch 28729169...

RollbackSession rolling back interim patch '28729169' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '28729169' from inventory

Rolling back patch 28259833...

RollbackSession rolling back interim patch '28259833' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...
RollbackSession removing interim patch '28259833' from inventory

Rolling back patch 27547329...

RollbackSession rolling back interim patch '27547329' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ctx.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '27547329' from inventory

Rolling back patch 27338041...

RollbackSession rolling back interim patch '27338041' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '27338041' from inventory

Rolling back patch 26925311...

RollbackSession rolling back interim patch '26925311' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
RollbackSession removing interim patch '26925311' from inventory

Rolling back patch 26713565...

RollbackSession rolling back interim patch '26713565' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.rdbms.crs, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...
RollbackSession removing interim patch '26713565' from inventory

Rolling back patch 26609783...

RollbackSession rolling back interim patch '26609783' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '26609783' from inventory

Rolling back patch 25755742...

RollbackSession rolling back interim patch '25755742' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...
Deleting "kscs.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libserver12.a"

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Deleting "kgcs.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libgeneric12.a"

Patching component oracle.rdbms.rman, 12.1.0.2.0...
RollbackSession removing interim patch '25755742' from inventory

Rolling back patch 25171037...

RollbackSession rolling back interim patch '25171037' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...

Patching component oracle.ordim.client, 12.1.0.2.0...

Patching component oracle.ordim.jai, 12.1.0.2.0...

Patching component oracle.ordim.server, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...

Patching component oracle.javavm.containers, 12.1.0.2.0...
RollbackSession removing interim patch '25171037' from inventory

Rolling back patch 24732082...

RollbackSession rolling back interim patch '24732082' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.install.plugins, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
RollbackSession removing interim patch '24732082' from inventory

Rolling back patch 24006101...

RollbackSession rolling back interim patch '24006101' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '24006101' from inventory

Rolling back patch 23054246...

RollbackSession rolling back interim patch '23054246' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Deleting "pevmreg.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libpls12_pic.a"
Deleting "pevmsql.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libpls12_pic.a"
Deleting "pfrdis.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libpls12_pic.a"
Deleting "phd.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libpls12_pic.a"
Deleting "ph2imt.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libpls12_pic.a"

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.install.deinstalltool, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.ctx.atg, 12.1.0.2.0...
RollbackSession removing interim patch '23054246' from inventory

Rolling back patch 22291127...

RollbackSession rolling back interim patch '22291127' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Deleting "phn.o" from archive "/oracle/product/12.1.0.2/db_1/lib/libpls12_pic.a"

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
RollbackSession removing interim patch '22291127' from inventory

Rolling back patch 21948354...

RollbackSession rolling back interim patch '21948354' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '21948354' from inventory

Rolling back patch 21359755...

RollbackSession rolling back interim patch '21359755' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
RollbackSession removing interim patch '21359755' from inventory

Rolling back patch 20831110...

RollbackSession rolling back interim patch '20831110' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
RollbackSession removing interim patch '20831110' from inventory

Rolling back patch 20299023...

RollbackSession rolling back interim patch '20299023' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf.ic, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
RollbackSession removing interim patch '20299023' from inventory

Rolling back patch 19769480...

RollbackSession rolling back interim patch '19769480' from OH '/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.util, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
RollbackSession removing interim patch '19769480' from inventory
Log file location: /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_21-41-26PM_1.log

OPatch succeeded.
[oracle@localhost 29494060]$

Check again the inventory;

 

 
[oracle@localhost 29494060]$ opatch lsinventory -jdk $ORACLE_HOME/jdk
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/product/12.1.0.2/db_1
Central Inventory : /oracle/oraInventory
   from           : /oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2019-07-29_22-10-29PM_1.log

Lsinventory Output file location : /oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-07-29_22-10-29PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
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.

--------------------------------------------------------------------------------

OPatch succeeded.

HTH – Antonio NAVARRO

 

ORA-15260 Error Dropping Diskgroup

Posted by antonionavarror on

Today I was dropping an asm diskgroup, with the next command;

drop diskgroup CLOUD_DATA_DG;

When I got the next error;

ERROR at line 1:
ORA-15260: permission denied on ASM disk group

The problem here, really is very simple. It is because I have connected to the ASM instance as sysdba (whenever I connect to a database). And the solution is as simple as connecting as sysdba 😦

HTH – Antonio NAVARRO

Create DB Link In Other Schema

Posted by antonionavarror on

Today I want to remember an old method to create database links, it is also valid for other types of objects, when we do not have the password of the user owner or who is going to host the object created.

The trick is basically to create a series of procedures, putting as owner the schema where we want to create the database link. For this we must also have permission (create any procedure). Let’s see how it would be

# Step 1

 
REM
REM Create the procedure
REM 
CREATE OR REPLACE PROCEDURE CLOUD.WRAP_ANR IS
BEGIN
  EXECUTE IMMEDIATE 'CREATE DATABASE LINK TEST1 CONNECT TO REMOTEUSER IDENTIFIED BY "SECRET" USING ''REMOTE_CS'' ';
END;
/

# Step 2

REM
REM  Execute the procedure for create the DB Link.
REM 
BEGIN
  CLOUD.WRAP_ANR;
END;
/

# Step 3

REM
REM  Drop the auxiliary procedure.
REM 
DROP PROCEDURE CLOUD.WRAP_ANR;

HTH – Antonio NAVARRO

Install TFA For Nonroot User

Posted by antonionavarror on

Usually the TFA is installed as the root user, but there is also the option to install it as a different user. It must be indicated that if this option is chosen, the following characteristics will be lost;

To be able to execute it as Daemon
Automatic collections
Collections from remote hosts
To install as an ORACLE_HOME owner use the –extractto option;

Unzip the zip file

 
> ls -lrt 
-rw-r--r--   1 grid18     oinstall 233963383 Jul 12 12:16 TFA-SOLARIS-SPARC64_v19.2.1.zip
> unzip TFA-SOLARIS-SPARC64_v19.2.1.zip
Archive:  TFA-SOLARIS-SPARC64_v19.2.1.zip
  inflating: README.txt
  inflating: installTFA-SOLARIS-SPARC64

> ls -lrt
total 916144
-rw-r--r--   1 grid18     oinstall    1460 Apr 25 20:09 README.txt
-rwxr-xr-x   1 grid18     oinstall 234732682 Apr 25 20:44 installTFA-SOLARIS-SPARC64
-rw-r--r--   1 grid18     oinstall 233963383 Jul 12 12:16 TFA-SOLARIS-SPARC64_v19.2.1.zip

Installing using the -extractto option;

 
> ./installTFA-SOLARIS-SPARC64 -extractto xxxxxxxxxxxxxxxxxxxx

TFA Installation Log will be written to File : /tmp/tfa_install_1644_2019_07_12-12_16_51.log

Starting TFA installation

TFA Version: 192100 Build Date: 201904251105

Running Extractto Setup for TFA as user grid ...

Enabling Access for user grid on mofetac...
TFA is successfully installed...

TFA_BASE for user grid : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

HTH – Antonio NAVARRO

Import From Excel To Oracle By Using SQL Developer

Posted by antonionavarror on

SQL Developer is an increasingly important tool. I’ve known it since it first came out and in each new release they get things more and more powerful. I have also seen that many people who use it do not exploit more than 10 -20% of the capabilities of the tool.

Perhaps the main disadvantage that SQL Developer has is that it is programmed in JAVA, which makes it portable between different Operating Systems, but penalizes performance and memory consumption. This tool developed in c could be incredible, but it would imply porting to each platform it supports.

Today I just want to show a feature that has saved me hours of work when importing excel sheets into an Oracle database. Of course, using Microsoft Office or LibreOffice you can open a connector to the database and do the same.

Let’s see the steps

On table, click rigth button and select “Import Data”;

import_sql_dev_1

The next window appears. Here click on Browse and choose the xlsx file

import_sql_dev_2

In this case we will make the insertion as individual inserts, click on “Next”;

import_sql_dev_3

In my case I selected all columns to import. Click on “Next”;

import_sql_dev_4

In this case it is matched by name, click on “Next”;

import_sql_dev_5

In this phase of the process we are shown a summary of all the steps. Click on “Finish”;

import_sql_dev_6

If everything went well we will see a window like this;

import_sql_dev_7

HTH – Antonio NAVARRO

CheckConflictAgainstOHWithDetail Fail With Invalid Patch zip File

Posted by antonionavarror on

Installing a PSU, in the checking phase of prerequisites and being located in the direcotiro where I have decompressed the patch I get the following error;

 
/home/oracle/PSU/Apr_2019/bbdd/29141015> opatch prereq CheckConflictAgainstOHWithDetail
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : xxxxxxxxxxxxx
Central Inventory : xxxxxxxxxxxxx
   from           : /oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.1.0.2.0
Log file location : xxxxxxxxxxxxx

Invoking prereq "checkconflictagainstohwithdetail"
The patch base location should be a directory or a zip file.

Prereq "checkConflictAgainstOHWithDetail" is not executed.

The details are:
Unable to create Patch Object.
Exception occured : Invalid patch zip file.

OPatch failed with error code 2

In this case a workaround that does not solve the problem is to run the prerequisites check in the following way, located above the directory where we have decompressed the patch.

 
HTH – Antonio NAVARRO

How To move ASM Spfile To A Different Disk Group (Method 3/3)

Posted by antonionavarror on

In this method we use the spmove command, the main advantage is that it automatically updates the GPnP profile, and we also avoid having to erase the original SPFILE as it did with the spcopy.

### Get the curren spfile in use

ASMCMD> spget
+DATA/asm/asmparameterfile/registry.253.722601213

### Make a backup

ASMCMD> spbackup +DATA/asm/asmparameterfile/registry.253.722601213 /tmp/ASM_SPFILE.BCK

### Execute the spmove command

asmcmd spmove ‘+DATA/asm/asmparameterfile/registry.253.722601213’ ‘+DATA1/asm/spfileASM.ora’

### Check

asmcmd spget

It is a good idea, as in the previous cases, to bounce the entire CRS stack.

HTH – Antonio NAVARRO

How To move ASM Spfile To A Different Disk Group (Method 2/3)

Posted by antonionavarror on

In this method we use the spcopy command that will make a copy of the spfile, we need to update the XML file used by the GPnP profile, this step is important, because if we do not do it we will have a copy but it will not be used. Subsequently to be a copy you must manually delete the previous file.

### Where is the ASM spfile

asmcmd spget

###  show the diskgroups

asmcmd lsdg

### Copy spfile updating GPnP profile by using -u option

asmcmd spcopy -u +DATA/asm/asmparameterfile/registry.153.754750145 +DATA2/

### Check

crsctl stop has
crsctl start has
asmcmd spget

### Drop the older

asmcmd ls -l +DATA2
asmcmd rm +DATA/asm/asmparameterfile/registry.153.754750145

HTH – Antonio NAVARRO

 

How To move ASM Spfile To A Different Disk Group (Method 1/3)

Posted by antonionavarror on

The first time the CRS was installed the spfile was put in the Diskgroup by default, now we want to move it to another location. In this case we have to do a reorganization of several diskgroups and I need to move it to another location;

I’m going to show you three methods to do this task, in this we will use an auxiliary PFILE to then recreate the final SPFILE.

At the end of the process it is highly recommended to check the changes and to stop and start the CRS to verify that everything works correctly.

REMARK; It is very important GPnP profile be updated.

 
/exp/grid $ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jul 5 11:53:13 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option

REM GET THE CURRENT LOCATION
SQL> host asmcmd spget
show  +XXXXXXXXXXXXXXXXXX/ASM/ASMPARAMETERFILE/registry.213.973473081
paramet
SQL> er spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +XXXXXXXXXXXXXXXXXX/ASM/ASMPAR
                                                 AMETERFILE/registry.213.973473
                                                 081

REM
REM Create a pfile auxiliar
REM                                                 
SQL> host pwd
/export/home/grid

SQL> create pfile='/exp/grid/spfile.bck' from spfile;

File created.

SQL> create spfile='+OCRVTD_DG/' from  pfile='/exp/grid/spfile.bck' ;

File created.

REM
REM Check the change, spfile don't change until bounce
REM 
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +XXXXXXXXXXXXXXXXXX/ASM/ASMPAR
                                                 AMETERFILE/registry.213.973473
                                                 081
SQL> host asmcmd spget
+OCRVTD_DG/ASM/ASMPARAMETERFILE/registry.213.1012823707

SQL>
SQL> exit

HTH – Antonio NAVARRO