Remember a bizarre TNS-12545 TNS-12560 TNS-00515, tns-12545tns-12560

Remember a bizarre TNS-12545 TNS-12560 TNS-00515, tns-12545tns-12560

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 oracle @ sysreportDB:/users/oracle> cat/etc/issueWelcome to SUSE Linux Enterprise Server 10 SP4 (x86_64)-Kernel \ r (\ l ). oracle @ sysreportDB:/users/oracle> sqlplus-vSQL * Plus: Release 10.2.0.3.0-Production # check the database instance after the server is started. Both instances have successfully started oracle @ sysreportDB: ~> 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_USBO2oracle @ sysreportDB: ~> 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

Oracle @ sysreportDB: ~> 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. oracle @ sysreportDB: ~> 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. oracle @ SysreportDB: ~> 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. You need to check whether the fault is a valid IP address or host name # Check the listener and TNSNAMES configuration oracle @ sysreportDB 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) oracle @ sysreportDB: /users/oracle/OraHome10g/network/admin> more tnsnames. oraUSMTHLY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.101.1.106) (PORT = 1520) (CO NNECT_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. oracle @ sysreportDB: ~> 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 :: 3 ipv6-allhosts10.101.1.106 sysreportDB.2goasp.com sysreportDB oracle @ sysreportDB: ~> HostnamesysreportDB # Author: Leshami # Blog: Workshop> 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 colli Sions: 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, manually No exception occurred when starting the listener. oracle @ sysreportDB:/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 writt En 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:1 0: 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 ins Tance (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/8oracle @ sysreportDB: /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.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

TNS-12545: because the target host or object does not exist, connection failure I am a client, other computers can connect to the server, I can not, why?

Ping the server first to see if the network is connected, and check whether the database versions of the client and server are consistent.

Run the lsnrctl start command to start oracle listening, but the following error occurs. How can I help you?

Is the IP address 192.168.1.101 incorrect? Change to the correct IP address.
In addition to modifying listener. ora, you also need to modify the IP address in tnsnames. ora.