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