Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 12526
  • Last Modified:

HSODBC a Oracle database link with SQLServer DBlink fails Credential retrieval failed Lost RPC connection to remote Agent

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.ISHEALTH.NET  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
0
chriskelly777
Asked:
chriskelly777
  • 3
  • 3
2 Solutions
 
ravindran_eeeCommented:
In ODBC Administrator did u try "Test connection"?? Did it succeed??
Please let me know the Authentication service setup in SQLNET.ORA..
0
 
chriskelly777Author Commented:
Now you are on to something:
Oracle metalink came and told me to comment out the line
SQLNET.AUTHENTICATION_SERVICES= (NTS)
## SQLNET.AUTHENTICATION_SERVICES= (NTS)
After I did this the DBlink worked.Great only now my sys/  login doesnot work nor does my RMAN /@DB  connection.
What gan I do to get the sys connection working again.
Thank you
Chris
0
 
ravindran_eeeCommented:
Yes.. I was about to tell the same thing.. U can also configure it to (NONE).. That would also solve the problem..
OK.. Now let us come to the next problem..
I dont think Database Links should affect sys login..
From what u have explained it is only SYS login which is not working right?? Are u able to login as all other users???
Please let me know the error message displayed while attempting to login..
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
chriskelly777Author Commented:
Thank you for your help
I can logon as anyone as long as I  put the user name and password.
But putting passwords in my automated backup scripts won;t pass Audit.

So how can I change
## SQLNET.AUTHENTICATION_SERVICES= (NTS)
to get the best of both worlds.
Below are the traces and errors that you asked for.
Thank you once again I have been working on this alot.
Chris


Also commenting out the sqlnet line
## SQLNET.AUTHENTICATION_SERVICES= (NTS)
makes my sys connections fail.
Connect sys/****@KNTACB1.T1.TEST.ISHEALTH.NET AS SYSDBA

SQL> SQL*Plus: Release 9.2.0.1.0 - Production on Sat Apr 29 14:05:11 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> Connect sys/password@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
Connected.
SQL> Connect sys/****@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> set lines 9000
SQL> Connect sys/password@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
Connected.
SQL> select * from IFC_SYSTEM@SD_SANDBOX;

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> ## SQLNET.AUTHENTICATION_SERVICES= (NTS)
SP2-0734: unknown command beginning "# SQLNET.A..." - rest of line ignored.
SQL> select * from IFC_SYSTEM@SD_SANDBOX;

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> /

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> /

  SYS_SITE SYS_VERSION     SYS_OIDHIGH
---------- --------------- -----------
         1 4.5.0588.1605         57457

SQL> *********************************************
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> Connect sys/ora4u2c@DBATEST.T1.TEST.ISHEALTH.NET  AS SYSDBA
Connected.
SQL> set lines 9000
SQL> select * from IFC_SYSTEM@SD_SANDBOX;
select * from IFC_SYSTEM@SD_SANDBOX
                         *
ERROR at line 1:
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(
ORA-02063: preceding 2 lines from SD_SANDBOX


SQL> ************************************************

Instance name: dbatest

Redo thread mounted by this instance: 1

Oracle process number: 30

Windows thread id: 3916, image: ORACLE.EXE


*** 2006-04-29 14:13:35.000
*** SESSION ID:(31.39924) 2006-04-29 14:13:35.000
HS:  RPC error, SendGetProduct pid, NCR code 1003
HS:  Probable error (ORA-28546) in network administration
*** 2006-04-29 14:13:35.000
*** 2006-04-29 14:13:35.000
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=MZVMDB02)(PORT=1524)))(CONNECT_DATA=(SID=SD_SANDBOX))), NCR status = 28546
HS:  RPC error, SendGetProduct pid, NCR code 1003
HS:  Probable error (ORA-28546) in network administration
*** 2006-04-29 14:13:35.000
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=MZVMDB02)(PORT=1524)))(CONNECT_DATA=(SID=SD_SANDBOX))), NCR status = 28546
0
 
ravindran_eeeCommented:
Ok.. Basically I can see  2 error messages in the above thread..

>>ORA-01017: invalid username/password; logon denied
I think this is the one which u are talking about.. That is unable to login as sys.. I dont see any problem for a script to be executed when u can login manually successfully.. The error is clear enough.. It is not some other problem.. Just that either username or password is wrong.. Looks like the password is wrong in the script.. Please cross-check ur scripts again..

>>ORA-28546: connection initialization failed, probable Net8 admin error
This could be due to various reasons.. Are u getting this error always or sometimes?? If it does not happen always then it could be due to network connectivity..
The most frequent specific causes are:
1. Database link setup for an Oracle-to-Oracle connection instead connects to a Heterogeneous Services agent or an external procedure agent.
2. Database link setup for a Heterogeneous Services connection instead connects directly to an Oracle database server.
The extproc_connection_data definition in tnsnames.ora connects to an Oracle instance instead of an external procedure agent.
3. Connect data for a Heterogeneous Services database link, usually defined in tnsnames.ora, does not specify (HS=).
4. Connect data for an Oracle-to-Oracle database link, usually defined in tnsnames.ora, specifies (HS=).
0
 
haidersyedCommented:
Dear chriskelly777 ,

Kindly let the other configuration be there the problem of invalid username/passowrd can be solved just by changing user password after connecting with that following are the two methos

1-  Alter user sys identified by newpassword

2-  delete existing password file pwdDATABASESID.ora whic can be found in dbs folder in unix and database folder in windows where DATABASESID is database name

execute command on command prompt

orapwd file=dbsflderpath\pwdDATABASESID.ora  password=passwordyouwanttoset entries=100
0
 
chriskelly777Author Commented:
Thank you for everyones help. I got it to work but the passwordfile is a problem.
Here is my final instructions to help someone else:

To connect to SQLServer from Oracle
1: I made my Oracle service account a user on my SQLServer database
2: Create an ODBC
3: Create the INIT----.ora in the hs directory
4: Modify the Listener
5: Modify the TNSNames
6: Modify the SQLNet.ora file  from (NTS) to (none)
7: Modify the parameters Global_Names = False
8: Create a DBlink
9: The sql query works
10: Now come the bad part. Modify all of your oracle maintenance script that used a password file because now they don't work because we in step 5 disabled
the password file.
11: Is there a way to be able to continue to logon using the password file???
Thank you
Chris Kelly
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now