|
|
1、环境描述：
ORACLE 10.2.0.5
机器内网IP:192.168.3.15
映射了一个外网地址：123.88.123.105
2、/etc/hosts配置如下：
[oracle@tyfx15 admin]$ 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...
|
|
发表于 2014-4-10 20:31:06
楼主
4 
ink