6.4.3 Execute the Schema Creator Utility in TCPS Mode

If you intend to run the OFS Hedge Management and IFRS Valuations Installer in TCPS mode, it is mandatory to execute the schema creator utility with -s option and in online mode.

Prerequisite:

Configure the Oracle Wallet with trusted certificates between the DB Server with TCPS configured and the DBClient to enable communication through the SSL protocol.

Note:

You can also use Oracle Wallet to support OFSAA for storing Config and Atomic Schema credentials. To add OFSAA Config and Atomic Schema credentials to Oracle Wallet, see the OFS Analytical Applications Infrastructure Administration Guide.

For example, all the database utilities such as sqlplus, tnsping, and sqlldr must work between the Client and the Server.

To execute the utility, follow these steps:

1. Edit the file OFS_HM _PACK/schema_creator/conf/OFS_HM _SCHEMA_IN.xml in the text editor. See the tables in the Configure the OFS_HM _SCHEMA_IN.xml File section for values to modify in the XML file.
2. Execute the utility with -s option.

   ./osc.sh-s TCPS <WALLET_HOME>

   For example: $./osc.sh -s TCPS /scratch/oraofss/wallet

3. The following message is displayed: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.
5. The following message is displayed:

   You have chosen to install this application pack on “<ATOMIC_SCHEMA_NAME>” ATOMIC schema. Do you wish to proceed? (Y/y or N/n).

6. Enter Y to proceed.

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

   After Schema creation is successful, proceed toConfigure the OFSAAI_InstallConfig.xml File section.