6       Installation

Topics:

·        Installation Checklist

·        Configure the OFS_DM_PACK.xml File

·        Configure the Schema Creator Utility

·        Execute the Schema Creator Utility

·        Verify the Log File

·        Configure the OFSAAI_InstallConfig.xml File

·        Install the OFS Analytical Applications Reconciliation Framework Pack

·        Apply Post-installation Mandatory Patches

·        Verify the Log File

·        Verify the Installation

Installation Checklist

Table 16: Installation Checklist

Sl. No.

Installation Activity

1

Configure the OFS_DM_PACK.xml file.

2

Configure the OFS_DM_SCHEMA_IN.xml file. 

3

Configure the OFS DM_SCHEMA_BIGDATA_IN.xml file 

4

Execute the Schema Creator Utility in Online, Offline modes, and verify the log file.

5

Configure the OFSAAI_InstallConfig.xml file. 

6

Trigger the installation. 

7

Apply post-installation mandatory patches

8

Verify the log files

9

Verify the installation

 

Configure the OFS_DM_PACK.xml File

The OFS_DM_PACK.xml file has details of the products that are packaged in the OFSAA Reconciliation Framework Pack. This section provides information about the tags and parameters available in this file and the values you must update before installing the OFSAA Reconciliation Framework Pack.

NOTE:   

Enable licenses as per your Service Level Agreement (SLA).

 

NOTE:   

The Hybrid installation mode of OFSAA Reconciliation Framework supports only full Hive deployment for those application packs where Hive is enabled. (For example Oracle Financial Services Data Foundation). As a part of the installation process, you must use only the Hybrid templates to install OFSAA Reconciliation Framework on Hive.

 

To configure the OFS_DM_PACK.xml file, follow these steps:

1.     Navigate to the OFS_DM_PACK/conf directory.

2.     Open the OFS_DM_PACK.xml file in a text editor.

3.     Configure the OFS_DM_PACK.xml file as mentioned in the following table.

NOTE:   

In case of HIVE, rename the following files and then proceed.

·        OFS_DM_PACK.xml to OFS_DM_PACK.xml.bkp.

·        OFS_DM_PACK.xml.HYBRID.template to OFS_DM_PACK.xml.

 

Figure 4: Sample OFS_DM_PACK.xml File

 This illustration shows the sample of the OFS_DM_PACK.xml file.

Table 17: OFS_DM_PACK.xml File Parameters

Tag Name/ Attribute Name

Description

Mandatory (Y/ N)

Comments

APP_PACK_ID

Unique Application Pack Identifier

Y

Unique Seeded Value

DO NOT modify this value.

APP_PACK_NAME

Unique Application Pack Name

Y

Unique Seeded Value

DO NOT modify this value.

APP_PACK_DESCRIPTION

Unique Application Pack Description

Y

Unique Seeded Value

DO NOT modify this value.

VERSION

Unique release version

Y

Unique Seeded Value

DO NOT modify this value.

APP

Unique Application Entries

Y

Unique Seeded Value

DO NOT remove these tags.

APP_ID

Unique Application Identifier

Y

Unique Seeded Value

DO NOT modify this value.

APP_ID PREREQ

Prerequisite Application/ Product

Y

Unique Seeded Value

For most applications, Infrastructure is the prerequisite set. For certain other applications, an appropriate Application ID would be set.

DO NOT modify this value.

APP_ID DEF_SEL_FLG

Default Selected Flag

Y

Default - YES

In all application packs, Infrastructure would have this value set to YES.

DO NOT modify this value.

APP_ID ENABLE

Enable Application/ Product

Y

Possible Values: YES or NO

·        YES for Infrastructure

·        NO for Others

Set this attribute-value to YES against every APP_ID which is licensed and should be enabled for use.

Note: Application/ Product once enabled cannot be disabled. However, Application/ Product not enabled during installation can be enabled later through the Administration UI.

APP_NAME

Unique Application/ Product Name

Y

Unique Seeded Value

DO NOT modify this value.

APP_DESCRIPTION

Unique Application/ Product Name

Y

Unique Seeded Value

DO NOT modify this value.

VERSION

Unique release version

Y

Unique Seeded Value

DO NOT modify this value.

 

Configure the Schema Creator Utility

Creating database users/schemas (RDBMS) is one of the primary steps in the complete OFSAA Reconciliation Framework installation process. The Schema Creator Utility enables you to quickly get started with the installation by creating Database User(s)/ Schema(s) (RDBMS), assigning the necessary GRANT(s), creating the required entities in the schemas, and so on.

You must configure and execute the schema creator utility before installing any OFSAA Application Pack.

Topics:

·        Prerequisites

·        Configure Schema Creator Utility for RDBMS Installation

·        Configuring the Schema Creator Utility for Hive Schema

Prerequisites

Ensure you have the following before configuring the Schema Creator Utility:

·        Oracle User ID/Password with SYSDBA privileges.

·        JDBC Connection URL for RAC/Non-RAC database.

·        The HOSTNAME/IP of the server on which OFSAA is getting installed.

In the case of the HIVE installation, you must also have the following:

·        HIVE connection credentials (For example: Kerberos connection properties).

·        Hostname/IP of the HIVE server installation

·        Install mandatory schema creator patches. See Pre-install Mandatory Patches for details.

Configure the Schema Creator Utility for RDBMS Installation

If the installation is performed for RDBMS, provide the Pack specific schema details in the OFS_DM_SCHEMA_IN.xml file.

You can configure the following types of schemas:

·        CONFIG: This schema holds the entities and other objects required for OFSAA setup configuration information.

NOTE:   

There can be only one CONFIG schema per OFSAA instance.

 

·        ATOMIC: This schema holds the data model entities. One ATOMIC schema is attached to one Information Domain.

NOTE:   

There can be multiple ATOMIC schemas per OFSAA Instance.

 

Topics:

·        Configure the OFS_DM_SCHEMA_IN.xml File

·        Example of TDE Enablement and TABLESPACES with Encryption ON

Configure the OFS_DM_SCHEMA_IN.xml File

The OFS_DM_SCHEMA_IN.xml file contains details of the various application schemas. Update the values of the various tags and parameters available in this file before executing the Schema Creator Utility.

NOTE:   

·        This file must be configured if the database is RDBMS.

·        If using Hive, rename OFS_DM_SCHEMA_IN.xml to OFS_DM_SCHEMA_IN.xml.bkp and then rename OFS_DM_SCHEMA_BIGDATA_IN.xml.HYBRID.template to OFS_DM_SCHEMA_BIGDATA_IN.xml

·        This file need not be configured for an HDFS ONLY installation.

 

To configure the OFS_DM_SCHEMA_IN.xml file, follow these steps:

1.     Log in to the system as a non-root user.

2.     Navigate to the OFS_DM_PACK/schema_creator/conf directory.

3.     Edit the OFS_DM_SCHEMA_IN.xml file using a text editor and configure the values as mentioned in the following table.

4.     Save the file.

Figure 5: Sample OFS_DM_SCHEMA_IN.xml  File

This illustration shows the sample of the OFS_DM_SCHEMA_IN.xml file.

Table 18: OFS_DM_SCHEMA_IN.xml file Parameters

Tag Name/ Attribute Name

Description

Mandatory (Y/N)

Default Value/ Permissible Value

Comments

<APP_PACK_ID>

Unique Application Pack Identifier

Y

Unique Seeded Value

DO NOT modify this value.

<JDBC_URL>

Enter the JDBC URL.

Note: You can enter RAC and NON-RAC enabled database connectivity URL.

Y

Example,

jdbc:oracle:thin:@< DBSERVER IP/HOST/ IP>:<PORT>:<SID>

or

jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE

or

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[HOST])(port=[PORT]))(ADDRESS=(PROTOCOL=TCP)(HOST=[HOST])(PORT=[PORT]))(LOAD_BALANCE=yes)(FAILOVER=yes))(CONNECT_DATA=(SERVICE_NAME=[SERVICE])))

For example, jdbc:oracle:thin:@//dbhost.server.com:1521/service1

or

jdbc:oracle:thin:@//dbshost.server.com:1521/scan-1

or

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost1.server.com)(port=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost2.server.com)(PORT=1521))(LOAD_BALANCE=yes)(FAILOVER=yes))(CONNECT_DATA=(SERVICE_NAME=service1)))

Ensure you add an entry (with SID/ SERVICE NAME) in the tnsnames.ora file on the OFSAA server. The entry should match with the SID/ SERVICE NAME used in the JDBC URL.

<JDBC_DRIVER>

By default, this driver's name is seeded.

Note: Do not edit this attribute value.

Y

Example:

oracle.jdbc.driver.OracleDriver

Only JDBC Thin Driver is supported.

DO NOT modify this value.

<HOST>

Enter the Hostname/ IP Address of the system on which you are installing the OFSAA components.

Y

Host Name/ IP Address

 

<IS_HYBRID>/ VALUE = TRUE

Flag to identify the mode of installation

Y

TRUE

This flag value should be TRUE in case of Hybrid mode of installation only.

<SETUPINFO>/ NAME

Enter the acronym for the type of implementation. This information will be displayed in the OFSAA Home Page.

Note: On executing the Schema Creator Utility, this value will be prefixed with each schema name. For example: dev_ofsaaconf, uat_ofsaaatm.

Y

Accepts strings with a minimum length of two and a maximum of four.

Example,

DEV, SIT, PROD

This name would appear in the OFSAA Landing Page as Connected To: xxxx

The schemas being created would get this prefix. For E.g. dev_ofsaaconf, uat_ofsaaconf, etc.

<SETUPINFO>/ PREFIX_SCHEMA_NAME

Identifies if the value specified in <SETUPINFO>/ NAME attribute should be prefixed to the schema name.

N

YES or NO

The default value is YES.

<PASSWORD>/ APPLYSAMEFORALL

Enter Y if you want to apply the password specified in DEFAULT attribute for all the schemas.

If you enter N, you need to provide individual passwords for all schemas.

Note: In case you have entered Y in APPLYSAMEFORALL attribute and also have specified individual passwords for all the schemas, then the specified individual passwords will take precedence.

Y

Default N

Permissible Y or N

Setting this attribute value is mandatory if DEFAULT attribute is set.

<PASSWORD>/ DEFAULT*

Enter the password if you want to set a default password for all schemas.

Note: You must also set the APPLYSAMEFORALL attribute as Y to apply the default password for all the schemas.

N

The maximum length allowed is 30 characters. Special characters are not allowed.

 

<SCHEMA>/ TYPE

The types of schemas supported in this release are ATOMIC, CONFIG, SANDBOX, and ADDON.

By default, the schema types are seeded based on the Application Pack.

Note: Do not edit this attribute value.

Y

ATOMIC/CONFIG/SANDBOX/ADDON

 

Note:

SANDBOX AND ADDON schemas are not applicable for OFS AAAI Application Pack.

Only one CONFIG schema can exist in the file.
This schema identifies as the CONFIGURATION schema that holds the OFSAA setup details and other metadata information.

Multiple ATOMIC/ SANDBOX/ ADDON schemas can exist in the file.

ATOMIC schema refers to the Information Domain schema. SANDBOX schema refers to the SANDBOX schema. ADDON schema refers to another miscellaneous schema (not applicable to this application pack).

<SCHEMA.>/ NAME

By default, the schema names are seeded based on the application pack.

You can edit the schema names if required.

Note: The Schema Name will have a prefix of the SETUPINFO/ NAME attribute.

SCHEMA NAME must be same for all the ATOMIC Schemas of applications within an application pack.

Y

The permissible length is 15 characters and only alphanumeric characters are allowed. No special characters are allowed except underscore _.

SETUPINFO/ NAME attribute value would be prefixed to the schema name being created.

Fore.g., if you set ofsaaatm as the name and setupinfo as uat then schema being created would be uat_ofsaaatm.

NAME should be the same where APP_GRP=1 for all SCHEMA tags (not applicable for this application pack).

<SCHEMA>/ PASSWORD*

Enter the password of the schema to be created.

Note:

If this attribute is left blank, then the password specified in the <PASSWORD>/DEFAULT attribute is applied as the Schema Password.

N

The maximum length allowed is 30 characters. Special characters are not allowed.

Note: It is mandatory to enter the password if you have set the <PASSWORD>/ APPLYSAMEFORALL attribute as N.

<SCHEMA>/ APP_ID

By default, the Application ID is seeded based on the application pack.

Note: Do not edit this attribute value.

Y

Unique Seeded Value

Identifies the Application/ Product for which the schema is being created.

DO NOT modify this value.

<SCHEMA>/ DEFAULTTABLESPACE

Enter the available default tablespace for DB User.

Note:

If this attribute is left blank, then USERS is set as the default tablespace.

N

Default USERS

Permissible Any existing valid tablespace name.

Modify this value to associate any valid tablespace with the schema.

<SCHEMA>/ TEMPTABLESPACE

Enter the available temporary tablespace for the DB User.

Note:

If this attribute is left blank, TEMP is set as the default tablespace.

N

Default TEMP

Permissible Any existing valid temporary tablespace name.

Modify this value to associate any valid tablespace with the schema.

<SCHEMA>/ QUOTA

Enter the quota to be set on DEFAULTTABLESPACE attribute for the schema/ user. By default, the quota size is set to 500M. Minimum: 500M or Unlimited on default Tablespace

N

Example,

600M/m

20G/g

UNLIMITED/unlimited

Modify this value to grant the specified quota on the mentioned tablespace to the user.

<SCHEMA>/ INFODOM

Enter the name of the Information Domain to associate this schema.

The Schema Creator Utility automatically derives an Information Domain Name based on the Application Pack if no value is specified for this attribute.

N

(Optional for Atomic and mandatory for sandbox )

Permissible length is 16 characters and only alphanumeric characters allowed. No special characters allowed.

Enter this field in UPPERCASE.

If the OFSAA Reconciliation Framework Pack is the first media pack installation in the setup, then INFODOM has to be specified mandatorily else it is optional.

<ADV_SEC_OPTIONS>

Parent tag to hold Advance Security Options.  

N

 

Uncomment the tag and edit if you want to add security options. For example: TDE and Data Redact.

For details, see the example following the table.

<ADV_SEC_OPTIONS>/TDE

Tag to enable/disable TDE.

N

The default is FALSE. To enable TDE, set this to TRUE.

Ensure this tag is not commented if you have uncommented <ADV_SEC_OPTIONS>/

<ADV_SEC_OPTIONS>/ DATA_REDACT

Tag to enable/disable the Data Redaction feature.

N

The default is FALSE. To enable DATA_REDACT, set this to TRUE

Ensure this tag is not commented if you have uncommented <ADV_SEC_OPTIONS>/

<TABLESPACES>

Parent tag to hold <TABLESPACE> elements

N

NA

Uncomment the tag and edit. ONLY if tablespaces are to be created as part of the installation.

For details, see the example following the table.

Note: When TDE is TRUE in ADV_SEC_OPTIONS, then it is mandatory for the <TABLESPACES> tag to be present in the XML file.

<TABLESPACE>/ NAME

Logical Name of the tablespace to be created.

Y

 

Name. If specified, should be referred to in the <SCHEMA DEFAULTTABLESPACE= ##NAME##> attribute.

Note the ## syntax.

<TABLESPACE>/ VALUE

Physical Name of the tablespace to be created

Y

NA

Value, if specified, will be the actual name of the TABLESPACE.

<TABLESPACE>/ DATAFILE

Specifies the location of the data file on the server

Y

NA

Enter the absolute path of the file to be created.

<TABLESPACE>/ AUTOEXTEND

Specifies if the tablespace should be extensible or have a hard limit

Y

ON or OFF

Set to ON to ensure that the tablespace does not run out of space when full.

<TABLESPACE>/ ENCRYPT

Specifies if the tablespace(s) should be encrypted using TDE.

Y

ON or OFF

Set to ON to ensure that the tablespaces, when created, are encrypted using TDE.

 

Example of TDE Enablement and TABLESPACES with Encryption ON

Encryption of tablespaces requires enabling Transparent Data Encryption (TDE) on the Database Server.

The following snippet shows that TDE is enabled and therefore, the tablespaces are shown with the encryption ON.

--------------------------------------------------------------------------------------------------------------

<ADV_SEC_OPTIONS>

<OPTION NAME="TDE" VALUE="FALSE"/>

<OPTION NAME="DATA_REDACT" VALUE="FALSE" />

</ADV_SEC_OPTIONS>

<TABLESPACES>

<TABLESPACE NAME="OFS_AAI_TBSP_1" VALUE="TS_USERS1" DATAFILE="/scratch/ora19c/app/oracle/oradata/OFSPQA19CDB/ts_users1.dbf" SIZE="500M" AUTOEXTEND="ON" ENCRYPT="ON" />

<TABLESPACE NAME="OFS_AAI_TBSP_2" VALUE="TS_USERS2" DATAFILE="/scratch/ora19c/app/oracle/oradata/OFSPQA19CDB/ts_users2.dbf" SIZE="500M" AUTOEXTEND="ON" ENCRYPT="ON" />

</TABLESPACES>

 

<SCHEMAS>

<SCHEMA TYPE="CONFIG" NAME="ofsaaconf" PASSWORD="" APP_ID="OFS_AAI" DEFAULTTABLESPACE="##OFS_AAI_TBSP_1##" TEMPTABLESPACE="TEMP" QUOTA="unlimited"/>

<SCHEMA TYPE="ATOMIC" NAME="ofsaaatm" PASSWORD="" APP_ID="OFS_AAAI" DEFAULTTABLESPACE="##OFS_AAI_TBSP_2##" TEMPTABLESPACE="TEMP" QUOTA="unlimited" INFODOM="OFSAAAIINFO"/>

</SCHEMAS>

----------------------------------------------------------------------------

Configuring the Schema Creator Utility for Hive Schema

For configuring Schema Creator Utility for OFS Reconciliation Framework on Hive, navigate to /OFS_DM_PACK/schema_creator/conf and rename the following files (for Hive based installation use only the HYBRID template):

·        OFS_DM_SCHEMA_IN.xml to OFS_DM_SCHEMA_IN.xml.bkp

·        OFS_DM_CFG.dat to OFS_DM_CFG.dat.bkp

·        OFS_DM_SCHEMA_BIGDATA_IN.xml.HYBRID.template to OFS_DM_SCHEMA_BIGDATA_IN.xml

·        OFS_DM_CFG.dat.HYBRID.template to OFS_DM_CFG.dat

Fill the pack specific schema details in the OFS_DM_SCHEMA_BIGDATA_IN.xml file before executing the utility.

For more information on the XML file, see the Configure the OFS DM_SCHEMA_BIGDATA_IN.xml file.

You can configure the following types of schemas:

·        CONFIG: This schema holds the entities and other objects required for OFSAA setup configuration information.

NOTE:   

There can be only one CONFIG schema per OFSAA instance. This schema is created only in RDBMS.

 

·        METADOM: This schema holds the OFSAA Reconciliation Framework metadata information. One METADOM schema is attached to one information domain.

NOTE:   

There can be multiple METADOM schemas per OFSAA Instance. This schema is created only in RDBMS. It has only platform entities that hold the metadata details. However, it does not hold the data model entities.

 

·        DATADOM: This schema holds data model entities. One DATADOM schema is attached to one information domain.

NOTE:   

There can be multiple DATADOM schemas per OFSAA Instance.

 

Configure the OFS DM_SCHEMA_BIGDATA_IN.xml file

Configure this file only if installing OFS Analytical Applications Reconciliation Framework Pack for HDFS-ONLY target.

This file need not be configured for an RDBMS-ONLY target installation.

The OFS_DM_SCHEMA_BIGDATA_IN.xml file contains details of the various application schemas. Update the values of the various tags and parameters available in this file before executing the Schema Creator Utility.

To configure the OFS_DM_SCHEMA_BIGDATA_IN.xml file, follow these steps:

1.     Log in to the system as a non-root user.

2.     Navigate to the OFS_DM_PACK/schema_creator/conf directory.

3.     Rename the OFS_DM_SCHEMA_BIGDATA_IN.xml.HYBRID.template file to OFS_DM_SCHEMA_BIGDATA_IN.xml.

4.     Edit the OFS_DM_SCHEMA_BIGDATA_IN.xml file using a text editor and configure the values as mentioned in the following table.

5.     Save the file.

NOTE:   

On successful execution of the utility, the passwords entered in the OFS_DM_SCHEMA_IN.xml file are nullified.

 

NOTE:   

If there are any errors during the script execution, reconfigure the OFS_DM_SCHEMA_IN.xml file and execute the utility. This regenerates the scripts with the updated information.

 

NOTE:   

For Java 8, edit the VerInfo.txt file in the path /OFS_DM_PACK/OFS_AAI/bin/ to modify the value for property JAVA_VERSION to 1.8 and save the changes.

 

Figure 6: Sample OFS_DM_SCHEMA_BIGDATA_IN.xml File

This illustration shows the sample of the OFS_DM_SCHEMA_BIGDATA_IN.xml file.

Table 19: OFS_DM_SCHEMA_BIGDATA_IN.xml file Parameters

Tag Name/ Attribute Name

Description

Mandatory (Y/N)

Default Value/ Permissible Value

Comments

<APP_PACK_ ID>

Seeded unique ID for the OFSAA application pack

Y

Seeded

DO NOT modify this value.

<JDBC_URL>

Enter the JDBC URL

Note: You can enter the RAC/ NON-RAC enabled database connectivity URL.

Y

Example:

jdbc:oracle:thin:@<HOST/ IP>:<PORT>:<SID>

or

jdbc:oracle:thin:@//[HOS T][:PORT]/SERVICE

or

jdbc:oracle:thin:@(DESCRI PTION=(ADDRESS_ LIST=(ADDRESS=(PROT OCOL=TCP)(HOST=[HO ST])(port=[PORT]))(ADD RESS=(PROTOCOL=TCP) (HOST=[HOST])(PORT=[ PORT]))(LOAD_ BALANCE=yes)(FAILOV ER=yes))(CONNECT_ DATA=(SERVICE_ NAME=[SERVICE])))

For example: jdbc:oracle:thin:@//dbhos t.server.com:1521/service 1

or

jdbc:oracle:thin:@//dbsho st.server.com:1521/scan-1

or

jdbc:oracle:thin:@(DESCRI PTION=(ADDRESS_ LIST=(ADDRESS=(PROT OCOL=TCP)(HOST=dbho

st1.server.com)(port=1521)

)(ADDRESS=(PROTOCO

L=TCP)(HOST=dbhost2.s erver.com)(PORT=1521))( LOAD_ BALANCE=yes)(FAILOV ER=yes))(CONNECT_ DATA=(SERVICE_

NAME=service1)))

In the case of an HDFS ONLY target, this URL should be of the RDBMS instance that hosts the applications METADOM.

<JDBC_ DRIVER>

By default, this driver name is seeded.

Note: Do not edit this attribute value.

Y

Example:

oracle.jdbc.driver.OracleD river

Only JDBC Thin Driver is supported.

DO NOT modify this value.

<HOST>

Enter the Hostname/ IP Address of the system on which you are installing the OFSAA components.

Y

Host Name/ IP Address

 

<SETUPINFO>/ PREFIX_ SCHEMA_ NAME

Identifies if the value specified in the <SETUPINFO>/ NAME attribute should be prefixed to the schema name.

N

YES or NO

The default value is YES.

<SETUPINFO>/ NAME

Enter the acronym for the type of implementation. This information will be displayed in the OFSAA Home Page.

Note: On executing the Schema Creator Utility, this value will be prefixed with each schema name. For example: dev_ ofsaaconf, uat_ofsaaatm.

Y

Accepts strings with a minimum length of two and a maximum of four.

Example:

DEV, SIT, PROD

This name would appear in the OFSAA Landing Page as "Connected To: xxxx"

The schemas being created would get this prefix. For example: dev_ ofsaaconf, uat_ofsaaconf etc.

<PASSWORD>/ DEFAULT*

Enter the password if you want to set a default password for all schemas.

Note: You also need to set the APPLYSAMEFORALL attribute as Y to apply the default password for all the schemas.

N

The maximum length allowed is 30 characters. Special characters are not allowed.

Applies only to the RDBMS type METADOM schema(s).

<PASSWORD>/ APPLYSAMEFO RALL

Enter Y if you want to apply the password specified in DEFAULT attribute for all the schemas.

If you enter N, you must provide individual passwords for all schemas.

Note: In case you have entered Y in the APPLYSAMEFORALL attribute and also have specified individual passwords for all the schemas, then the specified individual passwords will take precedence.

Y

Default - N

Permissible - Y or N

Note: Setting this attribute value is mandatory If the DEFAULT attribute is set.

Applies only to the RDBMS type METADOM schema(s).

<SCHEMAS>/ TYPE=RDBMS

Identifies the RDBMS schema details.

Y

Default names for schemas within the pack would be derived in absence of any value specified.

In an HDFS ONLY target, the applications METADOM (that hosts the metadata) for an application is stored in RDBMS schema and the data model entities of the application are stored in the DATADOM (which would be on Hive).

<SCHEMA>/ TYPE

The different types of schemas that are supported in this release are ATOMIC, CONFIG, SANDBOX, and ADDON.

By default, the schema types are seeded based on the application pack.

Note: Do not edit this attribute value.

Y

ATOMIC/CONFIG/SANDBOX/ADDON

Note: SANDBOX AND ADDON schemas are not applicable for OFS AAAI Application Pack.

Only one CONFIG schema can exist in the file.

ATOMIC schema refers to the METADOM within the Information Domain.

CONFIGURATION schema holds the OFSAA setup details and other metadata information.

SANDBOX schema refers to the SANDBOX schema.

ADDON schema refers to other miscellaneous schemas (not applicable for this application pack).

Multiple ATOMIC/ SANDBOX/ ADDON schemas can exist in the file.

<SCHEMA>/ NAME

By default, the schema names are seeded based on the application pack.

You can edit the schema names, if required.

Note: The Schema Name will have a prefix of the SETUPINFO/ NAME attribute.

SCHEMA NAME must be the same for all the ATOMIC Schemas of applications within an application pack.

Y

The permissible length is 15 characters and only alphanumeric characters are allowed. No special characters are allowed except underscore '_'.

SETUPINFO/ NAME attribute value will be prefixed to the schema name being created.

For example, if the name is set as 'ofsaaatm' and setupinfo as 'uat' then schema being created would be 'uat_ofsaaatm'.

NAME should be the same where APP_GRP=1 for all SCHEMA tags (Not applicable for this application pack).

<SCHEMA>/ PASSWORD

Enter the password of the schema to be created.

Note: If this attribute is left blank, then the password specified in the <PASSWORD>/DEFAULT attribute is applied as the Schema Password.

N

The maximum length allowed is 30 characters. Special characters are not allowed.

Note: You need to mandatorily enter the password if you have set the <PASSWORD>/ APPLYSAMEFORALL attribute as N.

<SCHEMA>/ APP_ID

By default, the Application ID is seeded based on the application pack.

Note: Do not edit this attribute value.

Y

Unique Seeded Value

Identifies the Application/ Product for which the schema is being created.

DO NOT modify this value.

<SCHEMA>/ DEFAULTTABL ESPACE

Enter the available default tablespace for DB User.

Note:

If this attribute is left blank, then USERS is set as the default tablespace.

N

Default - USERS

Permissible - Any existing valid tablespace name.

Modify this value to associate any valid tablespace with the schema.

<SCHEMA>/ TEMPTABLESP ACE

If this attribute is left blank, then TEMP is set as the default tablespace.

N

Default - TEMP

Permissible - Any existing valid temporary tablespace name.

Modify this value to associate any valid tablespace with the schema.

<SCHEMA>/ QUOTA

Enter the quota to be set on DEFAULTTABLESPACE attribute for the schema/ user. By default, the quota size is set to 500M.

Minimum: 500M or Unlimited on default Tablespace

N

Example, 600M/m 20G/g UNLIMITED/unlimited

Modify this value to grant the specified quota on the mentioned tablespace to the user.

<SCHEMAS>/ TYPE=HDFS

Type of schemas being created.

Y

 

Refers to the DATADOM of the application pack being installed.

<HIVE_ SERVER_ HOST>

IP/Hostname of the server where HIVE is installed.

Y

 

 

<HIVE_LIB_ PATH>

Folder path where HIVE related drivers/jar files are copied.

Y

 

Should contain the list of jars mentioned in the sections: Copy Jars to the OFSAA Installation Directory and Copy KEYTAB and KRB5 Files in OFSAAI. Manually copy the preceding listed files from CDH distribution to this identified folder.

<SCHEMA>/ NAME

By default, the schema names are seeded based on the application pack.

You can edit the schema names if required.

Note: The Schema Name will have a prefix of the SETUPINFO/ NAME attribute.

Y

The permissible length is 20 characters and only alphanumeric characters are allowed.

Schema Name should not be the same as Schema Name specified for Schema Type ATOMIC.

<SCHEMA>/ TYPE

Identifies the type of schema where the data model entities would reside.

Y

By default, the TYPE attribute in this tag is set to DATADOM.

DO NOT modify this value.

<SCHEMA>/ DB TYPE

Identifies the type of driver to be used for the connection.

Y

By default, the only supported type is HIVE in this release.

In the upcoming releases, the type value can be HIVE/ IMPALA, etc.

<SCHEMA>/<P ROPERTY>/CO MMENT

COMMENTS for HIVE schema

N

 

 

<SCHEMA>/<P ROPERTY>/LO CATION

You can optionally specify a location for the table data

N

 

 

<CONNECTION_ PROPERTIES>/<PROPERTY>/J DBC_DRIVER

HIVE JDBC driver details

Y

com.cloudera.hive.jdbc4.HS2Driver

The default Cloudera HiveServer 2 driver name.

<CONNECTION_ PROPERTIES>/<PROPERTY>/J DBC_URL

Enter HIVE JDBC URL

Y

JDBC URL format : jdbc:hive2://<FQDN>:<port>/<db>;AuthMech=1;KrbServiceName=<KrbServiceName>;KrbHostFQDN=<FQDN>;KrbRealm=<KrbRealm>

Example: jdbc:hive2://abc.in.oracle.com:10000/GLDATADOM;AuthMech=1;KrbServiceName=hive;KrbHostFQDN=abc.in.oracle.com;KrbRealm=ABC.ORACLE.COM

<db> name should be same as Datadom name given in <SCHEMA>/ NAME

<CONNECTION_ PROPERTIES>/<PROPERTY>/ AUTH_TYPE

Authentication Type

Y

Permissible values: KERBEROS_WITH_ KEYTAB

Only Kerberos with keytab based authentication is supported in this release.

<CONNECTION_ PROPERTIES>/<PROPERTY>/ AUTH_ALIAS

Alias name for authentication credentials

Y

 

An Alias name mapping to a principal and password combination specified in the following tags.

<CONNECTION_ PROPERTIES>/<PROPERTY>/ PRINCIPAL

Authentication principal name

Y

 

Principal name used in authentication to connect to the Hive Server.

<CONNECTION_ PROPERTIES>/<PROPERTY>/ PASSWORD

Authentication password

Y

 

Password used in authentication to connect to the Hive Server.

<CONNECTION_ PROPERTIES>/<PROPERTY>/ KRB_GSSJAAS_ FILE_NAME

A keytab file containing pairs of Kerberos principals and an encrypted copy of that principal's key.

Y

 

This file should be copied to the location specified in <HIVE_LIB_PATH>

<CONNECTION_ PROPERTIES>/<PROPERTY>/ KRB_REALM_ FILE_NAME

REALM configuration file

Y

 

This file should be copied to the location specified in

<HIVE_LIB_PATH>

 

Execute the Schema Creator Utility

Depending on the option selected to run the OFSAA Application Pack installer, you must select the appropriate schema creator utility execution option from the following options:

·        Execute the Schema Creator Utility in Offline Mode

·        Execute the Schema Creator Utility in Online Mode

·        Execute the Schema Creator Utility while Installing Subsequent Applications Pack

Execute the Schema Creator Utility in Offline Mode

In the Offline mode, the utility generates an SQL script with all the required DDLs for Users, Objects, and Grants. This script must be executed by the DBA on the appropriate database identified for OFSAA usage. If you do not have the SYSDBA privileges, you can execute the Schema Creator Utility in the Offline mode and generate the script file that contains the Schemas, Objects, and Grants information. Subsequently, a SYSDBA user can execute the script file manually. To run the OFSAA Application Pack installer in Silent mode, it is mandatory to execute the schema creator utility with the -s option.

To execute the utility in Offline mode, you must have a database user with the following GRANTS (alternatively, you can also connect as a user with SYSDBA privileges):

·        SELECT ON DBA_ROLES

·        SELECT ON DBA_USERS

·        SELECT ON DBA_DIRECTORIES

·        SELECT ON DBA_TABLESPACES

·        CREATE SESSION

NOTE:   

Explicit Grants to the user are required. Grants assigned through Roles are not supported.

 

To execute the schema creator utility in the offline mode, follow these steps:

1.     Log in to the system as a non-root user.

2.     Navigate to the /OFS_DM_PACK/schema_creator/bin folder.

3.     Execute the osc.sh file using the following command:

./osc.sh -s -o

The following message is displayed:

You have chosen OFFLINE mode. Triggering the utility in OFFLINE mode will generate the script. Do you wish to proceed? (Y/y or N/n).

4.     Enter Y to proceed.

5.     Enter the DB Username with SELECT privileges.

6.     Enter the User Password.

7.     The console runs the initial validation checks and displays the following message:

You have chosen to install this Application Pack on <Name of the Atomic Schema> ATOMIC schema. Do you want to proceed? (Y/N).

8.     Enter Y to start the script generation. The following message is displayed:

You have chosen to install this Application Pack on <Name of the Infodom>. Do you want to proceed? (Y/N).

On successful execution of the schema creator utility, the console displays the following status message:

Schema Creator executed successfully. Please execute /OFS_DM_PACK/schema_creator/sysdba_output_scripts.sql before proceeding with the installation.

NOTE:   

If there are any errors during the SQL script execution, reconfigure the OFS_DM SCHEMA_IN.xml, and repeat steps in this procedure to execute the utility. This regenerates the scripts with the correct information.

 

9.     Navigate to the OFS_DM_PACK/schema_creator directory.

10.  Log in to SQLPLUS as a user having SYSDBA Privileges.

11.  Execute the sysdba_output_scripts.sql file using the following command:

SQL>@sysdba_output_scripts.sql

Alternatively, you can copy the sysdba_output_scripts.sql file and SQLScripts directory to a remote server and execute the sysdba_output_scripts.sql file after providing appropriate execute permissions.

12.  Make a TNS entry for the new users created. For details, see Add the TNS entries in TNSNAMES.ORA file section.

NOTE:   

See the sysdba_output_scripts.log file for execution status. If there are any errors, contact Oracle Support. If there are no errors in the execution, the log file is empty.

 

The result of this task is that the OFS_DM_SCHEMA_OUTPUT.XML file is generated. Do not modify this file.

After creating the schema, proceed to Configure the OFSAAI_InstallConfig.xml File section.

Execute the Schema Creator Utility in Online Mode

In the Online mode, the utility connects to the database and executes the DDLs for Users, Objects, and Grants. If you have SYSDBA privileges you can execute the Schema Creator Utility in the Online mode and thereby create the Users, Objects, and Grants during the execution process. To execute the utility in the Online mode, you must connect as "<User> AS SYSDBA".

If you want to run the OFSAA Application Pack Installer in the Online mode, it is mandatory to execute the schema creator utility with the -s option.

To execute the utility with the -s option in the Online mode, follow these steps:

1.     Edit the file /OFS_DM_PACK/schema_creator/conf/OFS_DM_SCHEMA_IN.xml in a text editor. See Configure the OFS_DM_SCHEMA_IN.xml  File section for values to modify in the XML file.

2.     Execute the utility with the -s option. Example: ./osc.sh -s

3.     Make a TNS entry for the new users created. For details, see  Add the TNS entries in TNSNAMES.ORA file.

The following message is displayed:

You have chosen ONLINE mode. Triggering the utility in ONLINE mode will execute the DDLs directly on the Database. Do you wish to proceed? (Y/y or N/n).

4.     Enter Y to proceed.

The following message is displayed:

You have chosen to install this application pack on INFODOM <INFODOM_NAME>. Do you wish to proceed? (Y/y or N/n).

5.     Enter Y to proceed.

The result of this task is that the OFS_DM_SCHEMA_OUT.XML file is generated. Do not modify this file.

After creating the schema, proceed to the Configure the OFSAAI_InstallConfig.xml File section.

Execute the Schema Creator Utility while Installing Subsequent Applications Pack

When executing the Schema Creator Utility during the installation of a subsequent Applications Pack, you can choose to install the pack either on the same Information Domain /Atomic Schema of the existing application pack or on a new Information Domain / Atomic Schema. You can execute the Schema Creator Utility either in the Online or the Offline mode.

NOTE:   

OFS Analytical Applications Reconciliation Framework Pack can be installed on any Information Domain/ Atomic schema where any OFS Application Pack is installed other than OFS Behavior Detection Application Pack or OFS Compliance Regulatory Reporting Application Pack.

 

To execute the Schema Creator Utility while installing OFSAA Reconciliation Framework Application Pack over an existing Application Pack, follow these steps:

1.     Edit the file /OFS_DM_PACK/schema_creator/conf/OFS_DM_SCHEMA_IN.xml in a text editor. See the Configure the OFS_DM_SCHEMA_IN.xml  File  section for values to modify in the XML file.

2.     Execute the utility with the -s option. Example: ./osc.sh s -o

After the schema creation is successful, execute the sysdba_output_scripts.sql file

NOTE:   

You must use the same config schema user name as the previous application pack.

 

3.     The utility identifies the application packs that are already installed on the current OFSAA setup and displays the following on the console:

§       Atomic schema of the existing application pack

§       Information Domain Name of the existing pack

§       List of installed application packs

4.     Enter Y/y to start the schema creation.

5.     If you enter N/n, the list of Atomic Users is displayed.

6.     Select the Atomic User on which you want to install the application pack.

7.     Make a TNS entry for the new users created. For details, see Add TNS entries in TNSNAMES.ORA file section.

On successful execution of the Schema Creator Utility, the console displays the following status message:

Success. Please proceed with the installation.

NOTE:   

1.      See the log file in OFS_DM_PACK/schema_creator/ logs directory for execution status.

2.      See the log file sysdba_output_scripts.log for execution status if executed in the Offline mode. This log will be empty if there are no errors in execution.

3.      If there are any errors, contact Oracle Support.

 

Verify the Log File

If schema creation is successful, the console will display an appropriate message. However, if the schema creation runs into errors, see the following log file.

<<OFSDMAP Installer directory>>/<<OFS_DM_PACK>>/schema_creator/logs/<<OFS_DM>>_osc_<timestamp>.log for further details.

You may contact Oracle support anytime for assistance.

Configure the OFSAAI_InstallConfig.xml File

To configure the OFS_InstallConfig.xml file, follow these steps:

1.     Navigate to the OFS_DM_PACK/OFS_AAI/conf/ directory.

2.     Open the OFSAAI_InstallConfig.xml file in a text editor.

3.     Configure the OFSAAI_InstallConfig.xml file as mentioned in the following table.

4.     Manually set the InteractionVariable parameter values as mentioned in the table. If a value is not applicable, enter NA. Ensure that the value is not entered as NULL.

Table 20: OFSAAI_InstallConfig.xml file Parameters

Interaction Variable Name

Significance and Expected Value

<Layer name="GENERAL">

 

InteractionGroup name="WebServerType"

This illustration shows Significance and Expected Value of the InteractionGroup name="WebServerType".

WEBAPPSERVERTYPE

(Mandatory)

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

Set the following numeric value depending on the type:

·        Apache Tomcat = 1

·        IBM WebSphere Application Server = 2

·        Oracle WebLogic Server = 3

For example,  <InteractionVariable name="WEBAPPSERVERTYPE">3</InteractionVariable>

InteractionGroup name="OFSAA Infrastructure Server Details"

This illustration shows Significance and Expected Value of the InteractionGroup name="OFSAA Infrastructure Server Details".

DBSERVER_IP

(Mandatory)

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">IPAddress</InteractionVariable> or

<InteractionVariable name="DBSERVER_ IP">dbhost.server.com</InteractionVariable>

InteractionGroup name="Database Details"

This illustration shows Significance and Expected Value of the InteractionGroup name="Database Details".

ORACLE_SID/SERVICE_ NAME

(Mandatory)

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>

ABS_DRIVER_PATH

(Mandatory)

Identifies the directory where the JDBC driver (ojdbc<version>.jar) exists. This would typically be: $ORACLE_HOME/jdbc/lib

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

InteractionGroup name="OLAP Detail"

This illustration shows Significance and Expected Value of the InteractionGroup name="OLAP Detail".

OLAP_SERVER_ IMPLEMENTATION

(Optional)

Identifies if the OFSAA Infrastructure OLAP component must be configured depending on whether you intend to use the OLAP feature. Set one of the following values:

·        YES - 1

·        NO - 0

Note: If the value for OLAP_SERVER_IMPLEMENTATION is set to 1, a check is performed to determine if the following environment variables are set in the .profile file:

ARBORPATH, HYPERION_HOME, and ESSBASEPATH.

InteractionGroup name="SFTP Details"

This illustration shows Significance and Expected Value of the InteractionGroup name="SFTP Details".

SFTP_ENABLE

(Mandatory)

Identifies if the SFTP (Secure File Transfer Protocol) feature has to be enabled. Set one of the following values:

·        For SFTP, set this field to 1 or -1.  1

·        For FTP, set this field to  - 0

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 use FTP by setting SFTP_ENABLE to 0. You can change this selection later by using the OFSAAI administration interface.

Set SFTP_ENABLE to -1 to configure ftpshare and weblocal path as local path mounted for the OFSAAI server.

FILE_TRANSFER_PORT

(Mandatory)

Identifies the port used for the file transfer service. The default value specified is 22 (SFTP). Specify default value as 21 (FTP) if SFTP_ENABLE is 0. Alternatively, this value can be any Port configured by System Administrators to support SFTP/FTP.

For example: <InteractionVariable name="FILE_TRANSFER_ PORT">21</InteractionVariable>

InteractionGroup name="Locale Detail"

This illustration shows Significance and Expected Value of the InteractionGroup name="Locale Detail".

LOCALE

(Mandatory)

Identifies the locale information to be used during the installation. Only US English is currently supported.

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

InteractionGroup name="OFSAA Infrastructure Communicating ports"

This illustration shows Significance and Expected Value of the InteractionGroup name="OFSAA Infrastructure Communicating ports". These ports are used internally by the various OFSAA Infrastructure services. The default values mentioned are set in the installation. To specify a different value, update the parameter value accordingly, and ensure the port value is in the range of 1025 to 65535 and the respective port is enabled. 

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

JAVAPORT

(Mandatory)

9999

NATIVEPORT

(Mandatory)

6666

AGENTPORT

(Mandatory)

6510

ICCPORT

(Mandatory)

6507

ICCNATIVEPORT

(Mandatory)

6509

OLAPPORT

(Mandatory)

10101

MSGPORT

(Mandatory)

6501

ROUTERPORT

(Mandatory)

6500

AMPORT

(Mandatory)

6505

InteractionGroup name="Web Details"

 

HTTPS_ENABLE

(Mandatory)

This illustration shows Significance and Expected Value of the HTTPS_ENABLE.

Identifies if the UI should be accessed using the HTTP or HTTPS scheme. The default value is 0. Set one of the following values:

·        YES - 1

·        NO - 0

Note: If the 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.

WEB_SERVER_IP

(Optional)

This illustration shows Significance and Expected Value of the 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">MyWebserverIPAddress</InteractionVariable>

or

<InteractionVariable name="WEB_SERVER_ IP">myweb.server.com</InteractionVariable>

WEB_SERVER_PORT

(Optional)

This illustration shows Significance and Expected Value of the WEB_SERVER_PORT. The port value will not be accepted as 80 if HTTPS_ENABLE is 1 and as 443 if HTTPS_ENABLE is 0.

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 the 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>

CONTEXT_NAME

(Mandatory)

This illustration shows Significance and Expected Value of the CONTEXT_NAME. Identifies the web application context name which will be used to build the URL to access the OFSAA applications.

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

<scheme>://<host>:<port>/<context-name>/login.jsp

Sample URL:

https://myweb:443/ofsaadev/login.jsp

For example: <InteractionVariable name="CONTEXT_ NAME">ofsaadev</InteractionVariable>

WEBAPP_CONTEXT_PATH

(Mandatory)

This illustration shows Significance and Expected Value of the WEBAPP_CONTEXT_PATH. Identifies the absolute path of the exploded .ear file on the Web Application Server.

Identifies the absolute path of the exploded .ear file on the Web Application Server.

·        For Tomcat, specify the Tomcat directory path till /webapps. Example:

/oradata6/revwb7/tomcat/webapps/.

·        For WebSphere, enter the WebSphere path as <WebSphere profile directory>/installedApps/<NodeCellName>. Example:

/data2/test//WebSphere/AppServer/profiles/<Profile_Name>/installedApps/aix-imfNode01Cell. Where aix-imf is Host name.

·        For WebLogic, provide the WebLogic home directory path as /<WebLogic home directory path>/bea/wlserver_10.3

WEB_LOCAL_PATH

(Mandatory)

This illustration shows Significance and Expected Value of the 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 application�s usage.

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 the directory is the same on all the nodes.

InteractionGroup name="Weblogic Setup Details"

 

WEBLOGIC_DOMAIN_HOME

(Optional)

This illustration shows Significance and Expected Value of the WEBLOGIC_DOMAIN_HOME. Identifies the WebLogic Domain Home. Specify the value only if WEBSERVERTYPE is set as 3 (WebLogic).

Identifies the WebLogic Domain Home. Specify the value only if WEBSERVERTYPE is set as 3 (WebLogic).

For example, <InteractionVariable name="WEBLOGIC_DOMAIN_HOME">/home/weblogic/bea/user_projects/domains/mydomain</InteractionVariable>

InteractionGroup name="OFSAAI FTP Details"

 

OFSAAI_FTPSHARE_PATH

(Mandatory)

This illustration shows Significance and Expected Value of the OFSAAI_FTPSHARE_PATH. Identifies the absolute path to the directory identified as the file system stage area.

Identifies the absolute path to the directory identified as the 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).

The user mentioned in APP_SFTP_USER_ID parameter below should have RWX permission on the directory.

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

OFSAAI_SFTP_USER_ID

(Mandatory)

This illustration shows Significance and Expected Value of the OFSAAI_SFTP_USER_ID. Identifies the user who has RWX permissions on the directory identified under the APP_FTPSHARE_PATH parameter.

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

OFSAAI_SFTP_ PRIVATE_KEY

(Optional)

This illustration shows Significance and Expected Value of the OFSAAI_SFTP_ PRIVATE_KEY. Identifies the SFTP private key for OFSAAI.

Identifies the SFTP private key for OFSAAI. 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 the SFTP Private key, see the Set Up the SFTP Private Key section.

OFSAAI_SFTP_ PASSPHRASE

(Optional)

This illustration shows Significance and Expected Value of the OFSAAI_SFTP_ PASSPHRASE. Identifies the passphrase for the SFTP private key for OFSAAI.

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 NA, then it is assumed to be an empty passphrase.

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

(Mandatory only for HIVE configuration)

This illustration shows Significance and Expected Value of the 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.

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>

HIVE_SERVER_ FTPDRIVE

(Mandatory only for HIVE configuration)

This illustration shows Significance and Expected Value of the HIVE_SERVER_ FTPDRIVE. Identifies the absolute path to the directory identified as the file system stage area of the HIVE server.

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

For example:

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

HIVE_SERVER_FTP_ USERID

(Mandatory only for HIVE configuration)

This illustration shows Significance and Expected Value of the HIVE_SERVER_FTP_ USERID. Identifies the user who has RWX permissions on the directory identified under the preceding parameter HIVE_SERVER_FTPDRIVE.

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>

HIVE_SERVER_FTP_ PROTOCOL

(Mandatory only for HIVE configuration)

This illustration shows Significance and Expected Value of the HIVE_SERVER_FTP_ PROTOCOL. If the HIVE_SERVER_PORT is 21, then set the value as FTP, else set it as SFTP.

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

For example:

InteractionVariable name="HIVE_SERVER_FTP_ PROTOCOL">SFTP</InteractionVariable>

HIVE_SFTP_PRIVATE_ KEY

(Mandatory only for HIVE configuration)

This illustration shows Significance and Expected Value of the HIVE_SFTP_PRIVATE_ KEY. Identifies the SFTP private key for the HIVE server.

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 the password will be prompted for the user <HIVE_SERVER_FTP_USERID> for authentication.

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

HIVE_SFTP_ PASSPHRASE

(Mandatory only for HIVE configuration)

This illustration shows Significance and Expected Value of the HIVE_SFTP_ PASSPHRASE. Identifies the passphrase for the SFTP private key for HIVE.

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 NA, then it is assumed to be an empty passphrase.

 

Adding FTP/ SFTP Configuration for File Transfer

In OFSAA, certain modules require the transfer of files from the web application server to the OFSAA server over SSH.

To ensure the OFSAA server recognizes the web application server during file transfers, follow these steps:

1.     Login to the web application server.

2.     Type sftp <user>@<OFSAA Server>

3.     Specify Yes when prompted for permission. This will add an entry into the "known_hosts" file and a confirmation message is displayed.

Set Up the SFTP Private Key

Log in to the OFSAA UNIX user using the Putty tool, and where you are installing generate a pair of authentication keys using the ssh-keygen command. If required, set a passphrase else set the OFSAAI_SFTP_PASSPHRASE tag to NA.

To generate a private key, enter the commands as shown:

ssh-keygen -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (/home/ofsaapp/.ssh/id_rsa):

Created directory '/home/ofsaapp/.ssh'.

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /home/ofsaapp/.ssh/id_rsa.

Your public key has been saved in /home/ofsaapp/.ssh/id_rsa.pub.

The key fingerprint is:

3e:4f:05:79:3a:9f:96:7c:3b:ad:e9:58:37:bc:37:e4

ofsaapp@OFSASERVER:~> cat /home/ofsaapp/.ssh/id_rsa.pub >> /home/ofsaapp/.ssh/authorized_keys

Ensure the following permissions exist for the given directories:

·        permissions of .ssh must be 700

·        permissions of .ssh/authorized_keys must be 640

·        permission of .ssh/id_rsa must be 400

·        Permission of UNIX User created must be 755

Install the OFS Analytical Applications Reconciliation Framework Pack

To install the OFSAA Reconciliation Framework Pack, perform the following steps:

1.     Log in to the system as non-root user.

2.     Identify a directory for installation and set the same in the user .profile file as FIC_HOME=<OFSAA Installation Directory>export FIC_HOME

3.     Execute the user .profile.

4.     Navigate to the /OFS_DM_PACK/schema_creator/conf directory and depending on whether you are installing on an RDBMS or Hive-Hybrid installation, perform one of the following:

a.     RDBMS: Edit the OFS_DM_SCHEMA_IN.xml to set the appropriate attribute values. Optionally, you can include INFODOM = <Infodom Name> in the OFS_DM_SCHEMA_IN.xml file. If not specified, a default INFODOM name is generated. See Configure the OFS_DM_SCHEMA_IN.xml File for more details.

b.     Hive-Hybrid: Rename the OFS_DM_SCHEMA_IN.xml to OFS_DM_SCHEMA_IN.xml.bkp and then rename OFS_DM_SCHEMA_BIGDATA_IN.xml.HYBRID.template to OFS_DM_SCHEMA_BIGDATA_IN.xml. Edit the OFS_DM_SCHEMA_BIGDATA_IN.xml to set the appropriate attribute values. See Configure the OFS DM_SCHEMA_BIGDATA_IN.xml file for more details.

NOTE:   

Ensure you create TNS entries for the users who have been created in the TNSNAMES.ORA file. For details, see Add TNS entries in the TNSNAMES.ORA File.

 

5.     Execute the Schema Creator Utility with the option.

NOTE:   

This is a mandatory step and must be executed before every additional OFSAA application pack installation. See Execute the Schema Creator Utility for more details.

 

6.     Navigate to the /OFS_DM_PACK/conf/ directory and depending on whether you are installing on an RDBMS or Hive-Hybrid installation, perform one of the following:

a.     RDBMS: Edit the OFS_DM_PACK.xml to enable product licenses. Set the attribute ENABLE=YES of <APP_ID> tag to license the app.

b.     Hive-Hybrid: In case of Hive-Hybrid based installation for OFSAA Reconciliation Framework, rename the OFS_DM_PACK.xml to OFS_DM_PACK.xml.bkp and then rename OFS_DM_PACK.xml.HYBRID.template to OFS_DM_PACK.xml. Now edit the OFS_DM_PACK.xml to enable the product licenses. Update the attribute ENABLE=YES/NO for licensing the app in the pack.

c.     If any application mentions OFS_AAAI as PREREQ in the <APP_ID> tag, set the attribute ENABLE=YES for OFS_AAAI.

NOTE:   

See Configure the OFS_DM_PACK.xml File for more details.

 

7.     Navigate to the /OFS_DM_PACK/OFS_AAI/conf/ directory and edit theOFSAAI_InstallConfig.xml file to set the appropriate infrastructure installation attribute values.

NOTE:   

This step can be ignored if an installation of OFSAA 8.1.0.0.0 already exists. See Configure the OFSAAI_InstallConfig.xml File for more details.

 

8.     Create a copy of the Silent.template file present in the installer /OFS_DM_PACK/appsLibConfig/conf location and rename it as Silent.props.

9.     In the case of Hive-Hybrid based installation for OFSAA Reconciliation Framework, only use the HYBRID template and perform the following steps:

a.     Rename Silent.template.HYBRID.template to Silent.props.

b.     Navigate to /OFS_DM_PACK/OFS_GLRECON/conf

c.     Rename default.properties to default.properties.bkp.

d.     Rename default.properties.HYBRID.template to default.properties.

Silent installation is achieved via a properties file [Silent.props] that must be updated with proper values, before attempting to install using the silent mode. The following table lists all the properties that need to be specified:

NOTE:   

In the Hybrid mode of installation of the OFSAA Reconciliation Framework Pack 8.1.0.0.0, the following parameters in the Silent.props (after renaming from Silent.template.HYBRID.template) must be configured as: UPLOAD_MODEL=1

Table 21: Silent Mode Installation properties

Property Name

Description of Property

Permissible values

Comments

LOG_MODE

Mode for logging

1 = Debug

0= General

Default : 0

SEGMENT_1_CODE

Segment Code

Not Applicable

Provide a new segment code for OFSAA Reconciliation Framework Pack.

APFTP P_LOG_PATH=

Infodom Maintenance log path(to be created) for the new RDBMS Infodom

Not Applicable

 

DBFTP_LOG_PATH

Infodom Maintenance log path(to be created) for the new RDBMS Infodom

Not Applicable

 

HIVE_APPFTP_LOG_PATH

Infodom Maintenance log path(to be created) for the new HIVE Infodom

Not Applicable

Applicable only for Hybrid Installation

HIVE_DBFTP_LOG_PATH

Infodom Maintenance log path(to be created) for the new HIVE Infodom

Not Applicable

Applicable only for Hybrid Installation

UPLOAD_MODEL

Specify if you want to perform Model Upload for RDBMS

·        0 = If you have already performed Model Upload and want to skip the model upload process

·        1 = If you want to perform Model Upload

 

MODEL_TYPE

Specify if you want to use the released datamodel or customized datamodel for model upload process for RDBMS

·        0 = If you want to upload the released datamodel

·        1 = If you want to upload the customized datamodel

 

DATAMODEL

Specify the file (DATAMODEL) name for the customized datamodel for RDBMS

Not Applicable

Mandatory only if you want to upload the customized datamodel i.e. you have specified MODEL_TYPE=1

DM_DIRECTORY

Specify the path (DM_DIRECTORY) for the customized datamodel for RDBMS

Not Applicable

Mandatory only if you want to upload the customized datamodel i.e you have specified MODEL_TYPE=1

HIVE_UPLOAD_MODEL

Specify if you want to perform Model Upload for HIVE

·        0 = If you have already performed Model Upload and want to skip the model upload process

·        1 = If you want to perform Model Upload

Applicable only for Hybrid installation.

HIVE_MODEL_TYPE

Specify if you want to use the released datamodel or the customized datamodel for the model upload process for HIVE

·        0 = If you want to upload the released datamodel

·        1 = If you want to upload the customized datamodel

Applicable only for Hybrid installation.

DATAMODEL_HIVE

Specify the file(DATAMODEL) name for the customized datamodel for HIVE

Not Applicable

Applicable only for Hybrid installation.

Mandatory only if you want to upload the customized datamodel i.e. you have specified MODEL_TYPE=1

DM_DIRECTORY

Specify the path (DM_DIRECTORY)  for the customized datamodel for HIVE

Not Applicable

Applicable only for Hybrid installation.

Mandatory only if you want to upload the customized datamodel i.e. you have specified MODEL_TYPE=1

ETL_APPSRC_TYPE

Specify if you want create a new ETL Src or use an existing one

·        0 = If you want to create a new ETL src

·        1 = If you want to use an existing pair

 

ETL_SRC_1_NAME

Specify a new ETL Source Name for RDBMS

Not Applicable

 

ETL_SRC_2_NAME

Specify a new ETL Source Name for HIVE

Not Applicable

Applicable only for Hybrid installation.

ETL_SRC_1_DESC

Specify a new ETL Source Description for RDBMS

Not Applicable

 

ETL_SRC_2_DESC

Specify a new ETL Source Description for HIVE

Not Applicable

Applicable only for Hybrid installation.

 

10.  On successful execution of the Schema Creator Utility, navigate to OFS_DM_PACK/bin/ and execute the application pack installer with the SILENT option.

11.  Execute ./setup.sh SILENT in the console.

12.  Enter the Infrastructure FTP/SFTP password value, when prompted.

Table 22: FTP/SFTP Console Prompts

Console Prompts

User Inputs

Please enter Infrastructure FTP/SFTP password

Enter the password to access Product Staging/Metadata repository directory in the application server.

13.  Enter Always, when prompted to add host key fingerprint.

The OFSAAI License Agreement is displayed.

14.  To accept the License Agreement, enter Y/y.

NOTE:   

SYSADMN and SYSAUTH are the two default OFSAAI administrative users created.

 

NOTE:   

The installation process continues on the console. Do not close the console until the installation process is complete.

 

15.  The following message is displayed in the console:

Installation completed.

Congratulations! Your installation is complete.

Apply Post-installation Mandatory Patches

The following table provides information about the mandatory patches you must apply after installing the OFSAA Reconciliation Framework Pack.

Table 23: Mandatory Patches

One-Off Patch

Description

31605076

Access features owing to the additional license functionality that get installed through the OFS AAI Extension Pack. Download and install this patch from My Oracle Support.

31498038

If you install OFSAA Reconciliation Framework Pack before any other OFSAA application, download and install this patch from My Oracle Support.

Verify the Log File

Refer the following logs files for more information:

·        Refer the Pack_Install.log in the OFS_DM_PACK/logs/ directory for the OFSAA Reconciliation Framework Pack installation log file.

·        Refer the log file(s) located at OFS_DM_PACK/OFS_AAI/logs/ directory for Infrastructure installation log.

·        Refer the log file(s) located at OFS_DM_PACK/OFS_GLRECON/logs directory for application installation log.

NOTE:   

If you are installing an application pack on an environment, where another application pack is already installed, you may get a warning message: "Object Already Exists". You can ignore this message.

 

NOTE:   

For Pack on Pack installation, the following errors might be logged in the installation log. You can ignore these messages.

 

-----------------------------------------------------------------------

'create sequence SEQ_DIM_GL_ACCOUNT

  minvalue 1

maxvalue 999999999999999999999999999

start with 1

increment by 1

cache 20'

Warning:Object already exists

-----------------------------------------------------------------------

Verify the Installation

To verify that you have successfully installed the Oracle Financial Services Analytical Applications Reconciliation Framework Pack, perform the following steps:

1.     Login in to the atomic schema.

2.     Verify all the database objects such as view, procedure, and functions have been compiled without any compilation error.

3.     Deploy the war file and ensure the application screen appears.