?
Solved

Global_name for Replication.

Posted on 2003-03-21
3
Medium Priority
?
812 Views
Last Modified: 2012-06-27
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
Comment
Question by:janede
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Expert Comment

by:mona1974
ID: 8182122
There is a initalization parameter named GLOBAL_NAMES in the initSID.ora. Do you have this parameter set on FALSE?
0
 
LVL 1

Accepted Solution

by:
saxena_mohit earned 75 total points
ID: 8185814
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
 
LVL 1

Expert Comment

by:saxena_mohit
ID: 8185818
use thus instead

CREATE PUBLIC DATABASE LINK 'test' USING test;
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question