I am attempting to use oracle's hsodbc generic database link driver to gain access to a postgresql database from the oracle 10gr2 database server. I believe I've everything set up but I am receiving this error in the sqlplus promt after trying an online query.
SQL> choose * from temp_user@intranet choose * from temp_user@intranet * ERROR at line 1: ORA-28545: error identified by Net8 when hooking up for an agent Not able to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from INTRANET
Basically use "isql" in the linux command line (quite simply test only the odbc connection) the query works.
I type in "isql intranet" (intranet may be the title from the odbc connection) I recieve the prompt I type choose * from temp_user and that i receive back my 157 records on the watch's screen.
And So I be aware of odbc configuration is setup properly. Here's what I actually do for oracle.
%oracle_home/hs/admin/inithsodbc.ora HS_FDS_CONNECT_INFO = intranet HS_FDS_TRACE_LEVEL = OFF HS_FDS_SHAREABLE_Title = /usr/bin/ODBCConfig
%oracle_home/network/admin/tnsnames.ora INTRANET = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.1)(PORT = 5432)) ) (CONNECT_DATA = (SID = INTRANET) ) (HS = OK)
%oracle_home/network/admin/listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = INTRANET) (PROGRAM = hsodbc) (SID_Title = INTRANET) (ORACLE_HOME = /home/oracle/application/OraHomeTEST) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracledb.andersen-const.com)(PORT = 5432)) ) )
I've restarted the listener. It's status is the following. Services Summary... Service "INTRANET" has 1 instance(s). Instance "INTRANET", status UNKNOWN, has 1 handler(s) with this service...
Then i get into sqlplus in the database server command line and perform the following.
drop database link intranet
create database link intranet connect with auser recognized by apassword using 'intranet'
This really is effective.
However, if I run
choose * from temp_user@intranet
I get the error
ERROR at line 1: ORA-28545: error identified by Net8 when hooking up for an agent Not able to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from INTRANET
I have spend atleast a great day returning within the configures and seeking things and that i always understand this error.
Anybody have plans,
Exactly what does "tnsping intranet" report?
Are you certain your hsodbc prorgram is incorporated in the Oracle_home/bin directory from the your gateway installation? Also, is the LD_LIBRARY_PATH set correctly?
In my opinion your LD_LIBRARY_PATH ought to be $ORACLE_HOME/lib. Sorry, unsure since i have avoid much with *Nix nowadays.