Creating an Oracle Discovery Service database manually
Create your Oracle Discovery Service database manually by running database scripts that create the database and its tables.
Procedure
- Access your SDL Tridion Sites installation media.
- In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion Sites administrator (defaults to
TRIDION_SYS):- CD_BROKER_CREATE_USER.sql
The script creates a new user (schema owner). - In the Database\Scripts\Oracle\Shared\ folder, run the following script as the newly created user (schema owner):
- TCM_SYSTEM.sql
The script creates a new user (schema owner). - In the Database\Scripts\Oracle\Create\ folder, run the following scripts as the newly created user (schema owner):
- CD_BROKER_TABLES.sql
- CD_BROKER_CONSTRAINTS.sql
- CD_BROKER_INDEXES.sql
- CD_WAI_TABLES.sql
- CD_WAI_SEQUENCES.sql
- CD_WAI_CONSTRAINTS.sql
- CD_WAI_INDEXES.sql
- In the folder Database\Scripts\Oracle\Shared\110\, run the following script as the newly created user (schema owner):
- GENERAL_SET_VERSION.sql
- In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion Sites administrator (defaults to
TRIDION_SYS):- CD_FINALIZE_RIGHTS.sql
The script removes rights that the new user no longer needs. - In the folder Database\Scripts\Oracle\Shared\, run the following script as the SQL SDL Tridion Sites administrator (defaults to
TRIDION_SYS):- TCM_FINALIZE.sql