cannot get a new HS connection working
Hello, I have several HS connections set up on the Oracle server and they function fine. I am trying to create another, a very similar one.
I created a new ODBC connection, the new init file in hs\admin directory, updated tnslistener.ora and tnsnames.ora and restarted the listener. However, I cannot get the dblink working.
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 BIS.BISMHT
Is there something else that I am missing here?
tnsnames.ora
BISMHT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = dph-oracle-10g)(PORT = 1522))
(CONNECT_DATA =
(SID = bismht)
)
(HS = OK)
)
listener.ora
(SID_DESC =
(SID_NAME = bismht)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
initbismht.ora
HS_FDS_CONNECT_INFO = bismht
HS_FDS_TRACE_LEVEL = 0
Any suggestions?