During oracle cdc synchronization, the databasename and sid of the oracle source database are different, resulting in the inability to connect to the database.

[QuintinLuke]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

oracle cdc 同步时，oracle源库的databasename和sid是不一样的,导致无法连接数据库

What you expected to happen

oracle cdc 同步时，oracle源库的databasename和sid是不一样的,导致无法连接数据库

How to reproduce

oracle cdc 同步时，oracle源库的databasename和sid是不一样的,导致无法连接数据库

Anything else

oracle cdc 同步时，oracle源库的databasename和sid是不一样的,导致无法连接数据库

Version

dev

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Hello @QuintinLuke, this issue is about CDC/CDCSOURCE, so I assign it to @aiwenmo. If you have any questions, you can comment and reply.

你好 @QuintinLuke, 这个 issue 是关于 CDC/CDCSOURCE 的，所以我把它分配给了 @aiwenmo。如有任何问题，可以评论回复。

[Zzm0809]

描述过于简单请提供复现步骤

[QuintinLuke]

描述过于简单请提供复现步骤

我看dinky的源代码是这样的，采用的是sid的模式（冒号拼接），但是我的oracle的databasename是helowin,sid是orcl,所以冒号拼接会报：listener does not currently know if sid given in connect descripter 错误。

[QuintinLuke]

描述过于简单请提供复现步骤

EXECUTE CDCSOURCE cdc_oracle WITH (
'connector' = 'oracle-cdc',
'hostname' = '127.0.0.1',
'port' = '1521',
'username' = 'root',
'password' = '123456',
'database-name' = 'ORCL', -- Service Name
'checkpoint' = '3000',
'scan.startup.mode' = 'initial',
'parallelism' = '1',
'table-name' = 'TEST..*',
'url' = 'jdbc:oracle:thin:@//127.0.0.1:1521/ORCL' -- 强制使用 Service Name 连接
);类似这样url并不生效

[Zzm0809]

描述过于简单请提供复现步骤

EXECUTE CDCSOURCE cdc_oracle WITH ( 'connector' = 'oracle-cdc', 'hostname' = '127.0.0.1', 'port' = '1521', 'username' = 'root', 'password' = '123456', 'database-name' = 'ORCL', -- Service Name 'checkpoint' = '3000', 'scan.startup.mode' = 'initial', 'parallelism' = '1', 'table-name' = 'TEST..*', 'url' = 'jdbc:oracle:thin:@//127.0.0.1:1521/ORCL' -- 强制使用 Service Name 连接 );类似这样url并不生效

以上存在两个问题:

1. table-name 的值 应该是 TEST\..*
2. 没有 sink

如有疑问请提供完整的 不要提供一部分