Results 1 to 4 of 4

Thread: Difference between DB_UNIQUE_NAME and GLOBAL_NAME Parameters

  1. #1
    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.

  2. #2
    Join Date
    Jan 2008
    Posts
    1,521

    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.
    Database link name must be the same as GLOBAL_NAME for the remote database.

  3. #3
    Join Date
    Oct 2005
    Posts
    2,393

    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;

  4. #4
    Join Date
    May 2008
    Posts
    2,389

    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.

Similar Threads

  1. URL dynamic parameters
    By Bricklayer in forum Software Development
    Replies: 6
    Last Post: 02-08-2010, 10:30 AM
  2. VBA Recordset / Parameters
    By Gunner 1 in forum Software Development
    Replies: 5
    Last Post: 17-02-2010, 12:38 AM
  3. Ghost Parameters
    By Ayush in forum Operating Systems
    Replies: 1
    Last Post: 03-02-2009, 01:34 PM
  4. BIOS parameters
    By bayz in forum Overclocking & Computer Modification
    Replies: 4
    Last Post: 01-01-2009, 10:48 PM
  5. SATA no parameters
    By super soaker in forum Hardware Peripherals
    Replies: 4
    Last Post: 01-12-2008, 06:18 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,892,828.87006 seconds with 16 queries