关于database link 和 domain 和 global name

转载 2011年01月23日 18:51:00

Database Global Names

The GLOBAL_NAMES Parameter


Database Global Names
Every Oracle database has, or should have, a global name that is unique on your network. The global name is a combination of the database name and domain. You define the global name when you first create a database by placing parameters in your initialization file that specify those two values. For example: 
db_name = herman
db_domain = gennick.org
Once a database has been created, the global name is stored within the control file, and the parameter values in the initialization file no longer matter. To change a global name for an existing database, you must use the ALTER DATABASE RENAME GLOBAL_NAME command

The GLOBAL_NAMES Parameter
You used to be able to dream up any name for a database link, but for the past several years Oracle has strongly recommended that database link names match the global names of the target databases. Thus, if you were going to create a link to the database named herman.gennick.org, you would name the link herman.gennick.org as well. 
Oracle feels strongly enough about this naming convention that they even provide an enforcement mechanism for you to use. By adding the following parameter setting to all your parameter files, you effectively prevent anyone from using a database link with a name that violates this naming convention: 
GLOBAL_NAMES = TRUE
It turns out that this has ramifications for global database links. Oracle Names doesn't even appear to support the creation of a global database link with a name that doesn't match the target database's global name. So if you are using Oracle Names, you must follow the preferred naming convention.

 


--------------------------------------------------------------------------------
When you set the initialization parameter GLOBAL_NAMES to TRUE, Oracle ensures
that the name of the database link is the same as the global database name of the
remote database. For example, if the global database name for hq is hq.acme.com,
and GLOBAL_NAMES is TRUE, then the link name must be called hq.acme.com.
Note that Oracle checks the domain part of the global database name as stored in
the data dictionary, not the DB_DOMAIN setting in the initialization parameter file

If you set the initialization parameter GLOBAL_NAMES to FALSE, then you are not
required to use global naming. You can then name the database link whatever you
want. For example, you can name a database link to hq.acme.com as foo.


去掉DB_DOMAIN的方法
http://yangtingkun.itpub.net/post/468/279105

Using Oracle Global Database Links
http://www.oreillynet.com/pub/a/oreilly/oracle/news/oraclenet8_1200.html

相关文章推荐

Cannot drop a database link after changing the global_name ORA-02024 [ID 382994.1]

Cannot drop a database link after changing the global_name ORA-02024 [ID 382994.1] Modified 22-NOV-2...

database link 与global_names参数设置的关系

GLOBAL_NAMES参数的作用,简单得说来就是:当GLOBAL_NAMES参数设置为TRUE时,使用DBLINK的名称必须与被连接库的GLOBAL_NAME一致。本来是想做几个简单的测试,但是发现...

db_name、db_domain、service_name、global_name、instance_name、oracle_sid

原文整理自网路:  概念: Db_name:对一个数据库(Oracle database)的唯一标识。这种表示对于单个数据库是足够的,但是随着由多个数据库构成的分布式数据库的普及,这种命令数据库的...

Oracle中db_name,instance_name,SID,DB_DOMAIN,GLOBAL_NAME,SERVICE_NAME,NET_SERVICE_NAME的区别

注:文章内容由网络及相关书籍整理而来,如此只为共享知识,给予帮助。 注:写作环境为Oracle 10g Release 2 (10.2) 一、数据库名 1.数据库名的概念      数据库名(...

Db_name,Db_domain,Global_name,Service_name解释

Db_name:对一个数据库(Oracle database)的唯一标识,该数据库为Oracledatabase。这种表示对于单个数据库是足够的,但是随着由多个数据库构成的分布式数据库的普及,这种命令...

搞清概念:db_name,instance_name,ORACLE_SID,db_domain,global_name,service_name,net_service_name

对于oracle新手来说,会被一大堆概念搞的头晕眼花,我有过切身体会。本文详细介绍了部分基础概念,特此转载下来,自己学习一下,也分享给需要的朋友。 转自:http://zhao860606.blog...

DB_NAME、DBID、DB_UNIQUE_NAME、SERVICE_NAME、SID、INSTANCE_NAME、GLOBAL_DATABASE_NAME

【转载】DB_NAME、DBID、DB_UNIQUE_NAME、SERVICE_NAME、SID、INSTANCE_NAME、GLOBAL_DATABASE_NAME 搭...
  • moses19
  • moses19
  • 2016年05月29日 08:29
  • 268

db_name,instance_name,service_names,db_domain,global_name,global_names

http://www.cnblogs.com/rootq/archive/2009/06/14/1502991.html 1、db_name 数据库名 SQL> connect xys/man...

@domain name 3.0 zend 增强版

  • 2004年08月19日 17:25
  • 6KB
  • 下载

Real domain name required for sender address

从114服务器每天发邮件给,通知一下硬盘使用情况。下面是脚本里的一条语句。 #df -h |mutt -s "`ifconfig  |grep Bcast |head -1`" 报错: ...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:关于database link 和 domain 和 global name
举报原因:
原因补充:

(最多只允许输入30个字)