Home » RDBMS Server » Networking and Gateways » not able to access thro db link
not able to access thro db link [message #280659] Wed, 14 November 2007 06:45 Go to next message
Messages: 181
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


thank you
Re: not able to access thro db link [message #280662 is a reply to message #280659] Wed, 14 November 2007 07:18 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
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.

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

Current Time: Sat Jul 22 14:10:26 CDT 2017

Total time taken to generate the page: 0.12148 seconds