| Re: error:ORA-12154 [message #49628] |
Thu, 31 January 2002 12:15 |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi
The problem may be global_names parameter.
From any one of those databases try
SQL> select name, value from v$parameter where
name = 'global_names';
if you get True.
then you have to name your db links exactly as the global name of your db
in your case it might be..
SQL> CREATE DATABASE LINK OPEN2.world
2 CONNECT TO OPC_OP IDENTIFIED BY OPC_OP
3 USING 'OPEN2'
Or other wise you can reset that parameter to False and then use your original syntax
SQL> alter system set global_names = False;
Bala.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
