19 Configuring OFSAAI_InstallConfig.xml Files

This section gives details about the configurations required in the InstallConfig.xmland OFSAAI_InstallConfig.xml files.

The following table provides the OFSAA infrastructure installation tasks and description

Table 19-1 OFSAA Infrastructure Installation Tasks and Descriptions

Interaction Variable Name> Significance and Expected Value Mandatory
<Layer name="GENERAL"> - -
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
InteractionGroup name="OFSAA Infrastructure Server Details"
DBSERVER_IP

Identifies the hostname or IP address of the system on which the Database Engine is hosted.

Note: For RAC Database, the value should be NA.

For example, <InteractionVariable name="DBSERVER_IP">14.15.16.17</InteractionVariable> or

<InteractionVariable name="DBSERVER_IP">dbhost.server.com</ InteractionVariable>

Yes
InteractionGroup name="Database Details"
ORACLE_SID/ SERVICE_ NAME

Identifies the Oracle DB Instance SID or SERVICE_NAME

Note: The Oracle_SID value should be exactly the same as it is mentioned in JDBC_URL.

For example, <InteractionVariable name="ORACLE_SID/ SERVICE_NAME">ofsaser</InteractionVariable>

Yes
ABS_DRIVER_PATH

Identifies the directory where the JDBC driver (ojdbc<version>.jar) exists. This would typically be the

$ORACLE_HOME/jdbc/lib

For example, <InteractionVariable name="ABS_DRIVER_PATH">">/oradata6/revwb7/oracle </ InteractionVariable>

Note: See Appendix 21 for identifying the correct "ojdbc<version>.jar" version to be copied.

Yes
<Layer name="GENERAL">
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
InteractionGroup name="OLAP Detail"
OLAP_SERVER_ IMPLEMENTATION

Identifies if the OFSAA Infrastructure OLAP component needs to be configured depending on whether you intend to use the OLAP feature. The following numeric value should be set depending on the choice:

  • YES - 1
  • NO - 0
No

Note: If value for OLAP_SERVER_IMPLEMENTATION is set to 1, it checks for following environment variables are set in.profile:

ARBORPATH, HYPERION_HOME and ESSBASEPATH.

InteractionGroup name="SFTP Details"
SFTP_ENABLE

Identifies if the SFTP (Secure File Transfer Protocol) feature is to be enabled. The following numeric value should be set depending on the choice:

  • SFTP - 1
  • FTP - 0
Yes
Note: The default value for SFTP_ENABLE is 1, which signifies that SFTP will be used. Oracle recommends using SFTP instead of FTP because SFTP is considered more secure. However, a client may choose to ignore this recommendation and to use FTP by setting SFTP_ENABLE to 0. This selection may be changed later by using the OFSAAI administration interface.
FILE_TRANSFER_PORT

Identifies the port used for the file transfer service. The default value specified is 22 (SFTP). Specify value as 21 or any other PORT value if value for SFTP_ENABLE is 0.

For example, <InteractionVariable name="FILE_TRANSFER_PORT">21</InteractionVariable>

Yes
InteractionGroup name="Locale Details"
<Layer name="GENERAL">
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
LOCALE

Identifies the locale information to be used during the installation. This release of the OFSAA Infrastructure supports only US English.

For example, <InteractionVariable name="LOCALE">en_US</ InteractionVariable>

Yes

InteractionGroup name="OFSAA Infrastructure Communicating ports"

Note: The following ports are used internally by the various OFSAA Infrastructure services. The default values mentioned are set in the installation. If you intend to specify a different value, update the parameter value accordingly and ensure this port value is in the range of 1025 to 65535 and the respective port is enabled.

JAVAPORT 9999 Yes
NATIVEPORT 6666 Yes
AGENTPORT 6510 Yes
ICCPORT 6507 Yes
ICCNATIVEPORT 6509 Yes
OLAPPORT 10101 Yes
MSGPORT 6501 Yes
ROUTERPORT 6500 Yes
AMPORT 6505 Yes

InteractionGroup name="Web Details"

Note: If value for HTTPS_ENABLE is set to 1, ensure you have a valid certificate available from a trusted CA and the same is configured on your web application server.

<Layer name="GENERAL">
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
HTTPS_ENABLE

Identifies if the UI should be accessed using HTTP or HTTPS scheme. The default value set is 0. The following numeric value should be set depending on the choice:

  • YES - 1
Yes
  • NO - 0

For example, <InteractionVariable name="HTTPS_ENABLE">0</ InteractionVariable>

WEB_SERVER_IP

Identifies the HTTP Server IP/ Hostname or Web Application Server IP/ Hostname, to be used for accessing the UI. This IP would typically be the HTTP Server IP.

If no separate HTTP Server is available, the value should be Web Application Server IP/Hostname.

For example, <InteractionVariable name="WEB_SERVER_IP">10.11.12.13</InteractionVariable> or

<InteractionVariable name="WEB_SERVER_IP">myweb.server.com</ InteractionVariable>

No
WEB_SERVER_PORT

Identifies the Web Server Port. This would typically be 80 for non SSL and 443 for SSL. If no separate HTTP Server exists, the value should be the port configured for Web Server.

Note: The port value will not be accepted as 80 if HTTPS_ENABLE is 1 and as 443, if HTTPS_ENABLE is 0.

For example, <InteractionVariable name="WEB_SERVER_PORT">80</InteractionVariable>

No
<Layer name="GENERAL">
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
CONTEXT_NAME

Identifies the web application context name which will be used to built the URL to access the OFSAA applications. The context name can be identified from a URL as follows:

<scheme>://<host>:<port>/<context-name>/login.jsp Sample URL: https://myweb:443/ofsaadev/login.jsp For example, <InteractionVariable name="CONTEXT_NAME">ofsaadev</InteractionVariable>

Yes
WEBAPP_CONTEXT_P ATH

Identifies the absolute path of the exploded .ear file on the web application server.

For WebLogic, provide the WebLogic home directory path as /

<WebLogic home directory path>/bea/wlserver_10.3

Note: For WebLogic, value specified for this attribute is ignored and value provided against attribute WEBLOGIC_DOMAIN_HOME is considered.

Yes
WEB_LOCAL_PATH

Identifies the absolute path to any directory on the web application server that can hold temporary files being uploaded as part of the applications usage.

Note: In case of a clustered deployment, ensure this path and directory is same on all the nodes.

Yes
InteractionGroup name="Weblogic Setup Details"
WEBLOGIC_DOMAIN_ HOME

Identifies the WebLogic Domain Home.

For example, <InteractionVariable name="WEBLOGIC_DOMAIN_

HOME">/home/weblogic/bea/user_ projects/domains/ mydomain

</InteractionVariable>

Yes Specify the value only if WEBSER VERTYP

E is set as 3 (WebLog ic)

<Layer name="GENERAL">
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
InteractionGroup name="OFSAAI FTP Details"
OFSAAI_FTPSHARE_PA TH

Identifies the absolute path to the directory identified as file system stage area.

Note:

  • The directory should exist on the same system on which the OFSAA Infrastructure is being installed (can be on a separate mount).
Yes
  • The user mentioned in the following APP_SFTP_USER_ID parameter should have RWX permission on the directory.

For example, <InteractionVariable name="APP_FTPSHARE_PATH">">/oradata6/revwb7/ftpshare</ InteractionVariable>

OFSAAI_SFTP_USER_I D Identifies the user who has RWX permissions on the directory identified under the preceding parameter APP_FTPSHARE_PATH. Yes

OFSAAI_SFTP_PRIVATE

_KEY

Identifies the SFTP private key for OFSAAI. For example,

<InteractionVariable name="OFSAAI_SFTP_PRIVATE_KEY">/ home/ofsaapp/.ssh/id_rsa</InteractionVariable>

By default, the value is NA, which indicates password will be prompted for the user <OFSAAI_SFTP_USER_ ID> for authentication.

For more information on generating SFTP Private key, see the Setting Up SFTP Private Key section.

OFSAAI_ SFTP_P RIVATE_ KEY
<Layer name="GENERAL">
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
OFSAAI_SFTP_PASSPH RASE

Identifies the passphrase for the SFTP private key for OFSAAI. For example,

InteractionVariable name="OFSAAI_SFTP_PASSPHRASE">enter a pass phrase here</InteractionVariable>

By default, the value is NA.

If OFSAAI_SFTP_PRIVATE_KEY value is given and this is kept as NA, then it is assumed as empty passphrase.

OFSAAI_ SFTP_P ASSPHR ASE

InteractionGroup name="Hive Details"

The default value set for the interaction variables under this group is set as NA. These are required only for Hive Configuration.

HIVE_SERVER_PORT

Identifies the port used for the file transfer service. The default value set is 22 (SFTP). Set this value as 21 for FTP.

For example,

InteractionVariable name="HIVE_SERVER_PORT">22</ InteractionVariable>

Yes, only for HIVE Configu ration
HIVE_SERVER_FTPDRI VE

Identifies the absolute path to the directory identified as file system stage area of HIVE server.

For example,

InteractionVariable name="HIVE_SERVER_FTPDRIVE">/scratch/ ofsaa/ftpshare</InteractionVariable>

-
HIVE_SERVER_FTP_US ERID

Identifies the user who has RWX permissions on the directory identified under the preceding parameter HIVE_SERVER_FTPDRIVE.

For example,

InteractionVariable name="HIVE_SERVER_FTP_USERID">ofsaa</ InteractionVariable>

-
<Layer name="GENERAL">
InteractionGroup name="WebServerType"
VARIABLE NAME

Identifies the Infodom.

The variable should be provided as shown below:

Variable name="SWIFTINFO">CSTF807INFO</Variable>

Yes
WEBAPPSERVERTYPE

Identifies the web application server on which the OFSAA Infrastructure web components would be deployed.

The following numeric value should be set for WebLogic:

  • Oracle WebLogic Server = 3 For example, <InteractionVariable

name="WEBAPPSERVERTYPE">3</InteractionVariable>

Yes
HIVE_SERVER_FTP_PR OTOCOL

If the HIVE_SERVER_PORT is 21, then set value as FTP, else set it as SFTP.

For example,

InteractionVariable name="HIVE_SERVER_FTP_PROTOCOL">SFTP</

InteractionVariable>

-
HIVE_SFTP_PRIVATE_K EY

Identifies the SFTP private key for the HIVE server. For example,

<InteractionVariable name="HIVE_SFTP_PRIVATE_KEY">/ scratch/testuser/.ssh/id_rsa</InteractionVariable>

By default, the value is NA, which indicates password will be prompted for the user <HIVE_SERVER_FTP_USERID> for authentication.

For more information on generating SFTP Private key, see the Setting Up SFTP Private Key section.

-
HIVE_SFTP_PASSPHRA SE

Identifies the passphrase for the SFTP private key for HIVE.

For example,

<InteractionVariable name="HIVE_SFTP_PASSPHRASE">NA</

InteractionVariable>

By default, the value is NA.

If HIVE_SFTP_PRIVATE_KEY value is given and this is kept as NA, then it is assumed as empty passphrase.

-