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.