Installing an Oracle State Store database manually

Create your State Store database for Oracle manually by running the database scripts provided.

Procedure

  1. Access your SDL Tridion Sites installation media.
  2. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion Sites administrator (defaults to TRIDION_SYS):
    • DP_STATE_CREATE_USER.sql
    The script creates a new user (schema owner), called StateStoreUser by default. To change this, edit the script to use a different name, and all scripts mentioned below as well, to reflect the new name.
  3. In the Database\Scripts\Oracle\Shared\110\ folder, run the script TCM_SYSTEM.sql.
  4. In the Database\Scripts\Oracle\Create\ folder, run the following scripts:
    • DP_STATE_TABLES.sql
    • DP_STATE_CONSTRAINTS.sql
    • DP_STATE_INDEXES.sql
  5. In the Database\Scripts\Oracle\Shared\110\ folder, run the following script:
    • DP_STATE_SET_VERSION.sql
  6. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion Sites administrator (defaults to TRIDION_SYS):
    • DP_STATE_FINALIZE_RIGHTS.sql
  7. In the Database\Scripts\Oracle\Shared\110\ folder, run the following script as the SQL SDL Tridion Sites administrator (defaults to TRIDION_SYS):
    • TCM_FINALIZE.sql

Results

You have created the State Store.

What to do next

When installing the combined Content Deployer Role, Content Deployer endpoint Role or Content Deployer worker Role, you configure the State Store in the Storage Layer configuration file.