JR64749: CDC FOR ORACLE (TRIGGER, XSTREAM) CAN'T CREATE INSTANCE IF FILE DOESN'T EXIST UNDER $ORACLE_HOME/NETWORK/ADMIN

APAR status

• Closed as program error.

Error description

• CDC for Oracle (Trigger, XStream) can't create instance if
  tnsnames.ora
  file doesn't exist under $ORACLE_HOME/network/admin directory
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are creating a CDC Oracle *
  * Trigger or Oracle XStream datastore instance using IDR       *
  * 11.4.0.4-5627 or older for Oracle Trigger or Oracle XStream. *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Creating an instance failed if the tnsnames file was not in  *
  * $ORACLE_HOME/network/admin, despite the user configuring the *
  * correct location.                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.4-5629 or newer for Oracle Trigger or  *
  * Oracle XStream.                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5629 or newer for Oracle Trigger or
  Oracle XStream resolves the issue.
  

Temporary fix

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