7.4.2 Execute the Schema Creator Utility in 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, follow these steps:

1. Edit the file OFS_LRS_PACK/schema_creator/conf/OFS_LRS_SCHEMA_IN.xml in a text editor. See Configure the OFS_LRS_SCHEMA_IN.xml File section for values to modify in the XML file.
2. Execute the utility with -s option. For Example: ./osc.sh -s
3. Make a TNS entry for the new users created. For details, see Add TNS entries in the TNSNAMES.ORA File.

   Figure 7-7 Schema Creation in Online Mode

   
   

   

   
   

   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-8 Schema Creation in Online Mode – DDL Execution

   
   

   

   
   

   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.

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

   
   

   

   
   
6. After Schema creation is successful, proceed to Configure the OFSAAI_InstallConfig.xml File.

   Figure 7-10 Schema Creation in Online Mode –Successful

   
   

   

   
   

   As a result of this task is the OFS_LRS_SCHEMA_OUTPUT.XML file is generated. Do not modify this file.