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