[Bug] [Oracle-CDC] Can not find catalog table with factoryId [Oracle]

[luzongzhu]

[Bug] [Oracle-CDC] Can not find catalog table with factoryId [Oracle]

[luzongzhu]

The new configuration after modifying the source code ，It is a table without primary key @hailin0

{
    "env" : {
        "job.name" : "1777977922728566785",
        "job.mode" : "STREAMING",
        "checkpoint.interval" : 5000,
        "execution.parallelism" : 1
    },
    "source" : [
        {
            "base-url" : "jdbc:oracle:thin:@//xxxxx:1531/TEST101",
            "password" : "oracle",
            "exactly_once" : true,
            "table-names" : [
                "CUX.CUX_CREDIT_FINANCE230207"
            ],
            "result_table_name" : "ST_GLOBAL_VIEW_NAME",
            "database-names" : [
                "TEST101"
            ],
            "schema-names" : [
                "CUX"
            ],
            "source.reader.close.timeout" : 120000,
            "plugin_name" : "Oracle-CDC",
            "table-names-config" : [
                {
                    "table" : "CUX.CUX_CREDIT_FINANCE230207",
                    "primaryKeys" : [
                        "FINANCE_ID"
                    ]
                }
            ],
            "username" : "logminer_user"
        }
    ],
    "transform" : [],
    "sink" : [
        {
            "password" : "root123456",
            "sink.enable-2pc" : "false",
            "fenodes" : "xxxxx:8060",
            "doris.config" : {
                "format" : "json",
                "read_json_by_line" : "true"
            },
            "table.identifier" : "cdc.CUX_CREDIT_FINANCE230207",
            "source_table_name" : "ST_GLOBAL_VIEW_NAME",
            "sink.enable-delete" : "true",
            "plugin_name" : "Doris",
            "sink.label-prefix" : "sink",
            "username" : "root"
        }
    ]
}

[luzongzhu]

Oracle version 12c，not have cdb

[Carl-Zhou-CN]

I think it is the table name configuration that is wrong, not the code

[Carl-Zhou-CN]

Would you mind referring to the configuration of oracle cdc e2e

[luzongzhu]

oracle-cdc jdbc url 需要使用 sid的方式配置

[lililill]

遇到同样的问题，找到解决方案了吗

[luzongzhu]

oracle-cdc jdbc url 需要使用 sid的方式配置

oracle-cdc jdbc url 需要使用 sid的方式配置