Oracle "Tns-12535:tns: Operation timed out" failure was lifted.

System Environment: Oel6.5_x86

Database version:Oracle 11g 11.2.0.3.0

Client environment: Windows7 Ultimate Edition x86_64

First, [failure phenomenon]

"Oracle Client" is installed on clients, run "tnsping enmoedu" through CMD, detect connection to Oracle database server, system occurs tns-12535:tns: Operation Timeout

Second, [Fault status]

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/3F/77/wKiom1PJSivDvKdIAAPP2Lni97Q905.jpg "title=" Tn2535:tns: Operation timed out. png "alt=" wkiom1pjsivdvkdiaapp2lni97q905.jpg "/>

The following is the error feedback information in cmd:

c:\users\enmoedu>tnsping enmoedu

TNS Ping Utility for 32-bit windows:version 11.2.0.3.0-production on 1 August-July-

2014 22:11:39

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

Used parameter file:

C:\app\Enmoedu\product\11.2.0\client_1\network\admin\sqlnet.ora

Used the TNSNames adapter to resolve aliases

Attempt to connect (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.1

6.53.131) (PORT = 1521))) (Connect_data = (service_name = enmoedu)))

Tns-12535:tns: Operation timed out

Iii. [cause of malfunction]

Because the firewall is not shutting down or the firewall is not open on the Oracle database server, port 1521 is used for Oracle Listener service communication.

Iv. [Fault handling]

Close the iptables firewall or open 1521 port on the Oracle database server. Random fault phenomenon is lifted.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/3F/77/wKioL1PJTHzw8vxaAAPU9LqnU58675.jpg "title=" tns:12535 failed to release. png "alt=" wkiol1pjthzw8vxaaapu9lqnu58675.jpg "/>

--end--

Colonel Li Jian

2017.7.18

This article is from the "Colonel Li Jian" blog, please be sure to keep this source http://shangxiao.blog.51cto.com/8671064/1440108

Oracle "Tns-12535:tns: Operation timed out" failure was lifted.