Creating the exceptions database schema for an Oracle database

You must create the exceptions database schema that stores exception data.

Procedure

  1. Ensure that you are logged in as a user that can run the sqlplus command and that has access to the scripts.
  2. If the database is remote from the services tier, copy the scripts to the database server host.
  3. To create the table spaces, enter the following command:
    sqlplus -L DBAUser/DBAUserPassword@SID @esdb_tablespace_creation.sql
    
    where
    • DBAUser is the database administrator's user name
    • DBAUserPassword is the database administrator's password
    • SID is the Oracle system ID
  4. To configure user permissions, enter the following command:
    sqlplus -L DBAUser/DBAUserPassword@SID @esdb_user_config.sql ESDBUserpassword
    where
    • DBAUser is the database administrator's user name
    • DBAUserPassword is the database administrator's password
    • SID is the Oracle system ID
    • ESDBUserpassword is the exceptions database user password
  5. To create the Exceptions database tables, enter the following command:
    sqlplus -L DBAUser/DBAUserPassword@SID @esdb_table_creation.sql
    where
    • DBAUser is the database administrator's user name
    • DBAUserPassword is the database administrator's password
    • SID is the Oracle system ID
  6. Test the connection with the following command:

    On Linux® or Unix:

    RepositoryAdmin.sh -tc -rn ESDB -cn ESDB
    On Windows:
    RepositoryAdmin.bat -tc -rn ESDB -cn ESDB

    If the connection fails, verify that you ran the database creation scripts correctly. Repeat the database creation process if necessary.