Hetrogenous services errors: NCRO failed, RSLV connection
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Hetrogenous services errors: NCRO failed, RSLV connection

  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Hetrogenous services errors: NCRO failed, RSLV connection

    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,
    Code:
    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:

    Code:
    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:

    Code:
    # 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.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Jun 2006
    Posts
    2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width