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.