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
- Back up your database.
- Access your Tridion Docs 14 installation media.
- 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
- 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
- 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
- Run the following SQL script as an administrator in order to revoke the privileges previously granted: \Database\Scripts\Oracle\Shared\TCD_REVOKE.sql