ERROR:
JServer JAVA Virtual Machine Component Is in Removing state
CAUSE:
SQL> select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
—————————————- —————————— ———–
Oracle Database Catalog Views 12.1.0.2.0 VALID
Oracle Database Packages and Types 12.1.0.2.0 VALID
JServer JAVA Virtual Machine REMOVING
Oracle XDK 12.1.0.2.0 VALID
Oracle Database Java Packages 12.1.0.2.0 VALID
SOLUTION:
1. To uninstall the current installation of JAVA Virtual Machine, execute the following scripts at the SQL prompt connected as sys user.
startup mount;
alter system set “_system_trig_enabled” = false scope=memory;
alter system enable restricted session;
alter database open;
@?/rdbms/admin/catnojav.sql
@?/xdk/admin/rmxml.sql
@?/javavm/install/rmjvm.sql
truncate table java$jvm$status;
Once all the above commands have been executed successfully, restart the database. Shutdown of the database is necessary to ensure that the changes are synchronized with the disk after removal of JAVA Virtual Machine.
2. To install the JAVA Virtual Machine execute the following scripts at the SQL prompt connected as sys user.
startup mount
alter system set “_system_trig_enabled” = false scope=memory;
alter database open;
@?/javavm/install/initjvm.sql
@?/xdk/admin/initxml.sql
@?/xdk/admin/xmlja.sql
@?/rdbms/admin/catjava.sql
shutdown immediate;
3. Start the database and resolve any INVALID objects by executing the utlrp.sql script.
@?/rdbms/admin/utlrp.sql
