WINDOWS: TNS-12535 Unable To Connect To Remote Database Using Specific Applications.

(Doc ID 341216.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Net Services - Version 9.0.1.4.0 to 10.2.0.4 [Release 9.0.1 to 10.2]
Information in this document applies to any platform.
Checked for relevance on 8-MAY-2017.


Symptoms

The following error message occurs trying to connect to a remote database using Sqlplus (Both command-line and GUI), JDeveloper 9 and 10, and third party products such as Toad from Quest Software.  However, you can connect to the remote instance using Enterprise Manager (EM) from the same Windows XP workstation.

Error:

ORA/TNS-12535: TNS:operation timed out

Symptoms:

      TNSPING command fails with the TNS-12535 error:

C:\oracle\ora92\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.1.101)(PORT = 1521))) (CONNECT_DATA = (SID = ORCL) (SERVER = DEDICATED)))
TNS-12535: TNS:operation timed out

Verified the issue by the trace file Oracle Net Client trace file, 'cli_3672_1.trc' which
displays the following error stack while trying to connect to the the address descriptor:

Calling address:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.X.XXX)(PORT=1521)))

(CONNECT_DATA=(SID=ORCL)(SERVER=DEDICATED)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplusw.exe)(HOST=USERPC100)(USER=john.doe))))


Error stack returned:

[09-NOV-2005 17:49:28:998] nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60,
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0

...
[09-NOV-2005 17:49:28:998] nscall: error exit
[09-NOV-2005 17:49:28:998] nioqper: error from nscall
[09-NOV-2005 17:49:28:998] nioqper: nr err code: 0
[09-NOV-2005 17:49:28:998] nioqper: ns main err code: 12535
[09-NOV-2005 17:49:28:998] nioqper: ns (2) err code: 12560
[09-NOV-2005 17:49:28:998] nioqper: nt main err code: 505
[09-NOV-2005 17:49:28:998] nioqper: nt (2) err code: 60
[09-NOV-2005 17:49:28:998] nioqper: nt OS err code: 0
[09-NOV-2005 17:49:28:998] niomapnserror: entry
[09-NOV-2005 17:49:28:998] niqme: entry
[09-NOV-2005 17:49:28:998] niqme: reporting NS-12535 error as ORA-12535
[09-NOV-2005 17:49:28:998] niqme: exit
[09-NOV-2005 17:49:28:998] niomapnserror: returning error 12535
[09-NOV-2005 17:49:28:998] niomapnserror: exit
[09-NOV-2005 17:49:28:998] niotns: Couldn't connect, returning 12535

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms