Fatal NI connect error 12170.

The VERSION INFORMATION:
TNS for Solaris: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.4.0 - Production
NT TCP/IP Protocol Adapter for Solaris: Version 11.2.0.4.0 - Production
Time: 09 - MAR - 2018 14:04:05
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: the Operation timed out
Nt secondary err code: 145
Nt OS err code: 0
The Client address: (address=(TCP) PROTOCOL=(HOST=xx. Xx. Xx. Xx) (35629) PORT=)
Oracle11grac will always appear such mistakes in the alarm log, excuse me,, how should solve

CodePudding user response:

Just alert error in it? What is the problem on system?

CodePudding user response:

reference 1st floor baidu_36457652 response:

just alert error in it? What is the problem on system?

System background will quote this but less than the alter of Java. SQL. SQLRecoverableException: IO error: Connection timed out

CodePudding user response:

Lsnectl status listening state

CodePudding user response:

reference baidu_36457652 reply: 3/f

lsnectl status look at listening state

LSNRCTL for Solaris: Version 11.2.0.4.0 - Production on 14 MAR - 2018 18:01:12

Copyright (c) 1991, 2017, Oracle. All rights reserved.

Connecting to (ADDRESS=(TCP) PROTOCOL=(HOST=) (1521) PORT=)
The STATUS of the LISTENER
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.4.0 - Production
Start Date - MAR 12-2018 18:11:56
Uptime 1 hr 23 days. 49 min. 16 SEC
The Trace Level off
Security ON: the Local OS Authentication
SNMP ON
The Listener Parameter File/u01/app/11.2.0/grid/network/admin/Listener. Ora
Listener Log File/u01/app/11.2.0/grid/network/Log/Listener Log
Listening Endpoints Summary...
(the DESCRIPTION=(ADDRESS=(PROTOCOL=ipc) (KEY=LISTENER)))
(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=XXXXXXXXX) (1521) PORT=))
(the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=XXXXXXXXX) (1521) PORT=))
Services the Summary...
Service "+ ASM" has 1 instance (s).
The Instance "+ ASM1," the status READY, from 1 handler (s) for this service...
Service "wind" has 1 instance (s).
The Instance "wind1," the status READY, from 1 handler (s) for this service...
Service "windXDB" has 1 instance (s).
The Instance "wind1," the status READY, from 1 handler (s) for this service...
The command completed successfully
Listening state as if nothing abnormal

CodePudding user response:

See the
http://www.xifenfei.com/2014/09/alert-log-errors-12170-tns-12535tns-00505-operation-timed-out.html

CodePudding user response:

Have changed, and keep the session, don't know the problem can be solved smoothly