使用ogg 实时同步oracle数据到pg ogg连接pg时候报错
错误信息:
GGSCI (rac1) 3> dblogin sourcedb oggtest userid ogg
Password:
2019-07-30 09:40:27 WARNING OGG-00552 Database operation failed: Couldn’t connect to oggtest. ODBC error: SQLSTATE IM002 native database error 0. [DataDirect][ODBC lib] Data source name not found and no default driver specified.
ERROR: Database operation failed: Couldn’t connect to oggtest. ODBC error: SQLSTATE IM002 native database error 0. [DataDirect][ODBC lib] Data source name not found and no default driver specifiedFailed to open data source oggtest for user ogg.
相关的资料也都查了,无法解决
export LD_LIBRARY_PATH=/opt/postgres/soft/lib:/opt/postgres/ogg/lib
export ODBCINI=/opt/postgres/ogg/odbc.ini
想知道这块怎么设置,网上资料太少了