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