Upgrading the UGC Oracle database manually

After you have upgraded your database server to a supported version, run a number of SQL scripts to upgrade your UGC Oracle database. Run these scripts for each database you are upgrading.

Procedure

  1. Back up your database.
  2. Access your SDL Web 8 installation media.
  3. Navigate to Database\Scripts\Oracle\.
  4. Only if you are upgrading from SDL Tridion 2011 SP1, run the following scripts:
    Relative path and filenameDescription
    Shared\70\TCD_GRANT.sqlGrants privileges for upgrade. Run this script as an administrator.
    Shared\70\TCM_SYSTEM.sqlCreates procedures, functions and SQL queries for specific actions.
    Shared\70\UGC_SET_VERSION.sqlSets the version of the database.
    Shared\70\TCM_FINALIZE.sqlCleans up old or temporarily created database objects. Run this script as an administrator.
    Shared\70\TCD_REVOKE.sqlRevokes privileges for upgrade. Run this script as an administrator.
  5. If you are upgrading from SDL Tridion 2011 SP1 or from SDL Tridion 2013, run the following scripts:
    Relative path and filenameDescription
    Shared\71\TCD_GRANT.sqlGrants privileges for upgrade. Run this script as an administrator.
    Shared\71\TCM_SYSTEM.sqlCreates procedures, functions and SQL queries for specific actions.
    Shared\71\UGC_SET_VERSION.sqlSets the version of the database.
    Shared\71\TCM_FINALIZE.sqlCleans up old or temporarily created database objects. Run this script as an administrator.
    Shared\71\TCD_REVOKE.sqlRevokes privileges for upgrade. Run this script as an administrator.
  6. No matter which SDL Tridion version you are upgrading from, always run the following scripts:
    Relative path and filenameDescription
    Shared\80\TCD_GRANT.sqlGrants privileges for upgrade. Run this script as an administrator.
    Shared\80\TCM_SYSTEM.sqlCreates procedures, functions and SQL queries for specific actions.
    Shared\80\UGC_SET_VERSION.sqlSets the version of the database.
    Shared\80\TCM_FINALIZE.sqlCleans up old or temporarily created database objects. Run this script as an administrator.
    Shared\80\TCD_REVOKE.sqlRevokes privileges for upgrade. Run this script as an administrator.