Engines not connecting - connect_cdc_sqdata - 4.1

The most common reason for an Engine not connecting is either an incorrect parm value in the connection url cdc://[<host_name_or_address>[:<port_number>]]/<agent_name>/<engine_name> or the Engine's public key missing in the Capture Controller's authorized key list.

A more subtle cause can be the re-creation of a capture configuration .cab file. While not a frequent occurrence it is often the easiest way to add a new target Engine subscription when a large number of source tables are involved.

SQDF801I Configuration name : oradc1
      SQDF802I Configuration key : cab_C69D5E516724D2EA
      SQDF832I Store File Type : FILE
      SQDF836I Filename : /opt/app/sqdata/oracdc1/data/cab_C69D5E516724D2EA.1

They are something like a socket the sqdaemon keeps in memory until recycled. That can be accomplished by using the sqdmon reload command or by terminating and restarting the sqdaemon process.

Other than that, the only time the sqdaemon needs to be recycled would be if any of the references in the sqdagents.cfg file were modified or if the alias name was changed in the <capture>_store.cab file. Simply adding a new table or target Engine subscription to a capture.cab would not matter after the change is applied and capture restarted.