Upgrading the Oracle Archiver database manually on a non-Windows machine

Before you upgrade your database, ensure that the current version of your database server is supported. Upgrade your Oracle Archiver database on a non-Windows machine by running one or more SQL scripts. If you prefer to do a manual upgrade of your Oracle Archiver database on a Windows machine, you can also perform this task. Later, when you upgrade the Archive Manager Core, you need to run an additional tool to update the timestamps in the database.

Procedure

  1. On your installation media, navigate to \Database\Scripts\Oracle\.
  2. Only if you are upgrading from Archive Manager 1.0, run the following SQL scripts:
    • Upgrade\10_10SP1\TAM_PREPARE_RIGHTS.sql (run this script as an administrator)
    • Shared\10SP1\TAM_SET_VERSION.sql (run this script as a schema owner)
    • Upgrade\10_10SP1\TAM_FINALIZE_RIGHTS.sql (run this script as an administrator)
  3. Only if you are upgrading from Archive Manager 1.0 or from Archive Manager 1.0 SP1, access the 10SP1_10SP2\ subfolder and run the following SQL scripts:
    • Upgrade\10SP1_10SP2\TAM_PREPARE_RIGHTS.sql (run this script as an administrator)
    • Upgrade\10SP1_10SP2\TAM_UPDATE_TABLES.sql(run this script as a schema owner)
    • Shared\10SP2\TAM_SET_VERSION.sql (run this script as a schema owner)
    • Upgrade\10SP1_10SP2\TAM_FINALIZE_RIGHTS.sql (run this script as an administrator)
  4. Always access the 10SP2_10SP3\ subfolder and run the following SQL scripts:
    • Upgrade\10SP2_10SP3\TAM_PREPARE_RIGHTS.sql (run this script as an administrator)
    • Upgrade\10SP2_10SP3\TAM_UPDATE_TABLES.sql (run this script as a schema owner)
    • Upgrade\10SP2_10SP3\TAM_UPDATE_CONSTRAINTS.sql(run this script as a schema owner)
    • Upgrade\10SP2_10SP3\TAM_UPDATE_INDEXES.sql (run this script as a schema owner)
    • Upgrade\10SP2_10SP3\TAM_UPDATE_SEQUENCES.sql (run this script as a schema owner)
    • Shared\10SP3\TAM_SET_VERSION.sql (run this script as a schema owner)
    • Upgrade\10SP2_10SP3\TAM_FINALIZE_RIGHTS.sql (run this script as an administrator)