Rollaback of Patch 18085242 Results in ORA-29532 During the Post Install Step (Doc ID 1641838.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 Applied the one-off patch 18085242 on top of 11.2.0.1 as per instructions in README. Trying the rollback of this patch as per README which says -

Patch Deinstallation Instructions:

1. Make sure to follow the same pre-install steps when deinstalling
a patch.  This includes verifying the inventory and shutting down
any services running from the ORACLE_HOME / machine before rolling
the patch back.

2. Change to the directory where the patch was unzipped.
 % cd <PATCH_TOP>/18085242

3. Run OPatch to deinstall the patch.
 % opatch rollback -id 18085242
   Then re-run the Post Install Instructions, i.e. -

  cd $ORACLE_HOME/md/lib
  connect to database as SYS
  SQL> call dbms_java.loadjava('-resolve -force -synonym -schema MDSYS -grant PUBLIC md/lib/sdogcdr.jar');

When running the post install instructions after rolling back the patch it results in below error -

SQL> call dbms_java.loadjava('-resolve -force -synonym -schema MDSYS -grant PUBLIC md/lib/sdogcdr.jar');
call dbms_java.loadjava('-resolve -force -synonym -schema MDSYS -grant PUBLIC md/lib/sdogcdr.jar')
    *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.aurora.server.tools.loadjava.ToolsError:
Error during loadjava: Failures occurred during processing.
Check trace file for details
ORA-06512: at "SYS.DBMS_JAVA", line 655

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms