Database Tuning (MOSC)

MOSC Banner

Instance restarting on its own

edited Aug 27, 2009 3:34AM in Database Tuning (MOSC) 4 commentsAnswered
 Hi, I have a two node cluster database , 2nd instance is restarting on its own with the following entry in the alert log.I am not able to understand.
Please guide me

Thread 2 advanced to log sequence 5570
  Current log# 4 seq# 5570 mem# 0: +DATA/sig/onlinelog/group_4.261.664981889
  Current log# 4 seq# 5570 mem# 1: +FLASH/sig/onlinelog/group_4.257.664981891
Thu Aug 27 11:51:15 2009
ALTER SYSTEM SET service_names='SIG.bsnl.com' SCOPE=MEMORY SID='SIG2';
 Thu Aug 27 11:51:21 2009
Shutting down instance (abort)
License high water mark = 1141
Instance terminated by USER, pid = 10502
Thu Aug 27 11:51:40 2009
Starting ORACLE instance (normal)

regards Naresh

To understand the problem better please find the different logs,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center