Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

[suse-oracle] DB shutdown abruptly

Seah Hong Yee

2006-04-13



I have a period of time where the db suddenly shutdown for no apparent
reason.
The following are the logs from alert log.

Can any one tell me what error this is ?

Thu Apr 13 21:00:25 2006
Private_strands 3 at log switch
Thread 1 advanced to log sequence 6989
 Current log# 1 seq# 6989 mem# 0:
/u01/app/oracle/oradata/compiere/redo01.log
Thu Apr 13 22:00:03 2006
Private_strands 3 at log switch
Thread 1 advanced to log sequence 6990
 Current log# 2 seq# 6990 mem# 0:
/u01/app/oracle/oradata/compiere/redo02.log
Thu Apr 13 22:00:23 2006
Starting background process EMN0
EMN0 started with pid=26, OS id=27143
Thu Apr 13 22:00:23 2006
Shutting down instance: further logons disabled
Thu Apr 13 22:00:24 2006
Stopping background process CJQ0
Thu Apr 13 22:00:24 2006
Stopping background process QMNC
Thu Apr 13 22:00:26 2006
Stopping background process MMNL
Thu Apr 13 22:00:27 2006
Stopping background process MMON
Thu Apr 13 22:00:28 2006
Shutting down instance (immediate)
License high water mark = 150
Thu Apr 13 22:00:28 2006
Job queue slave processes stopped
Thu Apr 13 22:05:36 2006
Active call for process 15619 user 'oracle' program 'oracle@(protected)
(S001)'
SHUTDOWN: waiting for active calls to complete.
Thu Apr 13 22:20:04 2006
KTSMG_UPDATE_MQL(): MMNL absent for 1205 secs; Foregrounds taking over
Thu Apr 13 22:32:58 2006
Shutting down instance (abort)
License high water mark = 150
Instance terminated by USER, pid = 28143
Running with 1 strand for Non-Enterprise Edition
Running without dynamic strand for Non-Enterprise Edition
Thu Apr 13 22:32:59 2006
Starting ORACLE instance (normal)
Thu Apr 13 22:32:59 2006
Starting ORACLE instance (normal)
Thu Apr 13 22:32:59 2006
Running with 1 strand for Non-Enterprise Edition
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 1


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.