Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version 6

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. The data in DATABASECHANGELOG and DATABASECHANGELOGLOCK tables and their data must be copied from the source database to the target RefDb.

    1. For multi-schema projects, the schema for these tables can be found by checking the datical.project file for the trackingSchema attribute on row 2.

    2. For single schema projects the tables will be present in the managed schema.

  2. Grants: Ensure any necessary grants are added to the RefDb.

  3. ORACLE: In the event of server outage or unexpected shutdown which requires a restore of the RefDb, check that no orphan datapump jobs remain on the server.

    1. https://www.oracle-scripts.net/cleanup-orphaned-datapump-jobs

    2. Orphan jobs may result in the following error during the restore operation of a Packager job:

      1. Code Block
        ORA-06512: at "SYS.DBMS_DATAPUMP", line 7143
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4932
ORA-06512: at "SYS.DBMS_DATAPUMP", line 7137

...