| 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][/CODE]
|
|
|
|
| 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: 68645
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
