1.linux服务器oracle安装时采用固定ip,服务器换机房IP地址变化后 pl/sql连接不上数据库,监听启动不起来,数据库启动不起来
解决方案:修改三个文件
vi /etc/hosts
( 修改
127.0.0.1 localhost.localdomain localhost
192.168.10.105 主机名
)
vi /etc/sysconfig/network
(
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=localhost.localdomain(此处也要和系统的uname保持一致)
)
cd /$oracle_home/network/admin/listener.ora
(
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =ip地址1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =ip地址2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)