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
- Back up your database.
- Access your SDL Web 8 installation media.
- Navigate to Database\Scripts\Oracle\.
- Only if you are upgrading from SDL Tridion 2011 SP1, run the following scripts:
Relative path and filename Description Shared\70\TCD_GRANT.sql Grants privileges for upgrade. Run this script as an administrator. Shared\70\TCM_SYSTEM.sql Creates procedures, functions and SQL queries for specific actions. Shared\70\UGC_SET_VERSION.sql Sets the version of the database. Shared\70\TCM_FINALIZE.sql Cleans up old or temporarily created database objects. Run this script as an administrator. Shared\70\TCD_REVOKE.sql Revokes privileges for upgrade. Run this script as an administrator. - If you are upgrading from SDL Tridion 2011 SP1 or from SDL Tridion 2013, run the following scripts:
Relative path and filename Description Shared\71\TCD_GRANT.sql Grants privileges for upgrade. Run this script as an administrator. Shared\71\TCM_SYSTEM.sql Creates procedures, functions and SQL queries for specific actions. Shared\71\UGC_SET_VERSION.sql Sets the version of the database. Shared\71\TCM_FINALIZE.sql Cleans up old or temporarily created database objects. Run this script as an administrator. Shared\71\TCD_REVOKE.sql Revokes privileges for upgrade. Run this script as an administrator. - No matter which SDL Tridion version you are upgrading from, always run the following scripts:
Relative path and filename Description Shared\80\TCD_GRANT.sql Grants privileges for upgrade. Run this script as an administrator. Shared\80\TCM_SYSTEM.sql Creates procedures, functions and SQL queries for specific actions. Shared\80\UGC_SET_VERSION.sql Sets the version of the database. Shared\80\TCM_FINALIZE.sql Cleans up old or temporarily created database objects. Run this script as an administrator. Shared\80\TCD_REVOKE.sql Revokes privileges for upgrade. Run this script as an administrator.