One time bizarre TNS-12545 TNS-12560 TNS-00515

Recently, reportdb listeners cannot be started with the system, which is a strange phenomenon. Because the listener of another instance on the server can be started normally, it is normal that the listener of the Instance cannot be started manually. Therefore, write down the unexpected fault that has not been found.

 

1. Fault

Starting cron daemondoneoracle 10g auto start/stopstartup "usmthly" listener. LSNRCTL for Linux: Version 10.2.0.3.0-production on 08-jul-2014 17: 05: 49 copyright (c) 1991,200 6, Oracle. all rights reserved. starting/users/Oracle/orahome10g/bin/tnslsnr: Please wait... tnslsnr for Linux: Version 10.2.0.3.0-productionsystem parameter file is/users/Oracle/orahome10g/Network/admin/listener. oralog Messa GES written to/users/Oracle/orahome10g/Network/log/listener_usmthly.logerror 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 # the error message above comes from the system The system startup Log also appears in the listener log of the instance. # Fault Environment [email protected]:/users/Oracle> CAT/etc/issuewelcome to SuSE Linux Enterprise Server 10 SP4 (x86_64)-kernel \ r (\ L ). [email protected]:/users/Oracle> sqlplus-vsql * Plus: Release 10.2.0.3.0-production # check the database instance after the server is started, [email protected]: ~> PS-Ef | grep pmon | grep-V greporacle 4916 1 0 jul08? 00:00:00 ora_pmon_usmthlyoracle 5605 1 0 jul08? 00:00:00 ora_pmon_usbo2 [email protected]: ~> PS-Ef | grep lsnr | grep-V grep # Only usbo2 listeners are started Oracle 5597 1 0 jul09? 00:00:00/users/Oracle/orahome10g/bin/tnslsnr listener_usbo2-inherit

2. Fault Analysis

[Email protected]: ~> Oerr TNS 1254512545,000 00, "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. [email protected]: ~> Oerr TNS 1256012560,000 00, "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. [email Protected]: ~> Oerr TNS 0051500515,000 00, "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 .) # above The description of the three error numbers indicates that the fault is related to the host name or IP address. Check whether the fault is a valid IP address or host name. # view the listener and tnsnames configuration [email protected] below: /users/Oracle/orahome10g/Network/admin> More listener. orasid_list_listener_usmthly = (sid_list = (sid_desc = (sid_name = usmthly) (ORACLE_HOME =/users/Oracle/orahome10g ))) listener_usmthly = (description_list = (description = (address_list = (address = (Protocol = TCP) (host = 10.101.1.106) (Port = 1520) sid_list _ Listener_usbo2 = (sid_list = (sid_desc = (sid_name = usbo2) (ORACLE_HOME =/users/Oracle/orahome10g ))) listener_usbo2 = (description_list = (description = (address_list = (address = (Protocol = TCP) (host = 10.101.1.106) (Port = 1504) [email protected]: /users/Oracle/orahome10g/Network/admin> More tnsnames. orausmthly = (description = (address = (Protocol = TCP) (host = 10.101.1.106) (Port = 1520) (Conn Ect_data = (SERVICE_NAME = usmthly) usbo2 = (description = (address = (Protocol = TCP) (host = 10.101.1.106) (Port = 1504 )) (CONNECT_DATA = (SERVICE_NAME = usbo2) # From the configuration above, the configuration is normal. # Check the host and IP information of the Local Machine. From the description below, the host configuration is normal [email protected]: ~> More/etc/hosts127.0.0.1 localhost # Special IPv6 addresses: 1 localhost ipv6-localhost: 0 ipv6-loopbackfe00: 0 ipv6-localnetff00: 1 ipv6-mcastprefixff02: 2 ipv6-allnodesff02 :: ipv6-allhosts10.101.1.106 sysreportdb.2goasp.com sysreportdb [email protected]: ~> Hostnamesysreportdb # Author: leshami # blog: Protected]:/var/log> ifconfigeth0 link encap: Ethernet hwaddr 00: 0C: 29: 70: 82: 63 Inet ADDR: 10.101.1.106 bcast: 10.201.1.255 mask: 255.255.255.0 up broadcast running Multicast MTU: 1500 Metric: 1 RX packets: 5763651 errors: 0 dropped: 0 overruns: 0 frame: 0 TX packets: 802254 errors: 0 dropped: 0 overruns: 0 carrier: 0 Collis Ions: 0 txqueuelen: 1000 RX Bytes: 8102327746 (7726.9 MB) TX Bytes: 88597013 (84.4 MB) lo link encap: local loopback # A loop can work normally for Tx, RX Inet ADDR: 127.0.0.1 mask: 255.0.0.0 up loopback running MTU: 16436 Metric: 1 RX packets: 92972 errors: 0 dropped: 0 overruns: 0 frame: 0 TX packets: 92972 errors: 0 dropped: 0 overruns: 0 carrier: 0 Collisions: 0 txqueuelen: 0 RX Bytes: 4993723 (4.7 MB) TX Bytes: 4993723 (4.7 MB) # Try to manually start the listener and start it manually An error occurred while listening. [email protected]:/var/log> LSNRCTL start listener_usmthlylsnrctl for Linux: Version 10.2.0.3.0-production on 08-jul-2014 17: 10: 49 copyright (c) 1991,200 6, Oracle. all rights reserved. starting/users/Oracle/orahome10g/bin/tnslsnr: Please wait... tnslsnr for Linux: Version 10.2.0.3.0-productionsystem parameter file is/users/Oracle/orahome10g/Network/admin/listener. oralog messages written To/users/Oracle/orahome10g/Network/log/listener_usmthly.loglistening on: (description = (address = (Protocol = TCP) (host = sysreportdb.2goasp.com) (Port = 1520 ))) connecting to (description = (address = (Protocol = TCP) (host = sysreportdb.2goasp.com) (Port = 1520) Status of the listener ---------------------- alias listener_usmthlyversion tnslsnr for Linux: version 10.2.0.3.0-productionstart date 08-jul-2014 17: 10: 50 uptime 0 days 0 HR. 0 min. 0 sectrace level offsecurity on: Local OS authenticationsnmp offlistener parameter file/users/Oracle/orahome10g/Network/admin/listener. oralistener log file/users/Oracle/orahome10g/Network/log/listener_usmthly.loglistening endpoints summary... (description = (address = (Protocol = TCP) (host = sysreportdb.2goasp.com) (Port = 1520) Services summary... service "usmthly" has 1 insta NCE (s ). instance "usmthly", status unknown, has 1 handler (s) for this service... the command completed successfully # The test above shows that the listener can be started normally, that is, the Listener Configuration should be OK. # Another point is that there is a 127.0.0.2 loop in the system startup log. I don't know how to have 127.0.0.2setting up Network Interfaces: lo IP Address: 127.0.0.1/8 IP Address: 127.0.0.2/8 [email protected]:/var/log> Ping 127.0.0.2 # loop 127.0.0.2 okping 127.0.0.2 (127.0.0.2) 56 (84) bytes of data.64 bytes from 127.0.0.0.2: icmp_seq = 1 TTL = 64 time = 0.034 MS

3. troubleshooting

# Sqlnet trace is a poor solution to the above problem. # Next, we try to replace the IP address in the Listener Configuration file with the host name. # Either of the following two methods can start the listener with the system startup, one is the host name, one is full host name # 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 ))))) # Happy, view the system log, sweat, there are still errors, this error is the TNS-12543, the target host is not reachable. # If there are any abnormal characters in the hosts file, try to recreate the hosts file. The error message after reconstruction is as follows. Starting cron daemondoneoracle 10g auto start/stopstarting Oracle10g: startup "usmthly" listener. LSNRCTL for Linux: Version 10.2.0.3.0-production on 09-jul-2014 17: 15: 47 copyright (c) 1991,200 6, Oracle. all rights reserved. starting/users/Oracle/orahome10g/bin/tnslsnr: Please wait... tnslsnr for Linux: Version 10.2.0.3.0-productionsystem parameter file is/users/Oracle/orahome10g/Network/admin/L Istener. oralog messages written to/users/Oracle/orahome10g/Network/log/listener_usmthly.loglistening 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 # In the end, this question is not resolved for the time being. No reason is found and it does not affect self-startup.

4. Summary
A, for the TNS-12545, The TNS-00515 should first consider whether the use of the appropriate IP, host name, should check the server host file, network configuration, etc.
B. Check whether the listener and tnsnames are correctly configured after step.
C. Check and analyze the listener logs for the above errors.
D. For client TNS-12545, TNS-00515, etc., consider whether the client can convert the host to the corresponding IP (client tnsnames. ora when using the host name)
E. For Oracle network configuration, refer to: http://blog.csdn.net/leshami/article/category/828434