6.5.3.2 Execute the Schema Creator Utility

To execute the utility, follow these steps:

1. Edit the OFS_PAM_PACK/schema_creator/conf/OFS_PAM_SCHEMA_IN.xml file in a text editor. See the tables in Configure the OFS_PAM_SCHEMA_IN.xml File for the values that you must modify in the XML file.
2. Execute the utility with the -s option.

   ./osc.sh -s TCPS <WALLET_HOME>

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

   Figure 6-4 Schema Creation in the TCPS Mode

   
   

   

   
   

   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).

3. Enter Y to proceed.

   The following message is displayed:

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

   Figure 6-5 Schema Creation in the TCPS Mode – Install on Atomic Schema

   
   

   

   
   
4. Enter Y to proceed.
5. After Schema creation is successful, proceed to Configure the OFSAAI_InstallConfig.xml File.

   Figure 6-6 Schema Creation in the TCPS Mode

   
   

   

   
   
6. After the installation is completed, delete the ojdbc7.jar file from the web-INF folder which will be located in the deployed web-app/folder.

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