-- 更改服务名的方法
-- 更改监听
-- 'ORA11GR22' 更改为 'ORA11GR2'
-- 更改连接字符串
/*
更改 service_names 参数,需要更改监听和连接字符串,才能保证 DG 的正常运行
*/
点击(此处)折叠或打开
-
SQL> alter system set service_names = 'ORA11GR2';
-
-
System altered.
-
-
SQL> startup force
-
ORACLE instance started.
-
-
Total System Global Area 830930944 bytes
-
Fixed Size 2257800 bytes
-
Variable Size 536874104 bytes
-
Database Buffers 289406976 bytes
-
Redo Buffers 2392064 bytes
-
Database mounted.
-
Database opened.
-
SQL> show parameter name
-
-
NAME TYPE VALUE
-
------------------------------------ ----------- ------------------------------
-
cell_offloadgroup_name string
-
db_file_name_convert string ORA11GR2, ORA11GR2
-
db_name string ORA11GR2
-
db_unique_name string ORA11GR22
-
global_names boolean FALSE
-
instance_name string ORA11GR22
-
lock_name_space string
-
log_file_name_convert string ORA11GR2, ORA11GR2
-
processor_group_name string
- service_names string ORA11GR2
-- 'ORA11GR22' 更改为 'ORA11GR2'
点击(此处)折叠或打开
-
[oracle@lzb admin]$ vim listener.ora
-
# listener.ora Network Configuration File: /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/listen
-
er.ora
-
# Generated by Oracle configuration tools.
-
-
LISTENER =
-
(DESCRIPTION_LIST =
-
(DESCRIPTION =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = lzb)(PORT = 1521))
-
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
-
)
-
)
-
-
ADR_BASE_LISTENER = /u01/app/oracle
-
-
SID_LIST_listener=
-
(SID_LIST=
-
(SID_DESC=
-
(GLOBAL_DBNAME= ORA11GR2)
-
(SID_NAME= ORA11GR2)
-
(ORACLE_HOME=/u01/app/oracle/oracle/product/11.2.0/dbhome_1)
-
)
- )
-- 更改连接字符串
点击(此处)折叠或打开
-
[oracle@lzb admin]$ vim tnsnames.ora
-
# tnsnames.ora Network Configuration File: /u01/app/oracle/oracle/product/11.2.0/dbhome_1/network/admin/tnsnam
-
es.ora
-
# Generated by Oracle configuration tools.
-
-
ORA11GR22 =
-
(DESCRIPTION =
-
(ADDRESS_LIST =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
-
)
-
(CONNECT_DATA =
-
(SERVICE_NAME = ORA11GR2)
-
)
-
)
-
-
ORA11GR2 =
-
(DESCRIPTION =
-
(ADDRESS_LIST =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))
-
)
-
(CONNECT_DATA =
-
(SERVICE_NAME = ORA11GR2)
-
)
-
)
-
-
ORA11GR21 =
-
(DESCRIPTION =
-
(ADDRESS_LIST =
-
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521))
-
)
-
(CONNECT_DATA =
-
(SERVICE_NAME = ORA11GR2)
-
)
- )
/*
更改 service_names 参数,需要更改监听和连接字符串,才能保证 DG 的正常运行
*/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31369239/viewspace-2123358/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
