返回
-
标题
Compare/repair process fails with Data source name not found and no default driver specified between Oracle to Postgres -
说明
Compare/repair process fails with Data source name not found and no default driver specified between Oracle to Postgres.
-
原因
ODBC entries were not configured at Source Oracle side which is causing the issue.
-
解决办法
We need to add below entries in the source odbc.ini file which is located in $SP_SYS_VARDIR/odbc
Example :
[pdbora19c]
Driver = /Oracle/app/oracle/product/19.0.0/dbhome_1/lib/libsqora.so.19.1
database = pdbora19c
ServerName = pdbora19c
UserID = oracle
Password = oracle