Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-8149

When stopping the Oracle rac node the Debezium server throws an expections - ORA-12514: Cannot connect to database and retries

XMLWordPrintable

    • Important

       

      Bug report

      We are testing the scenario of stopping one of the nodes of the Oracle RAC nodes. The Debezium Server throws an exception - "ORA-12514: Cannot connect to database" and keep retrying -  "Retry 1 of unlimited retries will be attempted"

      What Debezium connector do you use and what version?

      2.71.Final Oracle connector

      What is the captured database version and mode of deployment?

      Oracle RAC 19c

      What behavior do you expect?

      I would expect the Debezium not to through the exception and to keep streaming 

      What behavior do you see?

      :Caused by: oracle.net.ns.NetException: ORA-12514: Cannot connect to database. Service uatrpbrg is not registered with the listener at host 10.0.69.11 port 2388. (CONNECTION_ID=szHFJx72QAmLzBbTevZUpA==)
      debezium_logs_UAT-1408-aab:    admin.listeners = null
      debezium_logs_UAT-1408-aab:    listeners = http://:8083
      debezium_logs_UAT-1408-aab:    rest.advertised.listener = null
      debezium_logs_UAT-1408-aab:Caused by: java.sql.SQLRecoverableException: ORA-12514: Cannot connect to database. Service uatrpbrg is not registered with the listener at host 10.0.69.11 port 2388. (CONNECTION_ID=EJEi1k58QYiC9v0sV007mg==)

      Do you have the connector logs, ideally from start till finish?

      Yes, Will attach the log file to the bug report

       

              ccranfor@redhat.com Chris Cranford
              gali.levin gal levin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: