ORA-28545 config issue

From: Ray Stell <ray(dot)stell(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ORA-28545 config issue
Date: 2016-02-25 21:54:58
Message-ID: 56CF7832.7010902@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

followed this script to try to query postqresql from an oracle server:
https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/
and having some trouble.

oracle server: Database Patch Set Update : 11.2.0.4.160119
postgresql server: 9.4.6

oracle> rpm -qa | grep -i odbc
postgresql95-odbc-09.05.0100-1PGDG.rhel6.x86_64
oracle > rpm -ql postgresql95-odbc-09.05.0100-1PGDG.rhel6.x86_64
/usr/pgsql-9.5/lib/psqlodbc.so
/usr/pgsql-9.5/lib/psqlodbcw.so
/usr/share/doc/postgresql95-odbc-09.05.0100
/usr/share/doc/postgresql95-odbc-09.05.0100/license.txt
/usr/share/doc/postgresql95-odbc-09.05.0100/readme.txt

--
oracle> cat .odbc.ini
[ODBC Data Sources]
PG_LINK = PostgreSQL
[PG_LINK]
Debug = 1
CommLog = 1
ReadOnly = no
Driver = /usr/pgsql-9.5/lib/psqlodbc.so
Servername = pghost
FetchBufferSize = 99
Username = pguser
Password = pgpass
Port = 5432
Database = mydb
[Default]
Driver = /usr/lib64/liboplodbcS.so

--
listener.ora
-------------
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(SID_NAME=PG_LINK)
(ORACLE_HOME=/apps/database/oracle/product/11.2.0)
(PROGRAM=dg4odbc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orahost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = /apps/database/oracle/product

--

oracle> cat initPG_LINK.ora
HS_FDS_CONNECT_INFO = PG_LINK
HS_FDS_TRACE_LEVEL = 0
HS_FDS_SHAREABLE_NAME=/usr/pgsql-9.5/lib/psqlodbc.so
set ODBCINI=/apps/database/oracle/.odbc.ini

--

tnsnames:
----------
PG_LINK =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=pghost)(PORT=5432))
(CONNECT_DATA=(SID=PG_LINK))
(HS=OK)
)

--

listener status:
-----------------
Services Summary...
Service "PG_LINK" has 1 instance(s).
Instance "PG_LINK", status UNKNOWN, has 1 handler(s) for this service...

(asks himself why the oracle listener needs a service...it's not
answering requests??? clueless me)

--

created db link in ora:
-----------------------
create database link PG_LINK connect to "pguser" identified by "pgpass"
using 'PG_LINK';

SQL> select count(*) from mytable(at)PG_LINK;
select count(*) from circuit_tracking_event(at)PG_LINK
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from PG_LINK

any clue will do....

Browse pgsql-odbc by date

  From Date Subject
Next Message Ray Stell 2016-02-25 21:56:18 ORA-28545 config issue
Previous Message Venkatesan, Sekhar 2016-02-24 09:14:32 Re: PostgreSQL: Autocommit through windows odbc driver doesnt work!!!