ORA-12170/TNS-12535 Timeout Errors while attempting to Connect To Remote Database Using SQL*Plus or Any other tool. (Doc ID 1392646.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Net Services - Version 8.0.6.0 to 12.1.0.2 [Release 8.0.6 to 12.1]
Information in this document applies to any platform.

Symptoms

SQLPLUS and TNSPING command fails with the TNS-12535 error:


Verified the issue by the client sqlnet.log and trace file Oracle Net Client trace file, 'sqlnet_3640_1.trc'

1. Client sqlnet.log


Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 05-JAN-2012 12:56:25
Tracing to file: C:\oracle\product\10.2.0\client_1\NETWORK\trace\sqlnet_3640_1.trc
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
Client address: <unknown>




2. Client sqlnet trace (sqlnet_3640_1.trc)


[05-JAN-2012 12:56:25:480] ntt2err: entry
[05-JAN-2012 12:56:25:480] ntt2err: soc 264 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0
[05-JAN-2012 12:56:25:480] ntt2err: exit
[05-JAN-2012 12:56:25:589] nttcni: exit
[05-JAN-2012 12:56:25:589] nttcon: exit
[05-JAN-2012 12:56:25:589] 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
[05-JAN-2012 12:56:25:589] nsopen: unable to open transport
[05-JAN-2012 12:56:25:589] nsmfr: 1644 bytes at 0x1194b30
[05-JAN-2012 12:56:25:589] nsmfr: 736 bytes at 0x1152f08
[05-JAN-2012 12:56:25:589] nladget: entry
[05-JAN-2012 12:56:25:589] nladget: exit
[05-JAN-2012 12:56:25:589] nsmfr: 212 bytes at 0x119fef8
[05-JAN-2012 12:56:25:589] nladtrm: entry
[05-JAN-2012 12:56:25:589] nladtrm: exit
[05-JAN-2012 12:56:25:589] nioqper: error from nscall
[05-JAN-2012 12:56:25:589] nioqper: ns main err code: 12535
[05-JAN-2012 12:56:25:589] nioqper: ns (2) err code: 12560
[05-JAN-2012 12:56:25:589] nioqper: nt main err code: 505
[05-JAN-2012 12:56:25:589] nioqper: nt (2) err code: 60
[05-JAN-2012 12:56:25:589] nioqper: nt OS err code: 0
[05-JAN-2012 12:56:25:589] niomapnserror: entry
[05-JAN-2012 12:56:25:589] niqme: entry
[05-JAN-2012 12:56:25:589] niqme: reporting NS-12535 error as ORA-12535
[05-JAN-2012 12:56:25:589] niqme: exit
[05-JAN-2012 12:56:25:589] niomapnserror: exit
[05-JAN-2012 12:56:25:589] niotns: Couldn't connect, returning 12170
[05-JAN-2012 12:56:25:589] nioqer: entry
[05-JAN-2012 12:56:25:589] nioqce: entry
[05-JAN-2012 12:56:25:589] nioqce: exit
[05-JAN-2012 12:56:25:589] nioqer: exit
[05-JAN-2012 12:56:25:589] niotns: exit
[05-JAN-2012 12:56:25:589] nsbrfr: nsbfs at 0x10e6800, data at 0x118b170.
[05-JAN-2012 12:56:25:589] nigtrm: Count in the NI global area is now 0
[05-JAN-2012 12:56:25:589] nrigbd: entry
[05-JAN-2012 12:56:25:589] nrigbd: exit
[05-JAN-2012 12:56:25:589] nigtrm: Count in the NL global area is now 0
[05-JAN-2012 12:56:25:589] nlse_term_audit: entry
[05-JAN-2012 12:56:25:589] nlse_term_audit: exit




If try SQLPLUS and TNSPING from the database server using listener it works fine.


Changes

No changes, This is a new installation of 11.2.

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