Configuring Application Servers or Process Scheduler Servers for Remote Data Access for Oracle

Before you can use Remote Data Access with Oracle, the appropriate database connectivity software must be installed on the system where the application server or Process Scheduler server is running, and the configuration files updated.

To connect to a remote Oracle database, you must edit the application server configuration file, PSAPPSRV.CFG. If the Process Scheduler server is being used, you must edit the Process Scheduler server configuration file, PSPRCS.CFG, as well. These configuration files can be found in the PS_CFG_HOME directory within the appropriate domain or database name directory.

From the Remote Database Connection page (PeopleTools > Utilities > Administration > Remote Database Connections), you can specify an Oracle data source as "specific" or with TNSNAMES. "Specific" doesn't require a TNSNAMES entry, and will use the Oracle "thin" JDBC driver. However, if TNSNAMES is configured for the remote database, you can use the TNSNAMES style entry.

Determine the Oracle home directory and specify it in the configuration files. Update the "Add to CLASSPATH" parameter in the General Settings for PSTOOLS section.

Remove the comment character (;) if necessary and add the full path to the .jar file. For example:

Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/ojdbc8.jar

Determine the Oracle home directory and specify it in the configuration file. Update the "Add to CLASSPATH" parameter in the General Settings for PSTOOLS section.

Remove the comment character (;) if necessary and add the full path to the .jar file. For example:

Add to CLASSPATH=C:\Apps\DB\Oracle\jdbc\lib\ojdbc8.jar