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重新配置监听