Database hanging/crashing repeatedly
- From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
- To: "oracle-l-bounce@xxxxxxxxxxxxx" <oracle-l-bounce@xxxxxxxxxxxxx>
- Date: Wed, 5 Oct 2011 23:39:10 -0500
One of our databases has been crashing in the same fashion repeatedly and
sounds like the root cause is the same but not sure what exactly is causing it.
Suddenly the database starts hanging. No user can login and gets the error
(ORA-03135: connection lost contact). When I try to login as sysdba it hangs
and never gets connected to the database. Grid control monitoring receives the
error (Failed to connect to database instance: ORA-03135: connection lost
contact (DBD ERROR: OCISessionBegin).
On each occasion of such hanging(crash) we had to reboot the server(database
host). It happened on Sept 23, 2011 and then it happened on Oct 05, 2011 within
two weeks.
When we bounced the database there were some WARNING in alert log. => WARNING:
AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
Warning reported in the alert log before the hanging => WARNING: inbound
connection timed out (ORA-3136)
Database version: 10.2.0.4
Server: Sun M3000 (SunOS 5.10 Generic_142900-13 sun4u sparc
SUNW,SPARC-Enterprise)
Memory: 16GB
Any tips to investigate the root cause will be appreciated.
Thanks,
Ashoke
[CONFIDENTIALITY AND PRIVACY NOTICE]
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is private, privileged, confidential or exempt
from disclosure under applicable law. If you are not the intended recipient or
it appears that this mail has been forwarded to you without proper authority,
you are notified that any use or dissemination of this information in any
manner is strictly prohibited. In such cases, please delete this mail from your
records.
To view this notice in other languages you can either select the following link
or manually copy and paste the link into the address bar of a web browser:
http://emaildisclaimer.medtronic.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
