Database Administration (MOSC)

MOSC Banner

cannot get a new HS connection working

edited Apr 4, 2013 9:40AM in Database Administration (MOSC) 4 commentsAnswered
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))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center