-- Start of File full_jvminst.sql spool full_jvminst.log; set echo on connect / as sysdba startup mount alter system set "_system_trig_enabled" = false scope=memory; alter database open; select obj#, name from obj$ where type#=28 or type#=29 or type#=30 or namespace=32; @?/javavm/install/initjvm.sql select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type; @?/xdk/admin/initxml.sql select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type; @?/xdk/admin/xmlja.sql select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type; @?/rdbms/admin/catjava.sql select count(*), object_type from all_objects where object_type like '%JAVA%' group by object_type; shutdown immediate set echo off spool off exit -- End of File full_jvminst.sql 4. Once the database has been restarted, resolve any invalid objects by running the utlrp.sql script e.g.: @?/rdbms/admin/utlrp.sql The JVM should now be fully installed (including the XDK & XSU). The count of Java objects returned above should be around 9,260 (on NT) for the SYS user. In a full JVM installation depending upon the platform and products installed, the objects can be broken down by owner as follows: SQL> select count(*), owner from all_objects 2 where object_type like '%JAVA%' group by owner; COUNT(*) OWNER ---------- ------------------------------ 247 ODM 1 ORDPLUGINS 903 ORDSYS 9261 SYS 40 WKSYS