Re: Problem in Create database link

I am not exaclty sure what the problem you have is without the error messages, but the following may help :

1. The is no need to change the database name, just the global name. Check both initxxx.ora files have GLOBAL_NAMES=TRUE. Then drop all existing database links.
2. select * from global_name on both database and check the global names are correct, if they are not then use alter database rename global_name ... to resolve this.
3. Now create the appropriate SQLNET ALIAS on the SERVER (remember it is the ORACLE73.EXE on the server that is reading tnsnames.ora) and test it on the server.
4. Create a public database link. This link should NOT include any usernames or passwords, but should include a SQLNET ALIAS, which should NOT be in the form tns:... or use named pipes.
5. Then create the private database links with usernames and passwords but without a SQLNET ALIAS.

Hope that helps
Regards
David Russell Received on Tue Dec 02 1997 - 00:00:00 CET