Home » Server Options » RAC & Failsafe » Shutdown abort Instance (Oracle10g,linux)
Shutdown abort Instance [message #349384] Sun, 21 September 2008 01:04 Go to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Hi ,
I Have installed Oracle 10g RAC , it's working properly now but it's not stable , every says i have a shutdown for each instance, and there is no reason for this shutdown in alret.log file .

here is part of alert.log file :

Current log# 1 seq# 15 mem# 0: +DISKGRP1/ctmsdb/redo01.log
Thread 1 advanced to log sequence 16
Current log# 2 seq# 16 mem# 0: +DISKGRP1/ctmsdb/redo02.log
Sun Aug 17 11:50:21 2008
Shutting down instance (abort)
License high water mark = 2
Instance terminated by USER, pid = 8677
Sun Aug 17 11:53:11 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0

it's shuting down and restarting again ,
here is report of crs_stat -v output for one instance :

[oracle@db1 ~]$
[oracle@db1 ~]$ NAME=ora.ctmsdb.ctmsdb2.inst
[oracle@db1 ~]$ TYPE=application
[oracle@db1 ~]$ RESTART_ATTEMPTS=5
[oracle@db1 ~]$ RESTART_COUNT=5
[oracle@db1 ~]$ FAILURE_THRESHOLD=0
[oracle@db1 ~]$ FAILURE_COUNT=0
[oracle@db1 ~]$ TARGET=ONLINE
[oracle@db1 ~]$ STATE=ONLINE on db2

as you see this instance has restarted 5 times , it's happen in a week .
can you please tell me how can i find the reason of restarting Instance . (there is no reason log in alert.log) .

thanks ,
Reza .




Re: Shutdown abort Instance [message #349401 is a reply to message #349384] Sun, 21 September 2008 08:40 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You should check the CRS logs in $CRS_HOME/log/<hostname>/
Previous Topic: what's the maximum namber for Restart Attempts in CRS_profile?
Next Topic: EVMservice down on two of three nodes
Goto Forum:
  


Current Time: Thu Dec 08 12:46:03 CST 2016

Total time taken to generate the page: 0.07550 seconds