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

Oracle connector causes ORA-65090 when connecting to an Oracle instance running in non-CDB mode

XMLWordPrintable

    • False
    • False
    • Undefined
    • Hide

      Reproducing the error is very easy. The error occurs as soon as Debezium tries to connect to an Oracle instance running in non-CDB mode.

       

      Show
      Reproducing the error is very easy. The error occurs as soon as Debezium tries to connect to an Oracle instance running in non-CDB mode.  

      We are currently evaluating Debezium as a tool for generating CDC events from INSERTs, UPDATEs and DELETEs occurring in our Oracle (version 12..2.0.1) instances.

      Our Oracles instances run in the tradionational (non-CDB) mode. According to the Debezium documentation this set-up has not been tested yet but should work nevertheless. Actually it does not. Following error occurrs:

      2020-11-27 10:50:51,605 ERROR || Failed to initialize snapshot context. [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
      java.lang.RuntimeException: java.sql.SQLException: ORA-65090: operation only allowed in a container database

      at io.debezium.connector.oracle.OracleConnection.setSessionToPdb(OracleConnection.java:62)

              ccranfor@redhat.com Chris Cranford
              tschaper69 Thomas Schaper (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: