最近reportDB监听无法随系统自启动，现象比较怪异。因为该服务器上的另一个实例的监听可以正常启动，这个不能自启动实例的监听手动启动又是正常的。因此记下这次离奇暂未找到原因的故障。
1、故障现象
Starting CRON daemondone
Oracle 10g auto start/stop
Startup "USMTHLY" listener.
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-JUL-2014 17:05:49
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Starting /users/oracle/OraHome10g/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /users/oracle/OraHome10g/network/admin/listener.ora
Log messages written to /users/oracle/OraHome10g/network/log/listener_usmthly.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.101.1.106)(PORT=1520)))
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
#上面的错误信息了来自系统启动日志，同样出现在该实例的监听器日志里。
#故障环境
oracle@sysreportDB:/users/oracle> cat /etc/issue
Welcome to SUSE Linux Enterprise Server 10 SP4 (x86_64) - Kernel \r (\l).
oracle@sysreportDB:/users/oracle> sqlplus -v
SQL*Plus: Release 10.2.0.3.0 - Production
#服务器启动后，检查数据库实例，2个实例都已成功启动
oracle@sysreportDB:~> ps -ef | grep pmon | grep -v grep
oracle 4916 1 0 Jul08 ? 00:00:00 ora_pmon_USMTHLY
oracle 5605 1 0 Jul08 ? 00:00:00 ora_pmon_USBO2
oracle@sysreportDB:~> ps -ef | grep lsnr| grep -v grep #仅仅只有usbo2的监听被启动
oracle 5597 1 0 Jul09 ? 00:00:00 /users/oracle/OraHome10g/bin/tnslsnr listener_USBO2 -inherit
2、故障分析
oracle@sysreportDB:~> oerr tns 12545
12545, 00000, "Connect failed because target host or object does not exist"
// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name. Ensure that the
// executable for the server exists (perhaps "oracle" is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.
oracle@sysreportDB:~> oerr tns 12560
12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors. For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.
oracle@sysreportDB:~> oerr tns 00515
00515, 00000, "Connect failed because target host or object does not exist"
// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name. Ensure that the
// executable for the server exists (perhaps "oracle" is missing.)
#上面的三个错误号描述信息表明该故障与主机名或IP地址有关，需要检查是否为有效的IP或主机名
#下面查看监听器及TNSNAMES的配置
oracle@sysreportDB:/users/oracle/OraHome10g/network/admin> more listener.ora
SID_LIST_LISTENER_USMTHLY =
(SID_LIST =
(SID_DESC =
(sid_name=USMTHLY)
(oracle_home = /users/oracle/OraHome10g)
)
)
LISTENER_USMTHLY =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOC