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

    Details

    • Steps to Reproduce:
      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.  

      Description

      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)

        Attachments

          Activity

            People

            Assignee:
            ccranfor Chris Cranford
            Reporter:
            tschaper69 Thomas Schaper (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: