Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve ORA-12170:TNS connect timeout occurred problem in the database. The article is very detailed and has certain reference value. Interested friends must read it!

The company server needs to add hard disk on the weekend, and the application cannot be connected after Monday. ORA-12170:TNS connect timeout occurred

His first reaction was that the monitor wasn't turned on.

1. Tested, connection timeout failed ping

C:\Users\Administrator>tnsping brorcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-Jun-2015 09:45:43

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Parameter files used:

D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

The TNSNAMES adapter has been used to resolve aliases

Try connecting (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.14.147.112)(PORT = 42525)) (CONNECT_DATA = (SERVER = DESICATED) (SERVICE_NAME = brorcl))

TNS-12535: TNS: Operation timeout

2. logged on to the remote server and checked the status of the monitoring

C:\Documents and Settings\Administrator>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-Jun-2015 09:52:54

Copyright (c) 1991, 2010, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date 15-Jun-2015 09:36:02

Uptime 0 days 0 hr. 16 min. 55 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

Listener Log File F:\app\Administrator\product\11.2.0\dbhome_1\network\log\listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC1521ipc)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x3650m3)(PORT=47512)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=47512)))

Services Summary...

Service "BANKASSIST" has 1 instance(s).

Instance "brorcl", status READY, has 1 handler(s) for this service...

Service "CLRExtProc" has 1 instance(s).

Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "brorcl" has 2 instance(s).

Instance "brorcl", status UNKNOWN, has 1 handler(s) for this service...

Instance "brorcl", status READY, has 1 handler(s) for this service...

Service "brorclXDB" has 1 instance(s).

Instance "brorcl", status READY, has 1 handler(s) for this service...

The command completed successfully

It's normal to see monitoring, and it's normal to connect locally.

3. I thought about the local access remote connection is not a firewall problem, so I closed the windows firewall, and sure enough in the remote tnsping can ping through;

4. Result: firewall should be changed, and finally add ip and port of server firewall as exception, application returned to normal.

The above is "How to solve ORA-12170:TNS connect timeout occurred problem in database" All the contents of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.