Documentation Center

Upgrading your Content Delivery Oracle databases manually

After you have upgraded your database server to a supported version, run a number of SQL scripts to upgrade your Content Delivery Oracle databases (Content Data Store and Experience Manager database, if using). Run these scripts for each database you are upgrading.

Procedure

  1. Back up your database.
  2. Access your SDL Web 8.5 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. Only if you are upgrading from SDL Tridion 2013 SP1 HR1, execute the following SQL scripts:
    \Database\Scripts\Oracle\Shared\80\TCM_SYSTEM.sql
    \Database\Scripts\Oracle\Upgrade\71_80\TCD_TABLES_UPDATE.sql
    \Database\Scripts\Oracle\Shared\80\GENERAL_SET_VERSION.sql
  5. If you are upgrading from SDL Tridion 2013 SP1 HR1 or SDL Web 8, execute the following SQL scripts:
    \Database\Scripts\Oracle\Shared\81\TCM_SYSTEM.sql
    \Database\Scripts\Oracle\Upgrade\80_81\TCD_TABLES_UPDATE.sql
    \Database\Scripts\Oracle\Shared\81\GENERAL_SET_VERSION.sql
    \Database\Scripts\Oracle\Shared\82\TCM_SYSTEM.sql
    \Database\Scripts\Oracle\Shared\82\GENERAL_SET_VERSION.sql
    \Database\Scripts\Oracle\Shared\83\TCM_SYSTEM.sql
    \Database\Scripts\Oracle\Upgrade\82_83\TCD_TABLES_UPDATE.sql
    \Database\Scripts\Oracle\Shared\83\GENERAL_SET_VERSION.sql
    \Database\Scripts\Oracle\Shared\85\TCM_SYSTEM.sql
    \Database\Scripts\Oracle\Upgrade\83_85\TCD_TABLES_UPDATE.sql
    \Database\Scripts\Oracle\Shared\85\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