-
I have one instance TCMS in A server and antoher instance TCMS in B server, how do I create the database link in A for B.
It gives me ORA-02082: a loopback database link must have a connection qualifier.
How do you resolve this?? Please help
Thanx, your help is greatly appreciated
KN
-
Setup a new alias in your tnsnames.ora file on the server and point to the instance on server B.
Jeff Hunter
-
I have that set up already, this is the entry I have for server B for TCS:
VALLEY=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.4.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TCS)
)
)
and this is the one I have for server A for TCS database
TCS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.3.0.45)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TCS)
)
)
I can connect to both of them otherwise. BUt when I try to create a database link TCS(in server B) in TCS(in server A)
It gives me the above error.
If I try to give Valley as the db link name/db name I get the error:
unable to resolve service name error
Thanx
KN
-
While you are on serverA, can you sqlplus to serverB using the VALLEY alias?
Jeff Hunter
-
-
What commands are you using to create the DB link?
Jeff Hunter
-
If you have global_name = true than it is not allowed to create database link different from database global_name.
So, try either change global_Name to valley, or set global_name = false.
Another option is to use fully quilified name , starting with the server name to differentiate between 2 databases.
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
Global names is set to false in both the servers.
Where do you have this fully qualified name(you mean the service name right) in the server as well as client's machine or.....
KN
-
Please, publish a command to create db link
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
CREATE DATABASE LINK TCS
CONNECT TO TCSDATA IDENTIFIED BY tcsdata
USING 'tcs'
/
I get the above mentioned loopback error when I run this.
CREATE DATABASE LINK valley_heart
CONNECT TO TCSDATA IDENTIFIED BY tcsdata
USING 'valley_heart'
/
It creates the db link but when I try to use it:
it gives me unable to resolve service name error.
KN
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|