Based on ORA-12170 TNS connection timeout solution detailed

Updated: June 11, 2013 08:57:26 Author:

This article is a detailed analysis of the ORA-12170 TNS connection timeout solution, the need for a friend's reference

1. The start - programs - -- -- -- -- -- -- -- -- -- oracle - configuration and migration tool -- -- -- -- -- Net Manager - local service naming - ora11 (this is my dedicated server) on the right side of the host name into 192.168.1.102 below

2. The start - programs - -- -- -- -- -- -- -- -- -- oracle - configuration and migration tool -- -- -- -- -- Net Manager - local - the listener - the same right below the hostname to 192.168.1.102

Reconnect and report another error

ora-12541:TNS: no listener 1.cmd-- services.msc---- Start the service that starts with Oracle and ends with TNListener 2. If it's not activated yet, Modify the registry CMD - regedit find HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/OracleTnsListener Add a string value for the TNSLSNR imagepath. Exe is the path to my D: / Oracle/Administrator/product / 11.1.0 db_1 / BIN/TNSLSNR finally can be connected, happy! If it can be used normally on the local machine, but to other machines in the LAN, "ORA-12170:TNS: Connection timeout Solution:

1.cmd-----ping ip address Check whether the network can be pinged successfully

cmd-----tnsping ip address (or SID of the server instance name) If TNS-12535: Operation timed out is displayed, the firewall on the server may not be disabled

3.cmd----netstat -na Check whether port 1521 is disabled. If port 1521 is disabled in the firewall Settings of Windows XP, set port 1521 as an exception

4.cmd----lsnrctl status lsnrctl is an abbreviation of the listener-control listener. Check the listener status

Articles you may be interested in:

The Oracle database space is used up to expand the space

This article mainly introduces the Oracle database space is full of space expansion methods, very good, with reference value needs of friends can refer to
2018-02-02
Oracle database table backup import and export dmp mode and step pit records

dmp is the database exported file, used to back up the database, generally with exp command to export, import with imp command is to restore the database, the following article mainly introduces the Oracle database table backup import and export dmp way and step pit records, the need of friends can refer to the next
2022-07-07
Expansion of oracle database tablespaces

This article mainly introduces the problem of oracle database tablespace expansion, has a good reference value, I hope to help you. If there are mistakes or incomplete areas, please feel free to comment
2023-02-02
Oracle Database ORA 54013 error fix

ORA 54013 does not allow INSERT operations on virtual columns, a new feature in Oracle 11. Next through this article to introduce the oracle database ORA 54013 error solution, very good with reference value, interested friends take a look at it
2016-10-10
Oralce data import (SYSTEM.PROC_AUDIT) Troubleshooting method

Database A opens the audit, but when it is imported to database B, database B audit is not opened, there is no SYSTEM.PROC_AUDIT object in the database, this paper will solve this problem, the need of friends can refer to the next
2012-12-12
Oracle creates absolute dry goods for users and table Spaces (Favorite)

Oracle database often used in the JAVAEE project, as a background program developer, master how to create users in Oracle, table space is a necessary skill, the following article mainly introduces you about Oracle to create users and table space related information, need friends can refer to the next
2022-09-09
oracle iSQL*PLUS configuration Settings

iSQL*PLUS is a new function provided by ORACLE 9i, which is a Web form of SQL*PLUS (ORACLE 11g is no longer supported). It is designed based on a three-layer structure, and the friends who need it can understand it
2012-12-12
Example Description of Oracle blockingblocked

This article mainly introduces Oracle blocking (blockingblocked), the need for friends can refer to the next
2014-07-07
Linux system (X64) Install Oracle11g complete installation graphic tutorial attached basic operations

Because of the project needs, need to install Oracle 11g in the 64-bit linux system, checked a lot of content on the Internet, combined with their own practical experience, finally installed successfully, recorded, share to the comrades in need, do not thank ha! ^_^
2014-08-08
oracle database sql optimization summary

Some of their own optimization of oracle sql summary, special share under the convenience of the need for friends
2013-08-08