oracle 查看、修改global_name 的方法
2010-12-28 16:50
1、更改global_names 为true;
SQL> alter system set global_names=true;--慎重
2、查看global_names属性
SQL> show parameter global_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean FALSE
3、查看global_name
SQL> conn sys/sys as sysdba
已连接。SQL> select * from global_name;GLOBAL_NAME--------------------------------------------------------------------------------ORCL.US.ORACLE.COM3、修改global_name
运行cmd打开命令行窗口,输入:sqlplus /nolog; conn /as sysdba;然后:
SQL> update props$ set value$ = 'orcl' where name = 'GLOBAL_DB_NAME';已更新 1 行。SQL> select * from global_name;GLOBAL_NAME--------------------------------------------------------------------------------orcl3、修改global_name
update global_name set global_name='ORCL';
from: