1) To install the basic JServer in the Oracle database .. ie CompleteJava Runtime, you must run $ ORACLE_HOME / javavm / install / initjvm.sql asSYS. This will give you base JServer which is required to install anyadditional Java related add-ons. After the installation, if you runthis query as SYS will give you> 8500 object count.SQL> select count (*) from user_objects where object_type like 'JAVA%'. This first step must be done before proceeding with installation of anyother Java related add -ons. You can also run the above query beforerunning initjvm.sql to see if the JServer is already installed.By including $ ORACLE_HOME / jdbc / lib / classes12.zip in the classpath willexpose all client side XA classes.2) $ ORACLE_HOME / javavm / install / initxa.sql creates the server sidewrapper package called JAVA_XA. This package requires server side XAclasses to be installed in the database ie "oracle.jdbc.xa.server. *". I looked thru some posts in Metalink which only says To run initjvm.sqlfollowed by initxa.sql. This looks wrong to me since initxa.sql ONLYcreates a plsql wrapper package for server side XA classes. It does notactually install the server side XA classes which reside in $ ORACLE_HOME / javavm / lib / aurora.zip file. By just running the initxa. sqland calling one of the package functions will most likely error outsince no underlying class exists. Oracle does not do a check to see ifthe java class exists when deploying the wrapper package.I have not tested this but I am pretty sure that installing $ ORACLE_HOME / JavaVM / LIB / AURORA.ZIP VIA LOADJAVA TOOL MUST BE DONEBEFORE RUNNING INITXA.SQL .. else there is no point just runninginitxa.sql without the underlying class.
