Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-11-2009
Member
 
Join Date: Nov 2009
Posts: 103
Difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters

Can anyone tell me that what is the difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters? and one more thing the global name is not equal to DB_NAME+DB_DOMAIN, why? Please help me out of this.
Reply With Quote
  #2  
Old 13-11-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
re: Difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters

Ya, here is the difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters:
DB_UNIQUE_NAME is used to identify the databases uniquely,i.e usually for dataguard, but it also impacts OMF file locations, whereas the GLOBAL_NAME Parameter is usually active only when GLOBAL_NAMES=true property is set, and this impacts the security for database links.
Quote:
Database link name must be the same as GLOBAL_NAME for the remote database.
Reply With Quote
  #3  
Old 13-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
re: Difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters

You can use the ALTER DATABASE statement to change the domain in a database. Note that after the database is created, changing the initialization parameter DB_DOMAIN has no effect on the global database name or on the resolution of database link names. So, after the DB(database) is created, even if you change the GLOBAL_NAME "subcomponent" names, you must still use ALTER DATABASE RENAME GLOBAL_NAME TO database.domain;
Reply With Quote
  #4  
Old 13-11-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: Difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters

Some important points regarding DB_UNIQUE_NAME, DB_DOMAIN, GLOBAL_NAME:
1) DB_UNIQUE_NAME: When you use the above parameter then each database should be different. For e.g. On servers cluster1node1/2 the database’s name is ABCD_FORTWORTH. On servers cluster2node1/2 the databases’s name is ABCD_DALLAS.
2) DB_DOMAIN: Each Streams database, specifies the network domain where the database resides.
3) GLOBAL_NAME: GLOBAL_NAME=TRUE. On each Streams database you need to specify GLOBAL_NAME=TRUE to ensure the database links work correctly. For example, the source database is named ABCD_FORTWORTH.mydomain when you select * from global_name.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters"
Thread Thread Starter Forum Replies Last Post
URL dynamic parameters Bricklayer Software Development 6 02-08-2010 10:30 AM
VBA Recordset / Parameters Gunner 1 Software Development 5 17-02-2010 12:38 AM
Ghost Parameters Ayush Operating Systems 1 03-02-2009 01:34 PM
BIOS parameters bayz Overclocking & Computer Modification 4 01-01-2009 10:48 PM
SATA no parameters super soaker Hardware Peripherals 4 01-12-2008 06:18 PM


All times are GMT +5.5. The time now is 07:09 AM.