Hetrogenous services errors: NCRO failed, RSLV connection

[djheath]

This is a strange problem that has suddenly stopped working after weeks of continuous use and I dont know where to turn to resolve it. I have done a search on these forums but nothing comes up.

I have two oracle 9i databases running on two separate Linux Red Hat Enterprise 4 machines. Both have pretty much identical database setups since one is a backup database of the other. I have set up both databases to be able to connect to a Microsoft SQL database which is running on another remote windows machine. I have set up an identical db link and also an identical tnsnames.ora file on both machines. The listener.ora file is located on the windows machine which has oracles Hetrogenous services installed. It is using the hsodbc program. The problem is, one machine can connect fine and select data from the MSSQL database where as the other cannot.

The db link is called scala and when issuing the following command:

select * from all_catalog@scala;

I get results back as expected from the one database, but the other oracle box returns:

ORA-28545: error diagnosed by Net8 when connecting to an agent
NCRO: Failed to make RSLV connection
ORA-02063: preceding 2 lines from SCALA

The annoying thing is, it was working fine and im now getting this RSLV connection error message but only on the one database.

Here is the tnsnamse.ora file from the problem machine,

scala =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.44.0.246)(PORT = 1526))
    )
    (CONNECT_DATA =
      (SID = scala))
      (HS = OK)
    )
  )

If I do a tnsping I recieve the following success message on the broken machine:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.44.0.246)(PORT = 1526))) (CONNECT_DATA = (SID = scala)) (HS = OK)) 
OK (40 msec)

The following is the listner.ora file on the microsoft machine:

# LISTENER.ORA Network Configuration File: D:\Orahome9i\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.44.0.246)(PORT = 1526))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Orahome9i)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = SCALA)
      (ORACLE_HOME = D:\Orahome9i)
      (PROGRAM = hsodbc)
    )
)

tnsping connects fine and the listener and tnsnames are obviously fine as I can connect ok and get data back from the other database.

Having a search on the net points to listener problems but this cant be if its working ok on one.

Any help would be great. What does the RSLV connection error mean?

Thanks.

David.

[Thomasps]

Check this out..

http://www.minisoft.com/pages/middle...oracle_faq.htm

[djheath]

Thanks for the reply, but I have read that error many a time. The ip addrss is correct for the oracle server. Tnsping returns the correct success message so I dont know where else to turn.