Configuring Application Servers or Process Scheduler Servers for Remote Data Access for Oracle
This section discusses how to:
Prepare to configure Oracle.
Configure Oracle connectivity on UNIX.
Configure Oracle connectivity on Windows.
Preparing to Configure Oracle Remote Data Access
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. The supported version of database connectivity software is determined by your database version.
See PeopleSoft Supported Platforms, PeopleSoft Hardware and Software Requirements, and your PeopleTools 8.53 Installation for Oracle for version and installation information.
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 Connection), 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.
Configuring Oracle Connectivity for Remote Data Access on UNIX
Determine the Oracle home directory and specify it in the configuration files by adding the following two lines under the ";JavaVM Shared Library=" section:
; RDBA Oracle JDBC driver Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/ojdbc14.jar Add to CLASSPATH=%ORACLE_HOME%/jdbc/lib/orai18n.jar
Configuring Oracle Connectivity for Remote Data Access on Windows
Determine the Oracle home directory and specify it in the configuration file. For example, if Oracle the home directory is C:\Apps\DB\Oracle901, add the following lines under the ";JavaVM Shared Library=" section:
; RDBA Oracle JDBC driver Add to CLASSPATH=C:\Apps\DB\Oracle901\jdbc\lib\ojdbc14.jar Add to CLASSPATH=C:\Apps\DB\Oracle901\jdbc\lib\orai18n.jar