Documentation Center

Creating an Oracle Experience Manager database manually

Create your Oracle Experience Manager database manually by running database scripts that create the database and its tables.

Procedure

  1. Access your SDL Tridion installation media.
  2. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion administrator (defaults to TRIDION_SYS):
    • CD_BROKER_CREATE_USER.sql
    The script creates a new user (schema owner).
  3. In the Database\Scripts\Oracle\Shared\71\ folder, run the following script as the newly created user (schema owner):
    • TCM_SYSTEM.sql
    The script creates a new user (schema owner).
  4. 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
  5. In the folder Database\Scripts\Oracle\Shared\71\, run the following script as the newly created user (schema owner):
    • GENERAL_SET_VERSION.sql
  6. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion administrator (defaults to TRIDION_SYS):
    • CD_FINALIZE_RIGHTS.sql
    The script removes rights that the new user no longer needs.
  7. In the folder Database\Scripts\Oracle\Shared\71\, run the following script as the SQL SDL Tridion administrator (defaults to TRIDION_SYS):
    • TCM_FINALIZE.sql

Results

You have created the Experience Manager database.

What to do next

When installing the Experience Manager Server Role, you configure the Experience Manager database in the Storage Layer configuration file.