OGG 微服务 for PostgreSQL报错

[小麦苗]

OGG 微服务 for PostgreSQL报错:

OGG (http://127.0.0.1:9000 deploy213) 2> dblogin useridalias PG1 DOMAIN OGGMA 2021-12-01T09:33:59Z ERROR OGG-08110 Login failed. Database operation failed: Couldn't connect to PGDSN1. ODBC error: SQLSTATE IM002⥾羷 native database error 0. [DataDirect][ODBC lib] Driver Manager Message file not found. Please check for the value of InstallDir in your odbc.ini.Failed to open data source PGDSN1 for user postgres 2021-12-01T09:33:59Z WARNING OGG-00552 Database operation failed: Couldn't connect to PGDSN1. ODBC error: SQLSTATE IM002⥾羷 native database error 0. [DataDirect][ODBC lib] Driver Manager Message file not found. Please check for the value of InstallDir in your odbc.ini. [oracle@lhrogg213mapg ~]$ cat /etc/odbc.ini [ODBC Data Sources] PGDSN1=DataDirect 13 PostgreSQL Wire Protocol PGDSN2=DataDirect 13 PostgreSQL Wire Protocol [ODBC] IANAAppCodePage=106 InstallDir=/ogg [PGDSN1] Driver=/ogg/lib/GGpsql25.so Description=DataDirect 13 PostgreSQL Wire Protocol Database=lhrdb HostName=172.72.6.20 PortNumber=5432 LogonID=postgres Password=lhr [PGDSN2] Driver=/ogg/lib/GGpsql25.so Description=DataDirect 13 PostgreSQL Wire Protocol Database=lhrdb HostName=172.72.6.21 PortNumber=5432 LogonID=postgres Password=lhr

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

OGG (http://127.0.0.1:9000 deploy213) 2> dblogin useridalias PG1 DOMAIN OGGMA   2021-12-01T09:33:59Z  ERROR   OGG-08110  Login failed. Database operation failed: Couldn't connect to PGDSN1. ODBC error: SQLSTATE IM002⥾羷 native database error 0. [DataDirect][ODBC lib] Driver Manager Message file not found. Please check for the value of InstallDir in your odbc.ini.Failed to open data source PGDSN1 for user postgres 2021-12-01T09:33:59Z  WARNING OGG-00552  Database operation failed: Couldn't connect to PGDSN1. ODBC error: SQLSTATE IM002⥾羷 native database error 0. [DataDirect][ODBC lib] Driver Manager Message file not found. Please check for the value of InstallDir in your odbc.ini.     [oracle@lhrogg213mapg ~]$ cat /etc/odbc.ini [ODBC Data Sources] PGDSN1=DataDirect 13 PostgreSQL Wire Protocol PGDSN2=DataDirect 13 PostgreSQL Wire Protocol   [ODBC] IANAAppCodePage=106 InstallDir=/ogg   [PGDSN1] Driver=/ogg/lib/GGpsql25.so Description=DataDirect 13 PostgreSQL Wire Protocol Database=lhrdb HostName=172.72.6.20 PortNumber=5432 LogonID=postgres Password=lhr   [PGDSN2] Driver=/ogg/lib/GGpsql25.so Description=DataDirect 13 PostgreSQL Wire Protocol Database=lhrdb HostName=172.72.6.21 PortNumber=5432 LogonID=postgres Password=lhr

[小麦苗]

已解决：重启OS大法！！！ 参考：https://www.dbaup.com/itxingyeyinanzazhengjiejuedafa.html

[小麦苗]

第二次又遇到了，重启不好使了，研究了一天，解决方法：

ln -sf /ogg213c/ogg_ma/odbc.ini /home/oracle/.odbc.ini

1 2	ln -sf /ogg213c/ogg_ma/odbc.ini  /home/oracle/.odbc.ini

MA应该默认读取的是.odbc.ini文件，坑货，也没有文档说明

[作者]

帖子