Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 814
  • Last Modified:

Global_name for Replication.

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_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hostname1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )'
Then it said PL/SQL procedure completed successfully as usuall.

But I can not in master server do "select count(*) from blabla@b.world;" the error message is "can not connect remote server..."

What's wrong?
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?

0
janede
Asked:
janede
  • 2
1 Solution
 
mona1974Commented:
There is a initalization parameter named GLOBAL_NAMES in the initSID.ora. Do you have this parameter set on FALSE?
0
 
saxena_mohitCommented:
Global_names parameter is very important in replication. This parameter should be set to true and this gives the global dinstinct name to you database. but there is a restriction also. If your global name is set to true you service name and database link name should be the same so. Drop all you existing link and recreate them with the same name as your service and after that you should be okay.
thanks
mohit
0
 
saxena_mohitCommented:
use thus instead

CREATE PUBLIC DATABASE LINK 'test' USING test;
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now