Detailed explanation of ORA 12170 TNS connection timeout solution

1. Start--Program--oracle--Configuration and Migration Tools--Net Manager--Native--Service Name-ora11 (this is my private server) Change the host name at the bottom right to 192.168. 1.102

2. Start--Program--oracle--Configuration and Migration Tools--Net Manager--Local--Listener--Also change the host name at the bottom right to 192.168. 1.102

Reconnect reported another error

ora-12541: TNS: No listener
1. cmd--services. msc--A service starting with Oracle and ending with TNListener starts it
2. Modify registry cmd-regedit if not already started
Find HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/OracleTnsListener
Add a path to the string imagepath with a value of TNSLSNR. exe
My is D:/Oracle/Administrator/product/11. 1.0/db_1/BIN/TNSLSNR
I can finally connect, happy!

"ORA-12170: TNS: Connection timeout" appears if it works properly on this machine, but to other machines in the LAN. "ORA-12170: TNS: Connection timeout"

Solution:

1. cmd-----ping ip Address Check the network problem and see if ping can pass

2. cmd--tnsping ip address (or the instance name of the server SID) If "TNS-12535: Operation Timeout" is reported, the server-side firewall may not be closed

3. cmd--netstat--na Check to see if port 1521 is turned off, if you turn off port 1521 as an exception in the firewall settings in Windows XP

4. cmd--lsnrctl status lsnrctl is the abbreviation of listener-control listener to see the status of the listener