In order to install these values to Oracle Registry if they
are not in the database :
JAVAVM
JServer JAVA Virtual Machine
CATJAVA
Oracle Database Java Packages
1- If
they are installed and not working then run this block of pl/sql
BEGIN
IF dbms_registry.status('CATJAVA') IS NULL THEN
RAISE_APPLICATION_ERROR(-20000,
'CATJAVA has not been loaded into the database.');
END IF;
IF dbms_registry.is_loaded('JAVAVM') != 1 THEN
RAISE_APPLICATION_ERROR(-20000,
'JServer is not operational in the database; ' ||
'JServer is required to remove CATJAVA from the
database.');
END IF;
END;
/
You should get an error like this :
BEGIN
*
ERROR at line 1:
ORA-20000: JServer is not operational in the database;
JServer is required to
remove CATJAVA from the database.
ORA-06512: at line 7
2- In
order to reloaded you should execute this steps in the same order as
below.
sqlplus / as sysdba
execute sys.dbms_registry.loaded('JAVAVM');
execute sys.dbms_registry.loaded('CATJAVA');
execute sys.dbms_registry.valid('JAVAVM');
execute sys.dbms_registry.valid('CATJAVA');
3- To
verify everything was correct :
set line size 150
select comp_id, status, version from dba_registry where
comp_id like '%JAVA%';
COMP_ID STATUS VERSION
-------- ------- ---------
CATJAVA VALID 11.2.0.3.0
JAVAVM VALID 11.2.0.3.0
Paul S. Vidal | Database
Administrator
