本文共 2026 字,大约阅读时间需要 6 分钟。
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ cdb_cluster_name string cell_offloadgroup_name string db_file_name_convert string db_name string db db_unique_name string db global_names boolean FALSE instance_name string db2 lock_name_space string log_file_name_convert string pdb_file_name_convert string processor_group_name stringNAME TYPE VALUE
------------------------------------ ----------- ------------------------------ service_names string db.xxx.com SQL> select * from global_name;GLOBAL_NAME
-------------------------------------------------------------------------------- DB.XXX.COMSQL> alter system set service_names='db' scope=both sid='*';
SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------cdb_cluster_name string
cell_offloadgroup_name string db_file_name_convert string db_name string db db_unique_name string db global_names boolean FALSE instance_name string db2 lock_name_space string log_file_name_convert string pdb_file_name_convert string processor_group_name stringNAME TYPE VALUE
------------------------------------ ----------- ------------------------------ service_names string db SQL> select * from global_name;GLOBAL_NAME
-------------------------------------------------------------------------------- DB.XXX.COMSQL> update global_name set global_name='DB';
1 row updated.
SQL> commit;
Commit complete.
SQL> select * from global_name;
GLOBAL_NAME
-------------------------------------------------------------------------------- DBSQL> show parameter db_domain;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ db_domain string .XXX.COMSQL> alter system set db_domain='' scope=spfile sid='*';
重启启停数据库生效
SQL> show parameter db_domain;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ db_domain string最后检查监听listener.ora和tnsnames.ora去掉不需要的后缀。
相关参考:
转载地址:http://gzsof.baihongyu.com/