Execute the Schema Creator Utility in Online Mode

Execute the Schema Creator utility in the online mode.

In 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 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 Online mode, it is mandatory to execute the schema creator utility with -s option.

To execute the utility with -s option in online mode:

1. Edit the file OFS_AAAI_PACK/schema_creator/conf/OFS_<APP PACK>_SCHEMA_IN.xml in a text editor. See Configure OFS_<App Pack>_SCHEMA_IN.xml for values to modify in the XML file.
2. Execute the utility with -s option. For Example: ./osc.sh -s

   Figure 7-7 Schema Creation in Online Mode

   
   

   

   
   

   Figure 7-8 Schema Creation in Online Mode

   
   

   

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

   Figure 7-9 Schema Creation in Online Mode – DDL Execution

   
   

   

   
   
5. 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).
6. Enter Y to proceed.

   Figure 7-10 Schema Creation in Online Mode – Infodom Confirmation

   
   

   

   
   
7. After Schema creation is successful, proceed to configure the OFSAAI_InstallConfig.xml file.

   Figure 7-11 Schema Creation in Online Mode –Successful

   
   

   

   
   

   Figure 7-12 Schema Creation in Online Mode –Successful

   
   

   

   
   

   As a result of this task the OFS_<APP_PACK>_SCHEMA_OUTPUT.XML file is generated. Do not modify this file.