Creating an OCS Oracle Database

Procedure

  1. Create a table space and execute the following script: $OM_HOME/db/oracle/ocs/OCS_SCEMA_DDL.sql .
  2. Modify the file to assign 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. Aassign the proper username and password for every user and the tablespace to the user with proper quota size in the file.
  4. Connect to SQL PLUS as an OCS database user. Execute the following SQL files in order:
    1. Execute $OM_HOME/db/oracle/oms/OCS_SCHEMA_DDL.sql passing the tablespacename as an input parameter.

      For example,

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