Friday, September 9, 2011

How to install JServer JAVA Virtual Machine

It allows to write Java stored procedures.

if JServer JAVA VM is not installed You will get error follwoing error
ERROR at line 1:
ORA-29538: Java not installed

Connect as sys user


SQL> @?/javavm/install/initjvm

SQL> select comp_name,status from dba_registry;

COMP_NAME STATUS
------------------------------------------------------------ -----------
Oracle Text VALID
Oracle XML Database VALID
Oracle Enterprise Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
JServer JAVA Virtual Machine VALID




Remove JVM:

SQL> @?/javavm/install/jvmrm.sql

No comments: