Creating an OCS Oracle Database

    Procedure
  1. Create a table space and run the following script: $OM_HOME/db/oracle/ocs/OCS_SCEMA_DDL.sql.
  2. Modify the file to assign the proper table space name and location of the file including the .dbf extension in the file $OM_HOME/db/oracle/oms/CreateTableSpace.sql.
  3. Create the user and assign the table space by modifying the file $OM_HOME/db/oracle/oms/createOMSUser.sql. Assign the proper user name and password for every user and the tablespace to the user with the proper quota size in the file.
  4. Connect to SQL PLUS as an OCS database user. Run the following SQL files in order:
    1. Run $OM_HOME/db/oracle/oms/OCS_SCHEMA_DDL.sql passing the tablespace name as an input parameter.

      For example,

      SQL> @$OM_HOME/db/oracle/oms/OCS_SCHEMA_DDL.sql <<tablespacename>>