Oracle Database Server and Client Settings

The following table displays the Oracle Database server and client settings required for installation.

Table 4-4 Oracle Database Server and Client Settings

Description Example Value
In the .profile file, set TNS_ADMIN pointing to the appropriate tnsnames.ora file. TNS_ADMIN=$HOME/tns
In the .profile file, set ORACLE_HOME pointing to the appropriate Oracle Client installation. ORACLE_HOME=/scratch/oraofss/app_client18c/product/ 18.0.0/client_1

Note:

If you are planning to install OFS LLFP version 8.1.2.11.0 ML, the Oracle client can be 26ai.

For example,

ORACLE_HOME=/scratch/oraofss/app_client26ai/product/ 23.26.1/client_1

In the .profile file, set PATH to include the appropriate $ORACLE_HOME/bin path. PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin
OFSAA Processing Server

ORACLE_HOME must be set in the .profile file and point to appropriate Oracle DB Client installation.

PATH in the .profile file must be set to include the appropriate $ORACLE_HOME/bin path.

Ensure that an entry (with SID or SERVICE NAME) is added in the tnsnames.ora file.