Creating an OMS Oracle Database for the Admin User

Create an OMS Oracle database for the admin user by running the provided scripts.

Procedure

  1. Create the table space by modifying the file to assign proper table space name and location of the file including the .dbf extension in the file $AF_HOME/db/oracle/oms/CreateTableSpace.sql.
  2. Create the user and assign the table space by modifying the file $AF_HOME/db/oracle/oms/createOMSUser.sql and assign the proper username and password for every user and the table space to the user with proper quota size in the file.
  3. Connect to SQL PLUS as an OMS database user. Execute the following SQL files in order:
    1. Execute $AF_HOME/db/oracle/oms/OMS_AdminDatabase_DDL.sql passing the tablespacename as an input parameter.
      For example,
      • SQL> @$AF_HOME/db/oracle/oms/OMS_AdminDatabase_DDL.sql <<admintablespacename>>
    2. Execute $AF_HOME/db/oracle/oms/OMS_Admin_SeedData.sql.

      For example,

      • SQL> @$AF_HOME/db/oracle/oms/OMS_Admin_SeedData.sql