Manually install Oracle9i JVM (9.0.1)

If you want to install the Oracle 9i Java Virtual Machine, you have to run the following Scripts as user SYS. Using the database configuration assistant, this scripts will be executed.

Requirements

Make sure, your INIT.ORA Paramaters SHARED_POOL_SIZE
and JAVA_POOL_SIZE are big enough. We have successfully installed the 9i JVM with the following settings on a Windows 2000 server.

shared_pool_size = 200000000
java_pool_size = 100000000

Script to Install 9i JVM

Note, that Oracle Home is: D:\Ora9i

sqlplus /nolog
connect sys/…. as sysdba;

– Setup a database for running Java and the ORB
@D:\Ora9i\javavm\install\initjvm.sql;

– INITialize (load) XML components in JServer
@D:\Ora9i\xdk\admin\initxml.sql;

– Loads NCOMP’ed XML Parser
@D:\Ora9i\xdk\admin\xmlja.sql;

– Loads the XMLSQL Utility (XSU) into the database.
@D:\Ora9i\rdbms\admin\catxsu.sql;

– Install the Oracle Servlet Engine (OSE)
@D:\Ora9i\javavm\install\init_jis.sql D:\Ora9i;

– Adds the set of default end points to the server
– with hardcoded values for the admin service
@D:\Ora9i\javavm\install\jisaephc.sql D:\Ora9i;

– Turn on J Accelerator
@D:\Ora9i\javavm\install\jisja.sql D:\Ora9i;

– Register EJB\Corba Dynamic Registration Endpoint
@D:\Ora9i\javavm\install\jisdr.sql 2481 2482;

– Init Java server pages ???
@D:\Ora9i\jsp\install\initjsp.sql;

– Turn on J Accelerator for JSP libs
@D:\Ora9i\jsp\install\jspja.sql;

– Script used to load AQ\JMS jar files into the database
@D:\Ora9i\rdbms\admin\initjms.sql;

– Load RepAPI server classes and publish ‘repapi’ obj
@D:\Ora9i\rdbms\admin\initrapi.sql;

– Loads sql, objects, extensibility and xml related java
@D:\Ora9i\rdbms\admin\initsoxx.sql;

– Loads appctxapi.jar for JavaVm enabled
– Database.Called by jcoreini.tsc
@D:\Ora9i\rdbms\admin\initapcx.sql;

– Script used to load CDC jar files into the database
@D:\Ora9i\rdbms\admin\initcdc.sql;

– Loads the Java stored procedures as required by the
– Summary Advisor.
@D:\Ora9i\rdbms\admin\initqsma.sql;

– Initialize sqlj type feature in 9i db
@D:\Ora9i\rdbms\admin\initsjty.sql;

– Load java componenets for AQ HTTP Propagation
@D:\Ora9i\rdbms\admin\initaqhp.sql;