TNS-12545
1、环境描述：ORACLE 10.2.0.5
机器内网IP:192.168.3.15
映射了一个外网地址：123.88.123.105
2、/etc/hosts配置如下：
$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 tyfx15 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
123.88.123.105 tyfx15
192.168.3.15 tyfx15
3、listener.ora配置如下：
oracle@tyfx15 admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.15)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.88.123.105)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(SID_NAME = tyfx)
)
)
4、问题
之前这个配置一直没问题
昨天重启了机器，监听就无法启动了，报如下错误
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 10-APR-2014 20:26:31
Copyright (c) 1991, 2010, Oracle.All rights reserved.
Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Trace information written to /tmp/listener_trc.trc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.15)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=123.88.123.105)(PORT=1521)(IP=FIRST)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 99: Cannot assign requested address
Listener failed to start. See the error message(s) above...
5、ifconfig -a
bond0 Link encap:EthernetHWaddr 00:21:5E:52:EF:D4
inet addr:192.168.3.15Bcast:192.168.3.255Mask:255.255.255.0
inet6 addr: fe80::221:5eff:fe52:efd4/64 Scope:Link
UP BROADCAST RUNNING MASTER MULTICASTMTU:1500Metric:1
RX packets:271254 errors:0 dropped:0 overruns:0 frame:0
TX packets:205463 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:61415123 (58.5 MiB)TX bytes:38698454 (36.9 MiB)
eth0 Link encap:EthernetHWaddr 00:21:5E:52:EF:D4
UP BROADCAST RUNNING SLAVE MULTICASTMTU:1500Metric:1
RX packets:213311 errors:0 dropped:0 overruns:0 frame:0
TX packets:205463 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:46336164 (44.1 MiB)TX bytes:38698454 (36.9 MiB)
Interrupt:106 Memory:ce000000-ce012800
eth1 Link encap:EthernetHWaddr 00:21:5E:52:EF:D4
UP BROADCAST RUNNING SLAVE MULTICASTMTU:1500Metric:1
RX packets:57943 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:15078959 (14.3 MiB)TX bytes:0 (0.0 b)
Interrupt:169 Memory:ca000000-ca012800
lo Link encap:Local Loopback
inet addr:127.0.0.1Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNINGMTU:16436Metric:1
RX packets:26474 errors:0 dropped:0 overruns:0 frame:0
TX packets:26474 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:2083533 (1.9 MiB)TX bytes:2083533 (1.9 MiB)
sit0 Link encap:IPv6-in-IPv4
NOARPMTU:1480Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b)TX bytes:0 (0.0 b)
页:
[1]