OGG cannot be used after the TIDB lower-case-table-names configuration item is removed

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TIDB lower-case-table-names配置项被删除后OGG无法使用

| username: heeewei

[TiDB Usage Environment] Production
[TiDB Version] v6.3.0
[Encountered Issue] The TIDB lower-case-table-names configuration item was removed after version 6.1, causing compatibility errors when integrating data into TiDB using OGG.
[Reproduction Path] Using Oracle GoldenGate 12.3.0.1.5 for MySQL-compatible DBs on Linux x86-64 to synchronize Oracle data to TiDB, unable to start.
[Issue Phenomenon and Impact]
OGG error: The Value ‘2’ of system variable lower_case_table_names is not supported, unable to synchronize data.

Is there any way to ensure this compatibility? Otherwise, data synchronization to TiDB via OGG will not be possible.

2
| username: WalterWj | Original post link

Yes, there is in version 6.2.0.

3
| username: heeewei | Original post link

There is only a default value, and it cannot be configured through the configuration file. In versions prior to 6.1, it could be configured to 1, but TiDB actually used 2, making OGG compatible. Now this value cannot be modified, so using OGG to integrate Oracle data into TiDB cannot run.

4
| username: WalterWj | Original post link

Upgrade the OGG version, the new version no longer validates this parameter.

5
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.