文档课题：dg更换IP地址.
系统：CentOS 7.9
数据库：oracle 11.2.0.4
主库IP：192.168.133.150(修改为192.168.133.105)
备库IP：192.168.133.151(修改为192.168.133.106)
1、原始信息
主库
[oracle@oel ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.133.150 oel
备库
[root@oeldg ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.133.151 oeldg
2、停DB&监听
主库
SQL> shutdown immediate
[oracle@oel ~]$ lsnrctl stop
备库
SQL> alter database recover managed standby database cancel;
SQL> shutdown immediate
[oracle@oeldg ~]$ lsnrctl stop
3、修改IP
主库
[root@oel ~]# vi /etc/sysconfig/network-scripts/ifcfg-ens33
……
IPADDR=192.168.133.105
……
说明：将IPADDR=192.168.133.150修改为IPADDR=192.168.133.105
备库
[root@oeldg ~]# vi /etc/sysconfig/network-scripts/ifcfg-ens33
……
IPADDR=192.168.133.106
……
说明：将IPADDR=192.168.133.151修改为IPADDR=192.168.133.106
4、重启网卡
主库
[root@oel ~]# systemctl restart network
备库
[root@oeldg ~]# systemctl restart network
5、修改hosts
说明：使用新IP登陆主备库，修改/etc/hosts文件
主库
[root@oel ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.133.105 oel
说明：将192.168.133.150修改为192.168.133.105
备库
[root@oeldg ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.133.106 oeldg
说明：将192.168.133.151修改为192.168.133.106
6、修改TNS
主库
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL150 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.105)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl150)
)
)
ORCL151 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.106)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl151)
)
)
说明：将192.168.133.150修改为192.168.133.105，192.168.133.151修改为192.168.133.106
备库
[oracle@oeldg admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL150 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.105)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl150)
)
)
ORCL151 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.106)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl151)
)
)
说明：将192.168.133.150修改为192.168.133.105，192.168.133.151修改为192.168.133.106
7、修改监听
主库
[oracle@oel admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.105)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
说明：将192.168.133.150修改为192.168.133.105
备库
[oracle@oeldg admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl151)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = orcl151)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.133.106)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
说明：将192.168.133.151修改为192.168.133.106
8、启动服务
备库
[oracle@oeldg admin]$ lsnrctl start
[oracle@oeldg admin]$ sqlplus / as sysdba
SQL> startup
SQL> alter database recover managed standby database using current logfile disconnect from session;
主库
[oracle@oel admin]$ lsnrctl start
[oracle@oel admin]$ sqlplus / as sysdba
SQL> startup
9、验证
主库
SQL> select open_mode,protection_mode,database_role,switchover_status from v$database;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
-------------------- -------------------- ---------------- --------------------
READ WRITE MAXIMUM PERFORMANCE PRIMARY RESOLVABLE GAP
备库
SQL> select open_mode,protection_mode,database_role,switchover_status from v$database;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE SWITCHOVER_STATUS
-------------------- -------------------- ---------------- --------------------
READ ONLY WITH APPLY MAXIMUM PERFORMANCE PHYSICAL STANDBY NOT ALLOWED
参考网址：
