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
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?
Oracle it's not just a database it's a lifestyle!
-------------- BTW....You need to get a girlfriend who's last name isn't .jpg
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.