Hi all,

I recently patched a 8.1.6.0 database to 8.1.6.3.

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
connected

SQL> create or replace java system
2 /

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
.
.
.
.
.
etc.

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