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

Oracle RAC URL does not correctly substitute node IP addresses

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 1.6.0.Beta2
    • None
    • oracle-connector
    • None

    Description

      For Oracle rac , we have a service name like (xxx.webex.com)  and 3 different ip addresses for nodes. from the document link below

      https://debezium.io/documentation/reference/connectors/oracle.html#oracle-property-rac-nodes

      we put the 3 ip address in the config , and got errors "Failed to resolve Oracle database version",
      looks like it does not take IP addresses but service name from the code https://github.com/debezium/debezium/blob/c4f5cbca6ceaae992de53748bb77b061d5336aab/debezium-connector-oracle/src/main/java/io/debezium/connector/oracle/logminer/LogMinerHelper.java#L356

      here is part of our config

      "name": "debezium-idbroker-connector-all-tables-avro-46",
    "config": {
        "connector.class" : "io.debezium.connector.oracle.OracleConnector",
        "tasks.max" : "1",
        "database.server.name" : "idstore",
        "database.hostname": "xxx.xxx.xxx.xxx",
        "database.port": "1701",
        "database.user" : "logminer",
        "database.password" : "xxxxxxxx",
        "database.dbname" : "xxxxxx.webex.com",
        "database.connection.adapter": "logminer", 
         "rac.nodes" : "xxx.xxx.xxx.xxx,xxx.xxx.xxx.xxx,xxx.xxx.xxx.xxx",

       

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem that impairs or prevents the functions of the product. DBZ-3321 Oracle connector RAC mode cannot be connected

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              shiawu John Wu (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: