Topics:
· Configure the OFS_DM_PACK.xml File
· Configure the Schema Creator Utility
· Execute the Schema Creator Utility
· Configure the OFSAAI_InstallConfig.xml File
· Install the OFS Analytical Applications Reconciliation Framework Pack
· Apply Post-installation Mandatory Patches
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 |
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
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. |
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:
· Configure Schema Creator Utility for RDBMS Installation
· Configuring the Schema Creator Utility for Hive Schema
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.
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
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
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. 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. |
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>
----------------------------------------------------------------------------
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 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
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> |
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
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.
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.
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.
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.
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.
Interaction Variable Name |
Significance and Expected Value |
---|---|
<Layer name="GENERAL"> |
|
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" |
|
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" |
|
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" |
|
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" |
|
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" |
|
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" |
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) |
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) |
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) |
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) |
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) |
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) |
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) |
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) |
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) |
Identifies the user who has RWX permissions on the directory identified under the APP_FTPSHARE_PATH parameter. |
OFSAAI_SFTP_ PRIVATE_KEY (Optional) |
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) |
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) |
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) |
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) |
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) |
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) |
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) |
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. |
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.
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
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
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.
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.
The following table provides information about the mandatory patches you must apply after installing the OFSAA Reconciliation Framework Pack.
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. |
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
-----------------------------------------------------------------------
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.