oracle的那些名字，那些事(二)
RACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 1219760 bytes
Variable Size 121635664 bytes
Database Buffers 293601280 bytes
Redo Buffers 2973696 bytes
SQL> select instance_name from v$instance;
INSTANCE_NAME
------------------------------------------------
think www.2cto.com
SQL> !ps -ef|grep ora_
oracle 1937 1 0 15:01 00:00:00 ora_pmon_think
oracle 1939 1 0 15:01 00:00:00 ora_psp0_think
oracle 1941 1 0 15:01 00:00:00 ora_mman_think
oracle 1943 1 0 15:01 00:00:00 ora_dbw0_think
oracle 1945 1 0 15:01 00:00:00 ora_lgwr_think
oracle 1947 1 0 15:01 00:00:00 ora_ckpt_think
oracle 1949 1 0 15:01 00:00:00 ora_smon_think
oracle 1951 1 0 15:01 00:00:00 ora_reco_think
oracle 1953 1 0 15:01 00:00:00 ora_cjq0_think
oracle 1955 1 0 15:01 00:00:00 ora_mmon_think
oracle 1957 1 0 15:01 00:00:00 ora_mmnl_think
oracle 1959 1 0 15:01 00:00:00 ora_d000_think
oracle 1961 1 0 15:01 00:00:00 ora_s000_think
oracle 2055 1911 0 15:06 pts/3 00:00:00 /bin/bash -c ps -ef|grep ora_
oracle 2057 2055 0 15:06 pts/3 00:00:00 grep ora_
NO.4
global_name:如果是分布式数据库，db_name会出现重名。global_name是对db_name的扩展。管理上采用和service_name一样的方式。即：加个db.domain。在db link时，必须关心一下global_name. www.2cto.com
SQL> show parameter global_names
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean FALSE
GLOBAL_NAMES参数并不是用来控制GLOBAL_NAME的，而是用来限制DBLINK的使用.GLOBAL_NAMES参数的作用，简单得说来就是：当GLOBAL_NAMES参数设置为TRUE时，使用DBLINK的名称必须与被连接库的GLOBAL_NAME一致。
SQL> select * from global_name;
GLOBAL_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
ORCL.ORACLE.COM
www.2cto.com
全局数据库名可以从视图global_name里面获取。
NO.5
db_unique_name
是数据库的别名，小名。在initorcl.ora中修改。配置DG时需要关心他。
作者 linwaterbin