Database hanging/crashing repeatedly
Date: Wed, 5 Oct 2011 23:39:10 -0500
Message-ID: <6548C7B531E1364BAE8F77112F31A119A8C5EC81_at_MSPM1BMSGM22.ent.core.medtronic.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 05 2011 - 23:39:10 CDT