Upgrading your main Content Delivery Oracle databases manually

Run a number of SQL scripts to upgrade your Content Delivery Oracle databases. Run these scripts for each database you are upgrading: the Content Data Store and the Discovery Service database.

Procedure

  1. Back up your database.
  2. Access your Tridion Docs 14 installation media.
  3. Run the following SQL script as an administrator in order to grant the proper privileges to run the actual upgrade scripts: \Database\Scripts\Oracle\Shared\TCD_GRANT.sql
  4. E xecute the following SQL scripts:
    
    \Database\Scripts\Oracle\Shared\101\TCM_SYSTEM.sql
    \Database\Scripts\Oracle\Upgrade\100_101\TCD_UPDATE_TABLES.sql
    \Database\Scripts\Oracle\Shared\101\GENERAL_SET_VERSION.sql
    \Database\Scripts\Oracle\Shared\1011\GENERAL_SET_VERSION.sql
    \Database\Scripts\Oracle\Shared\110\TCM_SYSTEM.sql
    \Database\Scripts\Oracle\Upgrade\1011_1100\TCD_UPDATE_TABLES.sql
    \Database\Scripts\Oracle\Upgrade\1011_1100\TCD_UPDATE_CONFIGURATION_VALUES.sql
    \Database\Scripts\Oracle\Shared\110\GENERAL_SET_VERSION.sql
  5. Regardless of the version from which you are upgrading, execute the following upgrade scripts:
    \Database\Scripts\Oracle\Shared\CREATE_FK_INDEXES.sql
    \Database\Scripts\Oracle\Shared\111\GENERAL_SET_VERSION.sql
  6. Run the following SQL script as an administrator in order to revoke the privileges previously granted: \Database\Scripts\Oracle\Shared\TCD_REVOKE.sql