Thursday, October 1, 2009

Installing JVM Manually

We have some Oracle 9i Databases on HP-UX which were installed without JVM.
Some of our new applicatons demanded Java Packages. So, we had to unstall JVM manually on those servers.

We did this following below steps (for all OS,tested on solaris, windows, HP-UX):

1. Additional 60 MB of system tablespace
2. 50 MB of SHARED_POOL_SIZE
3. 20 MB of JAVA_POOL_SIZE
4. run $ORACLE_HOME/javavm/install/rmjvm.sql [If JVM previously installed of partly
installed]
5. run $ORACLE_HOME/javavm/install/initjvm.sql


If the oracle DB version in 10g then after step 5 below error will be occured

ORA-29558: JAccelerator (NCOMP) not installed

To resolve this JAccelerator needed to be installed from oracle database 10g companion CD.
http://www.orafaq.com/forum/t/69986/2/
http://www.dbaportal.eu/?q=node/13
Metalink 276554.1 "How to Reload the JVM in 10.1.0.X and 10.2.0.X"

Follow below steps if some one needs xml options:

6. run $ORACLE_HOME/xdk/admin/initxml.sql
7. run $ORACLE_HOME/xdk/admin/xmlja.sql
8. run $ORACLE_HOME/rdbms/admin/catjava.sql
9. run $ORACLE_HOME/rdbms/admin/catexf.sqla

No comments:

Post a Comment