-
ORA-00205: error in identifying controlfile, check alert log for more info
Hi,
I am having 3 control files at location as per the init.ora file. Today moring I found database was down, when trying to startup, got an error "ORA-00205: error in identifying controlfile, check alert log for more info".
Alert.log
=========================
Thu Apr 24 07:53:35 2009
Errors in file /oracle/abcdb/9.2.0/admin/bdump/abc_ckpt_3147.trc:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/oracle/data/cntrl03.dbf'
ORA-27072: skgfdisp: I/O error
Linux Error: 30: Read-only file system
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/oracle/data/cntrl02.dbf'
ORA-27072: skgfdisp: I/O error
Linux Error: 30: Read-only file system
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/oracle/data/cntrl01.dbf'
ORA-27072: skgfdisp: I/O error
Linux Error: 30: Read-only file system
Additional information: 2
I was trying to create a controlfile from the script present at alert.log as CREATE CONTROLFILE REUSE SET DATABASE "ABC", but got the same error ORA-00205.
Pls suggest me.
Thanks,
gohappy
-
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/oracle/data/cntrl03.dbf'
ORA-27072: skgfdisp: I/O error
Linux Error: 30: Read-only file system
Isn't the reason obvious?
Ales The whole difference between a little boy and an adult man is the price of toys
-
Thanks Ales,
The file permision for control file is " -rw-r----- ". Could you pls tell me what should be the file permission for control file...
Cheers,
gohappy
-
The file permissions don't change by oneself.
Check if the filesystem is mounted read-write (mount command).
Ales The whole difference between a little boy and an adult man is the price of toys
-
Originally Posted by gohappy
Thanks Ales,
The file permision for control file is " -rw-r----- ". Could you pls tell me what should be the file permission for control file...
Cheers,
gohappy
IT SHOULD READ-WRITE, NOT READ-ONLY.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|