Install Xa in Oracle

1) to install the basic jserver in the Oracle database.. I. e. Complete
Java runtime, you must run $ ORACLE_HOME/JavaVM/install/initjvm. SQL
SYS. This will give you base jserver which is required to install any
Additional Java related Add-ons. After the installation, if you run
This 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 any
Other Java related Add-ons. You can also run the above query before
Running initjvm. SQL to see if the jserver is already installed.

By including $ ORACLE_HOME/jdbc/lib/classes12.zip in the classpath will
Expose all client side XA classes.

2) $ ORACLE_HOME/JavaVM/install/initxa. SQL creates the server side
Wrapper package called java_xa. This package requires server side XA
Classes to be installed in the database I. e. "oracle. JDBC. Xa. server .*".
I looked thru some posts in Metalink which only says to run initjvm. SQL
Followed by initxa. SQL. This looks wrong to me since initxa. SQL only
Creates a PLSQL wrapper package for server side XA classes. It does not
Actually install the server side XA classes which reside in
$ ORACLE_HOME/JavaVM/lib/initra.zip file. By just running the initxa. SQL
And calling one of the package functions will most likely error out
Since no underlying class exists. Oracle does not do a check to see if
The Java class exists when deploying the wrapper package.
I have not tested this but I am pretty sure that installing
$ ORACLE_HOME/JavaVM/lib/javasra.zip via loadjava tool must be done
Before Running initxa. SQL... else there is no point just running
Initxa. SQL without the underlying classes.