Re: ORA-28545 config issue

On 02/25/2016 01:56 PM, Ray Stell wrote:
> 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....

https://duckduckgo.com/?q=+NETWORK%2FNCR+message+65535+&t=ffsb

This looks like it is coming from the Oracle side of things, might have
more luck on an Oracle list.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com