Oracle Database Discussions

Hello,
We have already installed Oracle 11g DB.But ,in three days ago ,Oracle automatically shutdown itself At 2:00 AM and then Startup .
After looking at alert_${ORACLE_SID}.log i really do not understand why this happens.I also look at the free memory in our Linux machine by command "free -mt " ,that prints the following result :

total used free shared buffers cached
Mem: 11514 11431 82 0 198 7450
-/+ buffers/cache: 3783 7730
Swap: 14015 2874 11141
Total: 25529 14306 11223

But ,i am not sure automatically shutdown and startup due to lack of memory.
Is there maybe some other reasons that causes this problem?

And the following listing is copied from alert_${ORACLE_SID}.log :

///////////////////////////////////////////////////alert_${ORACLE_SID}.log//////////////////////////////////////
Fri Aug 05 23:31:42 2011
Thread 1 cannot allocate new log, sequence 156
Private strand flush not complete
Current log# 2 seq# 155 mem# 0: /home/oracle/app/oracle/oradata/autsid/redo02.log
Thread 1 advanced to log sequence 156 (LGWR switch)
Current log# 3 seq# 156 mem# 0: /home/oracle/app/oracle/oradata/autsid/redo03.log
Sat Aug 06 00:46:08 2011
Thread 1 cannot allocate new log, sequence 157
Private strand flush not complete
Current log# 3 seq# 156 mem# 0: /home/oracle/app/oracle/oradata/autsid/redo03.log
Thread 1 advanced to log sequence 157 (LGWR switch)
Current log# 1 seq# 157 mem# 0: /home/oracle/app/oracle/oradata/autsid/redo01.log
Clearing Resource Manager plan via parameter
Sat Aug 06 02:00:22 2011
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Sat Aug 06 02:00:25 2011
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 31
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Sat Aug 06 02:00:31 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Aug 06 02:00:31 2011
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 157
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Aug 06 02:00:32 2011
Stopping background process VKTM:
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Aug 06 02:00:35 2011
Instance shutdown complete
Sat Aug 06 02:00:36 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /home/oracle/oraBase/product/11.2.0/dbhome_1/dbs/spfileautsid.ora
System parameters with non-default values:
processes = 300
sessions = 472
memory_target = 5696M
control_files = "/home/oracle/app/oracle/oradata/autsid/control01.ctl"
control_files = "/home/oracle/oraBase/recovery_area/autsid/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
db_recovery_file_dest = "/home/oracle/oraBase/recovery_area"
db_recovery_file_dest_size= 3882M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=autsidXDB)"
shared_servers = 5
audit_file_dest = "/home/oracle/oraBase/admin/autsid/adump"
audit_trail = "DB"
db_name = "autsid"
open_cursors = 300
diagnostic_dest = "/home/oracle/oraBase"
Sat Aug 06 02:00:38 2011
PMON started with pid=2, OS id=13030
Sat Aug 06 02:00:39 2011
VKTM started with pid=3, OS id=13032 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sat Aug 06 02:00:39 2011
GEN0 started with pid=4, OS id=13036
Sat Aug 06 02:00:39 2011
DIAG started with pid=5, OS id=13038
Sat Aug 06 02:00:39 2011
DBRM started with pid=6, OS id=13040
Sat Aug 06 02:00:39 2011
PSP0 started with pid=7, OS id=13042
Sat Aug 06 02:00:39 2011
DIA0 started with pid=8, OS id=13044
Sat Aug 06 02:00:39 2011
MMAN started with pid=9, OS id=13046
Sat Aug 06 02:00:39 2011
DBW0 started with pid=10, OS id=13048
Sat Aug 06 02:00:39 2011
LGWR started with pid=11, OS id=13050
Sat Aug 06 02:00:39 2011
CKPT started with pid=12, OS id=13052
Sat Aug 06 02:00:39 2011
SMON started with pid=13, OS id=13054
Sat Aug 06 02:00:39 2011
RECO started with pid=14, OS id=13056
Sat Aug 06 02:00:39 2011
MMON started with pid=15, OS id=13058
///////////////////////////////////////////////////alert_${ORACLE_SID}.log//////////////////////////////////////

Khosro.

Edited by: user1045485 on Aug 6, 2011 3:11 AM