Creating the exceptions database schema for an Oracle database
You must create the exceptions database schema that stores exception data.
Procedure
- Ensure that you are logged in as a user that can run the sqlplus command and that has access to the scripts.
- If the database is remote from the services tier, copy the scripts to the database server host.
- 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
- 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
- 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
- Test the connection with the following command:
On Linux® or Unix:
On Windows:RepositoryAdmin.sh -tc -rn ESDB -cn ESDB
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.