JR63795: CDC DOES NOT UPDATE SYSTEM TABLE STRUCTURE IN METADATA DURING ORACLE DATABASE UPGRADE

APAR status

• Closed as program error.

Error description

• Based on the assumption that the structures of Oracle system
  table does not change, CDC metadata were not updated reflecting
  those changes.
  

Local fix

• After the upgrade, 1) create a new instance and importing the
  subs affected.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are using IDR             *
  * 11.4.0.4-5599 or older for Oracle, and the Oracle database   *
  * was upgraded.                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Following an Oracle database upgrade, subscriptions might    *
  * encounter an error when trying to start mirroring.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5602 or newer for Oracle.            *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5602 or newer for Oracle resolves the
  issue.
  

Temporary fix

• For 11.4.0.4-5599 and older, the workaround was to upgrade the
  database, create a new CDC instance and import the
  affected subscriptions.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IS CDC ORACLE

• Fixed component ID

  5725E30OR

Applicable component levels