Oracle Patch screwed up Java Sources and classes
Posted on 2006-07-15
I've got Oracle 10g on Win 2k3. Last weekend I patched Oracle from version 10.2.0.1 to 10.2.0.2 and since then all my java classes have become unusable. The sources are not listed at all in the web based enterprise manager console (although they are listed in the java enterprise manager tool) and although the classes are listed as valid they are not working.
Running one through SQL Plus using the following commands gives:
PL/SQL procedure successfully completed.
SP2-0103: Nothing in SQL buffer to run.
I can't delete the java classes in the java enterprise manager becasue I get: VBO - 4569: The java object cannot be dropped. ORA - 29537: class or resource cannot be created or dropped directly.
Trying in the web based tool gives: ORA-29537: class or resource cannot be created or dropped directly
Recompiling gives: oracle.sysman.emSDK.admObj.AdminObjectException: No more data to read from socket
and I have to log back in or else nothing else works.