How to configure the iProcess Technology Plug-in in iProcess to use the Oracle TNS Names (tnsnames.ora file) entry in the JDBC URL.

Database migration can then be achieved by changing the entry in the Oracle tnsnames.ora file and restarting iProcess.

How to configure the iProcess Technology Plug-in in iProcess to use the Oracle TNS Names entry in the JDBC URL. Database migration can then be achieved by changing the entry in the Oracle tnsnames.ora file and restarting iProcess.

TIBCO iProcess Engine (Oracle) - All versions TIBCO iProcess Technology Plug-ins using Oracle database - All versions

To do this the following information is required:

1. Path to the tnsnames.ora file used by iProcess
    This is the path to the directory that contains the tnsnames.ora file to be used by iProcess (it does not contain the file name).
   For example:
        /u01/app/oracle/product/12.1.0.2/network/admin

    The iProcess Unix user must have permission to read the file.

2. The name of the TNS entry used for iProcess
    For example:
        IPEDB

The Java JDBC configuration is held in two iProcess configuration files:
    SWDIR/eaijava/eaijavaplugin.properties  (for the EAIJAVA plugin)
    SWDIR/eaijava/jmx/config.xml              (for the iProcess BusinessWorks Server Plug-in)

Both files must be updated to reference the path to the tnsnames.ora file and for the JDBC URL to reference the TNS Names entry.


Details on how to this is outlined below.


A. Update the SWDIR/eaijava/eaijavaplugin.properties file

Update two lines in the file

1. Update the eaijava.db_oracle.net.tns_admin property to reference the path to the tnsnames.ora file
    For example:
    Update the line:
        eaijava.db_oracle.net.tns_admin=
    to read:
        eaijava.db_oracle.net.tns_admin=/u01/app/oracle/product/12.1.0.2/network/admin

2. Update the eaijava.db_connection property / JDBC URL to use the Oracle TNS Names entry
    For example:
    Update the line:
        eaijava.db_connection=jdbc:oracle:thin:@horeb:1521:horeb11204
    to read:
        eaijava.db_connection=jdbc:oracle:thin:@IPEDB



B. Update the SWDIR/eaijava/jmx/config.xml file

Update two elements in the file:

1. Update the TnsnamePath  attribute to reference the path to the tnsnames.ora file
    For example:
    Update the attribute:
        <call objectname="TIBCO:DBPool=default" attribute="TnsnamePath">
            <arg type="java.lang.String"> </arg>
        </call>
    to read:
        <call objectname="TIBCO:DBPool=default" attribute="TnsnamePath">
             <arg type="java.lang.String/u01/app/oracle/product/12.1.0.2/network/admin </arg>
        </call>

2. Update the ConnectionURI attribute / JDBC URL to use the Oracle TNS Names entry
    For example:
    Update the attribute:
        <call objectname="TIBCO:DBPool=default" attribute="ConnectionURI">
            <arg type="java.lang.String">jdbc:oracle:thin:@horeb:1521:horeb11204</arg>
        </call>
    to read:
        <call objectname="TIBCO:DBPool=default" attribute="ConnectionURI">
            <arg type="java.lang.String">jdbc:oracle:thin:@IPEDB</arg>
        </call>


Restart the iProcess Engine after making the above changes.

TIBCO iProcess Technology Plug-in Installation Guide