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 SQL> update props$ set value$ = 'orcl' where name = 'GLOBAL_DB_NAME'; 已更新 1 行。 SQL> select * from global_name; GLOBAL_NAME -------------------------------------------------------------------------------- orcl
|