oracle 11g单实例数据库修改IP地址

1 修改网卡

[root@egrant12814 ~]# cat /etc/sysconfig/network-scripts/ifcfg-em3
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=none
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=em3
UUID=18ddf59a-1bc4-4d9f-962b-362658323bc1
DEVICE=em3
ONBOOT=yes
IPADDR=192.168.128.14
PREFIX=24
GATEWAY=192.168.128.254
DNS1=192.168.2.5
[root@egrant12814 ~]# vi /etc/sysconfig/network-scripts/ifcfg-em3
[root@egrant12814 ~]# service network restart   //重启网卡
Restarting network (via systemctl):  


[root@egrant12814 ~]# cat /etc/sysconfig/network-scripts/ifcfg-em3
TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=none
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=em3
UUID=18ddf59a-1bc4-4d9f-962b-362658323bc1
DEVICE=em3
ONBOOT=yes
IPADDR=192.168.128.140
PREFIX=24
GATEWAY=192.168.128.254
DNS1=192.168.2.5

2 修改host文件

[root@egrant12814 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.128.14 egrant12814 egrant12814.nsfc.gov.cn  isisn.nsfc.gov.cn
[root@egrant12814 ~]# vi /etc/hosts
[root@egrant12814 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.128.140 egrant12814 egrant12814.nsfc.gov.cn  isisn.nsfc.gov.cn

3 修改监听和tns文件

[oracle@egrant12814 ~]$ lsnrctl stat

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-11月-2019 14:39:19

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=egrant12814)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                19-11月-2019 08:55:57
Uptime                    0 days 5 hr. 43 min. 21 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/egrant12814/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=egrant12814)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "ora11g" has 1 instance(s).
  Instance "ora11g", status READY, has 1 handler(s) for this service...
Service "ora11gXDB" has 1 instance(s).
  Instance "ora11g", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@egrant12814 ~]$ cat /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = egrant12814)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

在本例中，监听文件的host记录的是hostname而不是IP地址，因此经过尝试，即使不更改监听文件，也不影响PL/SQL访问数据库。
如果host记录的是IP地址而不是hostname，则需要修改监听文件。或者用xstart通过netca工具重新配置监听。
参考：netca重新配置监听