分类: WINDOWS
2011-09-07 11:18:24
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.COM
3、修改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
--------------------------------------------------------------------------------
orcl
3、修改global_name
update global_name set global_name='ORCL';