OraFAQ Forum: Server Administration » DB links with global

Home » RDBMS Server » Server Administration » DB links with global_names=true

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB links with global_names=true [message #163239]

Wed, 15 March 2006 13:00

dba_
Messages: 1
Registered: March 2006

Junior Member

I change the global_names to true in my db to use the streams.
The old DB links are problem now.
The others db have global_names = false and not participate on the streams enviroment and not need have global_names=true or domain setting.
How to proceed in this case?
I need to recreate the old DB Links? I try this but the new dblinks are created like db.world. I need include domain in all others dbs?

Report message to a moderator

Re: DB links with global_names=true [message #163288 is a reply to message #163239]

Wed, 15 March 2006 23:46

Frank Naude
Messages: 4600
Registered: April 1998

Senior Member

Yes, you need to name your dblinks appropriately when using GLOBAL_NAMES=TRUE, otherwise they will not work. To change a DB's global name:

SQL> SELECT * FROM global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
O10GR2.REGRESS.RDBMS.DEV.US.ORACLE.COM

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO oracle10g.world;

Database altered.

Report message to a moderator

Previous Topic:	Installtion problem of oracle 8i
Next Topic:	Why listener and local service could not succeed?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 04 20:55:31 CST 2026