JDBC Driver Upgrade for SOA/AIA 10g

Oracle SOA suite comes with 10.1.0.5 version of JDBC driver, which is pretty old I believe. If you are using newer version of database, it is worth upgrading the JDBC driver of SOA Suite or AIA to the database version you are using.

If you are using 11g database, then 11g version of database driver does cause some problem with AIA console and EBS WF_Event complex payload, but as long as 10g version is concerned it is quite easy migration.

For instance, we were using 10.2.0.5 version of database and wanted to upgrade to 10.2.0.5 JDBC drivers:

1. Download 10.2.0.5 specific JDBC drivers from below
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

2. Copy all jar files to $ORACLE_HOME/JDBC10205/lib directory

3. Add following to $ORACLE_HOME/j2ee/CONTAINER_NAME/config/server.xml:

    <shared-library name="oracle.jdbc" version="10.2.0.5">
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/classes12.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/classes12_g.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/classes12dms.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/classes12dms_g.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/ojdbc14.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/ojdbc14_g.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/ojdbc14dms.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/JDBC10205/lib/ojdbc14dms_g.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/j2ee/home/lib/ojms-provider.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/jdbc/lib/ocrs12.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/opmn/lib/ons.jar"/>
        <code-source path="/aiaapp/oracle/product/10.1.3.1/OracleAS_1/rdbms/jlib/aqapi.jar"/>
        <import-shared-library name="oracle.dms"/>
        <import-shared-library name="oracle.gdk"/>
    </shared-library>

4. Change $ORACLE_HOME/j2ee/CONTAINER_NAME/config/system-application.xml file:
(add : min-version="10.2.0.5)

    <import-shared-library name="oracle.jdbc" min-version="10.2.0.5"/>

5. bounce the server

6. check the driver version (http://chintanblog.blogspot.com/2010/12/how-to-check-jdbc-driver-version.html)