ORA-12170 TNS connection timeout

1. Start ---- program ----- Oracle ------ configuration and porting tool ----- net manager ---- local ---- service name --- ora11 (this is my dedicated server) change the host name on the Right To 192.168.1.102

2. Start ---- program ----- Oracle ------ configuration and porting tool ----- net manager ---- local ---- listener --- change the host name on the Right To 192.168.1.102.

Another error is reported when the connection is reconnected.

Ora-12541: TNS: No listener
1. CMD --- services. msc ---- start a service starting with tnlistener starting with Oracle
2. If it has not been started, modify the Registry cmd -- regedit
Find HKEY_LOCAL_MACHINE/system/CurrentControlSet/services/oracletnslistener
The imagepathvalue of a batch is the path of tnslsnr.exe.
My options are D:/Oracle/Administrator/product/11.1.0/db_1/bin/tnslsnr.
Finally, you can connect!

If the machine can be used normally, but to other machines in the LAN appears "ORA-12170: TNS: Connection timeout
Solution:

1. CMD ----- ping the IP address to view network problems and check whether the Ping is successful.

2. CMD ----- tnsping IP address (or server instance name Sid) If "TNS-12535: Operation timeout" is reported, it may be that the server firewall is not disabled

3. Run cmd ---- netstat-Na to check whether port 1521 is disabled. If the firewall settings in Windows XP are disabled, set port 1521 as an exception.

4. CMD ---- LSNRCTL status LSNRCTL is the abbreviation of the listener-control listener. You can view the status of the listener.

1. Start ---- program ----- Oracle ------ configuration and porting tool ----- net manager ---- local ---- service name --- ora11 (this is my dedicated server) change the host name on the Right To 192.168.1.102

2. Start ---- program ----- Oracle ------ configuration and porting tool ----- net manager ---- local ---- listener --- change the host name on the Right To 192.168.1.102.

Another error is reported when the connection is reconnected.

Ora-12541: TNS: No listener
1. CMD --- services. msc ---- start a service starting with tnlistener starting with Oracle
2. If it has not been started, modify the Registry cmd -- regedit
Find HKEY_LOCAL_MACHINE/system/CurrentControlSet/services/oracletnslistener
The imagepathvalue of a batch is the path of tnslsnr.exe.
My options are D:/Oracle/Administrator/product/11.1.0/db_1/bin/tnslsnr.
Finally, you can connect!

If the machine can be used normally, but to other machines in the LAN appears "ORA-12170: TNS: Connection timeout
Solution:

1. CMD ----- ping the IP address to view network problems and check whether the Ping is successful.

2. CMD ----- tnsping IP address (or server instance name Sid) If "TNS-12535: Operation timeout" is reported, it may be that the server firewall is not disabled

3. Run cmd ---- netstat-Na to check whether port 1521 is disabled. If the firewall settings in Windows XP are disabled, set port 1521 as an exception.

4. CMD ---- LSNRCTL status LSNRCTL is the abbreviation of the listener-control listener. You can view the status of the listener.