114.You plan to implement the distributed database system in your company. You invoke Database Confi

本文介绍了在使用Oracle数据库系统时,如何正确配置Global Database Name。该名称由数据库名和域名组成,用于在网络环境中唯一标识数据库。文章还提到了GLOBAL_NAMES参数的作用及设置方法。
114.You plan to implement the distributed database system in your company. You invoke Database
Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts
you to specify the Global Database Name.
What must this name be made up of?
A.It must be made up of a database name and a domain name.
B.It must be made up of the value in ORACLE_SID and HOSTNAME.
C.It must be made up of the value that you plan to assign for INSTANACE_NAME and HOSTNAME.
D.It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
答案:A
解析:
1.Global Database Name
The full database name that uniquely distinguishes it from any other database in your network domain.
For example:
sales.us.example.com
where sales is the name you want to call your database and us.example.com is the network domain in which the database is located.
2.GLOBAL_NAMES
GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects.
它的功能主要是限制dblink的,大概意思就是
如果A通过dblinke连接B,并且A上的global_names参数设置为true的话,那么dblinke的名字必须与B上面的global_name名字相同,
如果想创建多个dblink那么可以在名字后面增加@...,这样就可以创建多个了
SQL> show parameter global_names 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     FALSE


SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
WAHAHA3
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值