-
Earlier today, one of my databases just stopped running without any reason. I have checked the tablespace storage, there is bags of room, any ideas what else I could check to see why this has happened, here is the extract from the alert files, by the way its 7.3.3 running on NT 4.0 :
(times are GMT)
Fri Jan 12 12:30:22 2001
Shutting down instance (immediate)
License high water mark = 9
Fri Jan 12 12:30:26 2001
ALTER DATABASE CLOSE NORMAL
Fri Jan 12 12:30:26 2001
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jan 12 12:30:28 2001
Thread 1 closed at log sequence 2506
Current log# 2 seq# 2506 mem# 0: C:\ORANT\DATABASE\LOG2FLVE.ORA
Fri Jan 12 12:30:28 2001
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jan 12 12:30:28 2001
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
Dump file C:\ORANT\RDBMS73\trace\flveALRT.LOG
-
Since it closed in normal mode, it doesn't seem like a crash.
If the database came backup without errors, then check any scheduled jobs that may be shutting down the database or it may be that your internal password has been compromised and someone has done this behind your back.
-
I am not seeing any reason to worry. Just restart it. It should restart. Though the reason for shutting down could be because of some scheduled script.
-
Can you post the INIT.ORA file?
