OraFAQ Forum: Networking and Gateways » not able to access thro db link

Home » RDBMS Server » Networking and Gateways » not able to access thro db link

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

not able to access thro db link [message #280659]

Wed, 14 November 2007 06:45

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear all,
We have created one db link and when we try to select thro dblink , we are getting this subject error.
Kindly adv us what would be the reason...but same dblink working for other databases...

error msg:

sql>select * from all_tables@devcrm1;
select * from all_tables@devcrm1
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
NCRO: Failed to make RSLU connection
ORA-02063: preceding 2 lines from DEVCRM1

sql>

thank you
kesavan
[CODE][/CO

DE]

Report message to a moderator

Re: not able to access thro db link [message #280662 is a reply to message #280659]

Wed, 14 November 2007 07:18

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-28545: error diagnosed by Net8 when connecting to an agent
 *Cause:   An attempt to call an external procedure or to issue SQL
           to a non-Oracle system on a Heterogeneous Services database link
           failed at connection initialization.  The error diagnosed
           by Net8 NCR software is reported separately.
 *Action:  Refer to the Net8 NCRO error message.  If this isn't clear,
           check connection administrative setup in tnsnames.ora
           and listener.ora for the service associated with the
           Heterogeneous Services database link being used, or with
           'extproc_connection_data' for an external procedure call.

Regards
Michel

Report message to a moderator

Previous Topic:	Domain Connectivity Issue
Next Topic:	ORA-12541 TNS No listener with pl/sql developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 03:05:48 CST 2024