Documentation Center

Upgrading your Oracle databases manually

After you have upgraded your database server to a supported version, run a number of SQL scripts to upgrade your Oracle databases (Content Data Store and Experience Manager database, if using). Run these scripts for each database your are upgrading.

Backing up your existing database

Make a back-up of your database before upgrading.

Upgrading your SDL Tridion 2009 SP1 Oracle database manually

If you are upgrading from version 2009 SP1 of SDL Tridion, access your SDL Tridion 2013 SP1 installation media, navigate to Database\Scripts\Oracle\, and run the following database scripts located in the relative paths provided, in the order given:

  1. Shared\60\TCD_GRANT.sql (run this script as an administrator)
  2. Shared\60\TCM_SYSTEM.sql
  3. Shared\60\GENERAL_SET_VERSION.sql
  4. Upgrade\54SP1_60\TCD_ITEMMETA.sql
  5. Upgrade\54SP1_60\TCD_TAXONOMIES.sql
  6. Upgrade\54SP1_60\TCD_METADATA.sql
  7. Upgrade\54SP1_60\TCD_WAICONSTRAINTS.sql
  8. Upgrade\54SP1_60\TCD_TRACKING.sql
  9. Shared\60\CD_TRACKING_PROCEDURES.sql
  10. Upgrade\54SP1_60\TCD_CUSTOMMETA.sql
  11. Upgrade\54SP1_60\TCD_INDEXES.sql
  12. Shared\60\TCD_REVOKE.sql (run this script as an administrator)
  13. Shared\61\TCD_GRANT.sql (run this script as an administrator)
  14. Shared\61\TCM_SYSTEM.sql
  15. Shared\61\GENERAL_SET_VERSION.sql
  16. Upgrade\60_61\TCD_SEQUENCE_ITC.sql
  17. Upgrade\60_61\TCD_TRACKING.sql
  18. Upgrade\60_61\TCD_COMPONENT_PRES_META_DATA.sql
  19. Upgrade\60_61\TCD_BINARYVARIANTS.sql
  20. Upgrade\60_61\TCD_PREVIEW.sql
  21. Shared\61\CD_TRACKING_PROCEDURES.sql
  22. Shared\61\TCD_REVOKE.sql (run this script as an administrator)
  23. Shared\71\TCD_GRANT.sql (run this script as an administrator)
  24. Shared\71\TCM_SYSTEM.sql
  25. Shared\71\GENERAL_SET_VERSION.sql
  26. Upgrade\61_70\TCD_UPDATE_TABLES.sql
  27. Upgrade\61_70\TCD_UNDO.sql
  28. Shared\71\TCD_REVOKE.sql (run this script as an administrator)

Upgrading your SDL Tridion 2011 SP1 Oracle database manually

If you are upgrading from version 2011 SP1 of SDL Tridion, access your SDL Tridion 2013 SP1 installation media, navigate to Database\Scripts\Oracle\, and run the following database scripts located in the relative paths provided, in the order given:

  1. Shared\71\TCD_GRANT.sql (run this script as an administrator)
  2. Shared\71\TCM_SYSTEM.sql
  3. Shared\71\GENERAL_SET_VERSION.sql
  4. Upgrade\61_70\TCD_UPDATE_TABLES.sql
  5. Upgrade\61_70\TCD_UNDO.sql
  6. Shared\71\TCD_REVOKE.sql (run this script as an administrator)