Documentation Center

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.5 installation media.
  3. Navigate to Database\Scripts\Oracle\.
  4. Only if you are upgrading SDL Tridion 2013 SP1 HR1, run the following scripts:
    Relative path and filenameDescription
    Shared\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\81\TCM_SYSTEM.sqlCreates procedures, functions and SQL queries for specific actions.
    Shared\81\UGC_SET_VERSION.sqlSets the version of the database.
    Shared\81\TCM_FINALIZE.sqlCleans up old or temporarily created database objects. Run this script as an administrator.
    Shared\TCD_REVOKE.sqlRevokes privileges for upgrade. Run this script as an administrator.
  5. Regardless of which version you are upgrading from, always run the following scripts:
    Relative path and filenameDescription
    Shared\TCD_GRANT.sqlGrants privileges for upgrade. Run this script as an administrator.
    Shared\82\TCM_SYSTEM.sqlCreates procedures, functions and SQL queries for specific actions.
    Shared\82\UGC_SET_VERSION.sqlSets the version of the database.
    Shared\82\TCM_FINALIZE.sqlCleans up old or temporarily created database objects. Run this script as an administrator.
    Shared\83\TCM_SYSTEM.sqlCreates procedures, functions and SQL queries for specific actions.
    Shared\83\UGC_SET_VERSION.sqlSets the version of the database.
    Shared\83\TCM_FINALIZE.sqlCleans up old or temporarily created database objects. Run this script as an administrator.
    Shared\85\TCM_SYSTEM.sqlCreates procedures, functions and SQL queries for specific actions.
    Shared\85\UGC_SET_VERSION.sqlSets the version of the database.
    Upgrade\83_85\UGC_TABLES_UPDATE.sqlUpdate UGC tables
    Shared\85\TCM_FINALIZE.sqlCleans up old or temporarily created database objects. Run this script as an administrator.
    Shared\TCD_REVOKE.sql