Why can I not connect to SQLServer?
HSODBC a Oracle database link with SQLServer.Credential retrieval failed. Failed to make RSLV connection.Lost RPC connection to remote Agent
I am running Oracle 9i 9.2.0.4 and 9.2.0.5 on Windows 2000
Windows 2000 Advanced Server sp4
I am trying to set up HSODBC a Oracle database link with SQLServer.
I beleive I have everything set up right. The initSD.ora in the hs\admin\ directory
I have the odbc set up the TNSNames and the Listener.
I can TNSping the name SD and it is ok. I made a link using
CREATE DATABASE LINK "SD" CONNECT TO "itgdblink" IDENTIFIED BY "password" USING 'SD' ;
This link creates ok.
Then when a run my query in SQLplus
select * from IFC_SYSTEM@SD;
--------------------------
----------
----
SQL> select * from IFC_SYSTEM@SD;
I get this error:
select * from IFC_SYSTEM@SD
*
ERROR at line 1:
ORA-12638: Credential retrieval failed
--------------------------
----------
---------
In the trace file I get this:
Oracle Corporation --- THURSDAY APR 27 2006 09:20:29.658
Heterogeneous Agent Release
9.2.0.5.0
HS: Agent unable to establish RPC service context...
HS: ... NCR error = 3018
--------------------------
----------
------
Notice on the above machine I am on patch 9.2.0.5.9
--------------------------
----------
------
I did the same setup on two different machines that were patch level
Connected to:
Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
SQL> Connect sys/****@KNTADV1.T1.TEST.I
SHEALTH.NE
T AS SYSDBA
Connected.
SQL> set lines 9000
SQL> CREATE DATABASE LINK "SD" CONNECT TO "itgdblink" IDENTIFIED BY "password" USING 'SD' ;
Database link created.
SQL> select * from IFC_SYSTEM@SD;
select * from IFC_SYSTEM@SD
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
NCRO: Failed to make RSLV connection
ORA-02063: preceding 2 lines from SD
--------------------------
----------
----------
----------
--
In the trace file I get this:
HS: RPC error, SendGetProduct pid, NCR code 1003
HS: Probable error (ORA-28546) in network administration
*** 2006-04-26 20:44:54.701
HS: Error ORA-28544 or 28546, probable network admin error
HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST
=(ADDRESS=
(PROTOCOL=
TCP)(HOST=
mdkint00)(
PORT=1521)
))(CONNECT
_DATA=(SID
=SD))), NCR status = 28546
--------------------------
----------
----------
-------
Thank you for your help
Chris Kelly
Start Free Trial
