Re: Problem in Create database link
From: David Russell <user_at_msn.com>
Date: 1997/12/02
Message-ID: <01bcff5e$96de6fe0$f15395c1_at_thor>#1/1
Date: 1997/12/02
Message-ID: <01bcff5e$96de6fe0$f15395c1_at_thor>#1/1
I am not exaclty sure what the problem you have is without the error messages, but the following may help :
- 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.
- 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.
- 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.
- 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.
- 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