Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-12535: TNS:operation timed out - happens on App Server

ArthurnasiusJul 17 2019 — edited Jul 30 2019

Hi, i have an issue i need some guidance on. App server connection to DB server time out. The sqlnet.log file on the DB server shows no issues which shows that on the database side things are fine.

on the app server side the sqlnet.log file entries are below.

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 06-JUL-2019 23:24:21

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 07-JUL-2019 00:24:22

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 07-JUL-2019 01:24:21

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 08-JUL-2019 17:24:21

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 09-JUL-2019 22:04:23

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 10-JUL-2019 23:04:23

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 11-JUL-2019 22:02:48

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: <unknown>

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 12-JUL-2019 22:24:23

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 13-JUL-2019 23:24:23

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 14-JUL-2019 00:04:23

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 15-JUL-2019 22:04:23

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:

        TNS for Solaris: Version 10.2.0.4.0 - Production

        TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.4.0 - Production

  Time: 16-JUL-2019 22:44:24

  Tracing not turned on.

  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: 145

    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.128.0.14)(PORT=1524))

I need help in solving this issue.

Comments
Post Details
Added on Jul 17 2019
57 comments
2,811 views