ORA-03113: end-of-file on communication channel error After mounting the database

Dear all,

We are using ORACLE 8.1.7.4 on AIX 4.3, IBM Server. We are facing problem when open the database. After mounting the database it is giving "ORA-03113: end-of-file on communication channel" error. After that the instance itself getting down and we couln't see the process in OS level itself.

I found the system datafile is not getting updated the time stamp, but the controlfile is getting updated the time stamp.

If somebody can help me that will be really helpful..

Please find the details below..

SVRMGR> connect internal
Connected.
SVRMGR> startup pfile=/mm2/db/MMDEV/dbs/initMMDEV.ora
ORACLE instance started.
Total System Global Area 92311444 bytes
Fixed Size 73620 bytes
Variable Size 52838400 bytes
Database Buffers 39321600 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
SVRMGR> exit

/mm2>ps -ef |grep MMDEV
mrm 32254 33378 1 10:45:20 pts/2 0:00 grep MMDEV
/mm2>





=================
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Fri Oct 10 10:44:31 2003
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.4.0.
System parameters with non-default values:
processes = 70
timed_statistics = TRUE
shared_pool_size = 30720000
nls_date_format = YYYYMMDD
control_files = /mm2/db/MMDEV/dblog1/control/ctrl1MMDEV.ctl, /mm2/db/MMDEV/dblog2/control/ctrl2MMDEV.ctl
db_block_buffers = 4800
db_block_size = 8192
log_buffer = 32768
log_checkpoint_interval = 10000
db_files = 64
dml_locks = 100
rollback_segments = rbs_01, rbs_02, rbs_03, rbs_04, rbs_05
max_enabled_roles = 100
global_names = FALSE
db_name = MMDEV
open_cursors = 200
ifile = /mm2/db/MMDEV/dbs/configMMDEV.ora
optimizer_mode = CHOOSE
background_dump_dest = /mm2/db/MMDEV/dblog1/log
user_dump_dest = /mm2/db/MMDEV/dblog1/log
core_dump_dest = /mm2/db/MMDEV/dblog1/core
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Fri Oct 10 10:44:33 2003
alter database mount
Fri Oct 10 10:44:37 2003
Successful mount of redo thread 1, with mount id 768785685.
Fri Oct 10 10:44:37 2003
Database mounted in Exclusive Mode.
Completed: alter database mount
Fri Oct 10 10:44:37 2003
alter database open
Fri Oct 10 10:44:38 2003
Errors in file /mm2/db/MMDEV/dblog1/log/dbw0_36704_mmdev.trc:
ORA-00600: internal error code, arguments: [17585], [33554433], [538610432], [], [], [], [], []
Fri Oct 10 10:44:38 2003
Errors in file /mm2/db/MMDEV/dblog1/log/dbw0_36704_mmdev.trc:

THANKS IN ADVANCE..

Could u pls post or email the contents of this file
Errors in file /mm2/db/MMDEV/dblog1/log/dbw0_36704_mmdev.trc:

have you set the kernel parameters or have they changed recently?

Try increasing the processes. give it a try

Has this database been running then all of a sudden this is happening? If so what has changed?


As everyone knows UNIX operating systems are one of the most stable enviornments. You said that your system datafile isn't getting updated. Could of someone gone in and changed the permissions to that folder (or file) so that the database owner can't write to it? Is the disk full where the datafiles reside?

Read metalink Notes: 17613.1

I didn't change the kernel parameters recently. I have more than 4GB free space available in the file system. And nobody changed the permission of the file.

Please find the log file. Since the trace file is too big, i removed last part of the file.