关于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

关于oracle sid和sid和database name和global database name和instace 死定区别。

参考文献 http://lifengxi.blog.163.com/blog/static/10348848200772192915496/ http://blog.sina.com.cn...
  • meijiexuji
  • meijiexuji
  • 2014年02月26日 15:17
  • 573

关于 Global Database Name

Global name A global name refers to the full name of a database (including its domain) ...
  • xuelanggongwu
  • xuelanggongwu
  • 2013年05月21日 14:54
  • 851

区分SID 和 GOLBAL DATABASE NAME

SID = identifies the database instance (database name + instance number). So if your database name i...
  • meboy88scofiled
  • meboy88scofiled
  • 2010年01月23日 22:43
  • 338

global_name 和dblink的关系

结论: 创建dblink时候,主要看本地的global_name 是否为true,如果本地的global_name =true,那么你创建的dblink必须和远端数据库的global_name 一样...
  • wll_1017
  • wll_1017
  • 2013年06月06日 21:58
  • 4593

Oracle创建Database Link的两种方式

Oracle数据库如何创建Database Link呢?本文我们主要就介绍一下这部分内容,Oracle数据库创建Database Link有两种方式,一种是通过菜单,一种是通过SQL。 创建一个...
  • liyisong2008
  • liyisong2008
  • 2015年08月12日 10:52
  • 2213

Database Link详解.

一:dblink创建: 1、已经配置本地服务 create public database link toBeJing connect to scott identified by tige...
  • yangzongzhuan
  • yangzongzhuan
  • 2014年06月24日 16:46
  • 843

Global Domain Name Registration www.apidnr.com.hk

Global Domain Name Registration Centre www.apidnr.com.hk african domain names asia domain names euro...
  • apidnr
  • apidnr
  • 2009年12月02日 09:55
  • 186

Oracle,修改 GLOBAL_NAME 和 SERVICE_NAME

Oracle,修改 GLOBAL_NAME 和 SERVICE_NAME
  • iw1210
  • iw1210
  • 2014年08月22日 15:42
  • 4026

NameError: name 'app' is not defined(关键词:flask/bug)

(venv) henry@henry-virtual-machine:~/dev/myproject/flaskr$ tree . ├── flaskr.py ├── schema.sql ├── s...
  • qq_33528613
  • qq_33528613
  • 2017年11月25日 11:55
  • 148

Oracle11g密码区分大小写导致database link无法连接

Oracle11g的密码默认是区分大小写的,该特性通过初始化参数sec_case_sensitive_logon控制,默认TRUE表示区分大小写。但是Oracle11g之前的版本密码都是不区分大小写的...
  • songkexin
  • songkexin
  • 2015年02月05日 06:14
  • 2505
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:关于database link 和 domain 和 global name
举报原因:
原因补充:

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