|Lost ASH report [message #629561]
||Wed, 10 December 2014 23:11
Registered: June 2008
I received below error message in the alert log several times. after that I cannot connect to my database. database cannot allow new connections.
Fatal NI connect error 12170.
TNS for Solaris: Version 18.104.22.168.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 22.214.171.124.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 126.96.36.199.0 - Production
Time: 08-DEC-2014 13:06:09
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.30.14.137)(PORT=51191))
WARNING: inbound connection timed out (ORA-3136)
I did reboot the server then database was up.
I try to find root case of this failure then execute AWR report but same period of log lost on the server.
You can show below.
21756 08 Dec 2014 09:00 1
21757 08 Dec 2014 10:00 1
21758 08 Dec 2014 11:00 1
21760 08 Dec 2014 17:09 1
21761 08 Dec 2014 18:00 1
21762 08 Dec 2014 19:00 1
I found above period of active session history data from a trace file.
I loaded this data to a table but cannot show report by user friendly like AWR html format.
How to know what operation executed on the server then block new connections on the server?