| Public Database Link [message #165007] |
Tue, 28 March 2006 00:22  |
ramsat
Messages: 49
Registered: November 2005
|
Member |
|
|
Hai,
i created a public database link like the below
Scenario: 1
************
> alter system set global_names = true;
> create public database link db3.us.oracle.com
using 'db3';
The link was created but the test connection fails
Scenario: 2
************
> alter system set global_names = False;
> create public database link db3.us.oracle.com
using 'db3';
The link was created but the test connection is alos success ???
Could some one pls explain what is happening . I want to get success in the scenario1 bcoz i am trying to do Replication for which global_names= True is mandatory.
Note: I am in Urgent establishment of replication,Kindly help
Thank U in Advance
Ramesh
|
|
|
|
| Re: Public Database Link [message #165594 is a reply to message #165007] |
Fri, 31 March 2006 00:41  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
Hi,
If GLOBAL_NAMES is set to TRUE, then the name of the database link and the global databse name should be the same.
Example
If the global database name for db3 is db3.domainname.com and GLOBAL_NAMES is TRUE, then the link name must be called db3.domainname.com
To Know the Global Name of a Database
Select global_name from global_name;
If GLOBAL_NAMES is FALSE, it is not required to use the global name as the database link name.
Rgds
SALIH KM 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
