Global_name for Replication.
Posted on 2003-03-21
I have 2 databases A and B for replication on Oracle 8.1.7EE.
A.world and B.world, with the same service name let's say Service_name=Test.
By using 'Alter database rename global_name to Repli1.hostname1;' and 'Alter database rename global_name to Repli2.hostname2;' I have changed the global_name.
After some other preparations I have run the scripts on the master server to create db links, and get the error messages like these:
ORA-02011: duplicate database link name
The script was stopped on the point:
CREATE PUBLIC DATABASE LINK "Repli1.hostname1" USING '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname1)(PORT = 1521))
(SERVICE_NAME = test)
Then it said PL/SQL procedure completed successfully as usuall.
But I can not in master server do "select count(*) from firstname.lastname@example.org;" the error message is "can not connect remote server..."
I don't understand what is the role of global_name in this case? because I can't see global_name infos in tnsnames.ora files, and in Net 8 Assistant neither. Maybe this is the problem?