Creating an OCS Oracle Database
- Procedure
- Create a table space and run the following script:
$OM_HOME/db/oracle/ocs/OCS_SCEMA_DDL.sql
. - 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
. - 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.
- Connect to SQL PLUS as an OCS database user. Run the following SQL files in order:
- 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>>
- Run