This section provides information to configure the environment settings before installation.
Topics:
Oracle Database Server and Client Settings
TNS Entries in TNSNAMES.ORA File
The following table displays the Java settings required for installation.
Table 13: Java Settings
Description |
Example Value |
In the .profile file, set PATH to include the Java Runtime Environment (JRE) absolute path. Ensure that SYMBOLIC links to JAVA installation are not set in the PATH variable. |
For example: PATH=/usr/java/jre1.8.0_221/bin:$ORACLE_ HOME/bin:$PATH export PATH NOTE: OFSAA does not support OpenJDK and JRE. |
In the .profile file, set PATH to include the Java Runtime Environment bin path. |
JAVA_BIN=/scratch/<<version>>/jre/bin For example: PATH=/usr/java/jre1.8.0_221/bin:$ORACLE_ HOME/bin:$PATH |
Enable unlimited cryptographic policy for Java. |
For more information, see the Enabling Unlimited Cryptographic Policy section from the OFS Analytical Applications Infrastructure Administration Guide. |
The following table displays the Oracle Database server and client settings required for installation.
Table 14: 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 |
In the .profile file, set PATH to include the appropriate $ORACLE_HOME/bin path. |
PATH=$JAVA_HOME/bin:$ORACLE_HOME/bin |
Add an entry in the tnsnames.ora file. Processing Server |
Ensure that an entry (with SID/ SERVICE NAME) is added in the tnsnames.ora file. |
The section includes information about the TNS entries in the TNSNAMES.ORA file for Non-TCPS and TCPS.
The following table displays the Non-TCPS settings required for installation.
Table 15: TNS entries in the TNSNAMES.ORA file for Non-TCPS
Description |
Example Value |
Ensure that an entry (with SID/ SERVICE NAME) is added in the tnsnames.ora file on the OFSAA server. |
<SID_NAME> = DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))<ATOMIC_SCHEMA_NAME> = (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>))) |
<SID NAME> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOST NAME>)(PORT = <PORT NUMBER>))
)
(CONNECT_DATA =
(SERVICE_NAME = <SID NAME>)
)
)
<ATOMICSCHEMANAME> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOST NAME>)(PORT = <PORT NUMBER>))
)
(CONNECT_DATA =
(SERVICE_NAME = <SID NAME>)
)
)
NOTE |
The ATOMIC SCHEMA NAME must be the same as defined in the OFS_<App Pack>_SCHEMA_IN.xml file. |
The following table displays the TCPS settings required for installation.
Table 16: TNS entries in the TNSNAMES.ORA file for TCPS
Description |
Example Value |
Ensure that an entry (with SID/ SERVICE NAME) is added in the tnsnames.ora file on the OFSAA server. |
<SID_NAME> = DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST_NAME>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))<ATOMIC_SCHEMA_NAME> = (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST_NAME>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))(security=(ssl_server_cert_dn=CN=<HOST_NAME>)))) |
Ensure that an entry (with WALLET_HOME and wallet parameters) is added in the sqlnet.ora file on the OFSAA server must be the same as the Oracle database server running with TCPS. |
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = <PATH TO WALLET DIRECTORY>)))SQLNET.WALLET_OVERRIDE = TRUE SSL_CLIENT_AUTHENTICATION = FALSE SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS,BEQ)SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA) |
<SID NAME> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST NAME>)(PORT = <PORT NUMBER>))
)
(CONNECT_DATA =
(SERVICE_NAME = <SID NAME>)
(security=(ssl_server_cert_dn=CN=<HOST NAME>))
)
)
<ATOMICSCHEMANAME> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST NAME>)(PORT = <PORT NUMBER>))
)
(CONNECT_DATA =
(SERVICE_NAME = <SID NAME>)
(security=(ssl_server_cert_dn=CN=<HOST NAME>)) )
)
NOTE |
The ATOMIC SCHEMA NAME must be the same as defined in the OFS_<App Pack>_SCHEMA_IN.xml file, which also includes prefix without underscore. For example, DEVOFSAAATM. |
In the .profile file, set the Time Zone parameter to indicate the time zone of your region or location.
Table 17: Time Zone Settings
Description |
Example Value |
Time Zone |
TZ=Asia/Calcutta |
The following table includes information about the mandatory patches that must be applied.
Table 18: Mandatory Patches
One-Off Patch |
Description |
31523114 |
This is a mandatory one-off patch. You must install this patch before you install patch 31605116. |
31605116 |
This is a mandatory one-off patch. You must install patch 31523114 before you install this patch. |
31582885 |
This is a mandatory one-off patch if the license for OFS AAAI is enabled and you want to use the Sandbox. |
31545589 |
This is a mandatory one-off patch if you are installing pack on pack. |
31654438 |
This is a mandatory one-off patch if you are installing pack on pack. |