ORA-00205: error in identifying controlfile, check alert log for more info
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-00205: error in identifying controlfile, check alert log for more info

Hybrid View

  1. #1
    Join Date
    May 2008
    Location
    INDIA
    Posts
    17

    Unhappy 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

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    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

  3. #3
    Join Date
    May 2008
    Location
    INDIA
    Posts
    17

    Unhappy

    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

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    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

  5. #5
    Join Date
    Oct 2006
    Posts
    175
    Quote Originally Posted by gohappy View Post
    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
  •  



Click Here to Expand Forum to Full Width