6.5.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. Log in to the system as a non-root user.
2. Navigate to the OFS_PM_PACK/schema_creator/bin directory.
3. Execute the utility.

   For Example: ./osc.sh -s

   The OFS_PM_SCHEMA_OUTPUT.XML file is successfully generated. Do not modify this file.