Return
-
Title
Compare/repair process fails with Data source name not found and no default driver specified between Oracle to Postgres -
Description
Compare/repair process fails with Data source name not found and no default driver specified between Oracle to Postgres.
-
Cause
ODBC entries were not configured at Source Oracle side which is causing the issue.
-
Resolution
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