Using loadjava accidently load a wrong basic jar files to database make invalid objects.

  • From: "Samuel Ma" <malufeng@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 5 Dec 2008 02:20:56 +0800

Hi ALL
One of my coworker using loadjava to load a jar file to database.but
unfortunately he copied a wrong file names and loaded a higher version basic
jar file(rt.jar) to database,
after this,about 10,000+ java class objects become INVALID and below error
throw in alert.log

ORA-00600: internal error code, arguments: [26599], [1], [18], [], [], [],
[], []

and I cannot load right version rt.jar to database,and also cannot drop any
JAVA CLASS objects.

SQL> select owner,
  2         'drop java class "' || dbms_java.longname(object_name) || '";'
 3      from DBA_objects
 4    where object_type like 'JAVA CLASS'
 5        and dbms_java.longname(object_name) like
('sun/applet/AppletAudioClip') ;
  from DBA_objects
       *
ERROR at line 3:
ORA-04045: errors during recompilation/revalidation of
SYSTEM.sun/io/Converters
ORA-00600: internal error code, arguments: [26599], [1], [225], [], [], [],
[],
[]

how can i recover it,any suggestion will be appreciated.


Best Regards
Samuel

Other related posts:

  • » Using loadjava accidently load a wrong basic jar files to database make invalid objects. - Samuel Ma