When Oracle is down - connect_cdc_sqdata - Latest

Connect CDC (SQData) Troubleshooting

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Troubleshooting
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:16:52.503000
  1. If you try to start the Oracle capture agent when the source Oracle database instance is unavailable, you will receive a message similar to:
    $ sqdconf start /<SQDATA_VAR_DIR>/oracdc/oracdc.cab
    
    SQDC019E Oracle Error (1034):ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux-x86_64 Error: 2: No such file or directory
    SQDC020I sqdconf terminated with Return Code 8, Reason Code=0x7002840a (Unknown error 1034)
  2. Restart the capture agent once Oracle becomes available.