Hi,
I'have seen previous posts but I couldn't find the solution.
I got below error;
SQL> create database link PG_LINK connect to username identified by **** using 'PG_LINK';
Database link created.
SQL> select count(1) from "eventlogentry"@PG_LINK;
select count(1) from "eventlogentry"@PG_LINK
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
connction string lacks some options {08001,NativeErr = 202}
ORA-02063: preceding 2 lines from PG_LINK
SQL>
isql -v PG_LINK
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
uname -a
Linux hostname 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
My configuration files are;
cat /etc/odbcinst.ini
# Example driver definitions
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib64/psqlodbc.so
Setup = /usr/lib64/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1
cat /home/oracle/.odbc.ini
[Data Sources]
PG_LINK = PostgreSQL
[PG_LINK]
Debug = 1
CommLog = 1
ReadOnly = no
Driver = /usr/lib64/psqlodbc.so
Servername = x.x.x.x
FetchBufferSize = 99
Username = username
Password = password
Port = 5492
Database = db_name
Trace = 1
TraceFile = /tmp/pg_link.trc
[Default]
Driver = /usr/lib64/liboplodbcS.so.1
cat $ORACLE_HOME/hs/admin/initPG_LINK.ora
HS_FDS_CONNECT_INFO=PG_LINK
HS_FDS_TRACE_LEVEL=255
HS_FDS_SHAREABLE_NAME=/usr/lib64/psqlodbc.so
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
set ODBCINI=/home/oracle/.odbc.ini
rpm -qa | grep unixODBC
unixODBC-2.2.14-11.el6.x86_64
unixODBC-2.2.14-11.el6.i686
unixODBC-devel-2.2.14-11.el6.x86_64
unixODBC-devel-2.2.14-11.el6.i686
yum list unixodbc
Loaded plugins: product-id, refresh-packagekit, security, subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Installed Packages
unixODBC.i686 2.2.14-11.el6 @yumrepo
unixODBC.x86_64
I can upload strace output and odbc trace files.