记一次离奇的TNS-12545TNS-12560TNS-00515 - 数据库编程

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

#最终，此题暂时无解，没有找到原因，不影响自启动而已。

记一次离奇的TNS-12545TNS-12560TNS-00515(三)