I recently patched a 18.104.22.168 database to 22.214.171.124.
In the README it said to check, if Java is loaded.
SQL> describe dbms_java
Java is loaded. In that case the readme says to type the following command:
SQL> connect internal
SQL> create or replace java system
I did just that. The procedure finished without errors. But when I restarted the database, I got the following error in a tracefile:
*** SESSION ID:(12.1) 2002-04-26 03:29:42.272
Error in executing triggers on database startup
*** 2002-04-26 03:29:42.762
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of SYS./25ce416e_OracleClassLoader
ORA-30511: invalid DDL operation in system triggers
ORA-06512: at "SYS.DBMS_JAVA", line 0
ORA-06512: at line 2
*** 2002-04-26 03:32:17.907
*** SESSION ID:(12.3) 2002-04-26 03:32:17.907
joxcsys: not_same = sun/tools/java/BinaryExceptionHandler
joxcsys: not_same = sun/tools/jar/JarVerifierStream$1
joxcsys: not_same = sun/tools/jar/JarVerifierStream$2
How can I undo what I did? If I cannot undo it, how do I fix the problem?
One symptom of the probelm is that I keep getting deadlocks on certain tables.
This is pretty urgent. I would really apreciate the help.
Thanks very much
Click Here to Expand Forum to Full Width