Home » RDBMS Server » Networking and Gateways » Error while executing database link
Error while executing database link [message #66072] Sun, 04 November 2001 23:28 Go to next message
ajay
Messages: 45
Registered: December 2000
Member
Hi there,

I have created a database link.

When I try and run a query using my link:

select count(*)from regions@test

I get the following message:

ORA-02085: database link TEST.WORLD connects to
ORACLE.WORLD

I know I need to make sure the
names are the same. Which files do I need to edit in order to solve this
problem?

Many thanks

Ajay

----------------------------------------------------------------------
Re: Error while executing database link [message #66075 is a reply to message #66072] Mon, 05 November 2001 02:28 Go to previous messageGo to next message
phani kumar
Messages: 4
Registered: November 2000
Junior Member
Hi Ajay,

Check the global_names parameter in init.ora
file. it should be false.

Regards
Phani Kumar

----------------------------------------------------------------------
Re: Error while executing database link [message #66097 is a reply to message #66072] Sat, 10 November 2001 00:35 Go to previous message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
sir,

give the command in the first database

(logon as system/manager)

select * from global_name;

you get like oralce.world
then go to the second database

create datababase link oracle connect .....

after use the select query.

k.sreenivasan

----------------------------------------------------------------------
Previous Topic: 12535 timeout error
Next Topic: TNS 12560 : Problems between NT and AIX
Goto Forum:
  


Current Time: Wed Feb 28 04:47:57 CST 2024