as 1 handler(s) for this service...
The command completed successfully
#通过上面的测试可以看出,监听器能够正常启动也就是说监听器的配置应该是OK的。
#另外一点发现,系统启动日志里边有127.0.0.2的环路,不知道怎么会有127.0.0.2
Setting up network interfaces:
lo
lo IP address: 127.0.0.1/8
IP address: 127.0.0.2/8
oracle@sysreportDB:/var/log> ping 127.0.0.2 #环路127.0.0.2 OK
PING 127.0.0.2 (127.0.0.2) 56(84) bytes of data.
64 bytes from 127.0.0.2: icmp_seq=1 ttl=64 time=0.034 ms
3、故障解决
#对于上面的问题实在是百思不得其解,就差使用sqlnet trace。
#下面尝试将监听器配置文件内IP地址使用主机名来代替,竟然成功鸟。
#如下2种方式都可以将监听随系统启动而启动,一个是主机名,一个是full主机名
#LISTENER_USMTHLY =
# (DESCRIPTION_LIST =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = sysreportDB)(PORT = 1520))
# )
# )
# )
LISTENER_USMTHLY =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sysreportDB.2goasp.com)(PORT = 1520))
)
)
)
#高兴之余,查看系统日志,汗,还是有错误,这次的错误是TNS-12543,目标主机不可达。
#怀疑是否hosts文件中是否存在异常字符,于是尝试重建Hosts文件,重建后错误消息依旧如下。
Starting CRON daemondone
Oracle 10g auto start/stop
Starting Oracle10g: Startup "USMTHLY" listener.
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 09-JUL-2014 17:15:47
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
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sysreportDB.2goasp.com)(PORT=1520)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sysreportDB)(PORT=1520)))
TNS-12543: TNS:destination host unreachable
TNS-12560: TNS:protocol adapter error
TNS-00513: Destination host unreachable
Linux Error: 101: Network is unreachable
#最终,此题暂时无解,没有找到原因,不影响自启动而已。