SQL> select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
---------------- ------------------------------ -----------
JServer JAVA Virtual Machine 10.2.0.3.0 LOADING/INVALID
--uninstall the current installation of JAVA Virtual Machine
SQL> startup mount;
SQL> alter system set “_system_trig_enabled” = false scope=memory;
SQL> alter system enable restricted session;
SQL> alter database open;
SQL> @?/rdbms/admin/catnojav.sql
SQL> @?/xdk/admin/rmxml.sql
SQL> @?/javavm/install/rmjvm.sql
SQL> truncate table java$jvm$status;
--restart database and install JVM
SQL> startup mount;
SQL> alter system set “_system_trig_enabled” = false scope=memory;
SQL> alter database open;
SQL> @?/javavm/install/initjvm.sql
SQL> @?/xdk/admin/initxml.sql
SQL> @?/xdk/admin/xmlja.sql
SQL> @?/rdbms/admin/catjava.sql
SQL> shutdown immediate;
--start database and resolve any INVALID objects
SQL> @?/rdbms/admin/utlrp.sql
SQL> select comp_name, version, status from dba_registry;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/20500445/viewspace-708609/ ,如需转载,请注明出处,否则将追究法律责任。