Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Unanswered: Oracle 10g database cannot be mounted

    platform is CentOS4.8 64-bit

    When I ran
    Code:
    sqlplus / as sysdba
    startup mount
    the following error occurred:
    Code:
    ORA-00205: error in identifying control file, check alert log for more info
    opened the log file under directory specified by background_dump_dest, I met error below:
    Code:
    ORA-00202: control file: '/opt/oracle/product/10.2.0/db_1/dbs/ora_control1'
    ORA-27037: unable to obtain file status
    I created a new db 'mydb' with dbca. Its control files are under
    /opt/oracle/oradata/mydb/

    names are
    control01.ctl, control02.ctl, control03.ctl

    while the parameter control_files is
    /opt/oracle/product/10.2.0/db_1/dbs/ora_control1, /opt/oracle/product/10.2.0/db_1/dbs/ora_control2

    I found no control file under
    /opt/oracle/product/10.2.0/db_1/dbs/

    I copied control files of mydb to /opt/oracle/product/10.2.0/db_1/dbs/ and changed their names to ora_control1 and ora_control2
    then ran 'startup mount' again
    getting error as follows:
    Code:
    ORA-00201: control file version 10.2.0.1.0 incompatible with ORACLE version 10.2.0.0.0
    ORA-00202: control file: '/opt/oracle/product/10.2.0/db_1/dbs/ora_control1'
    I've been stuck in this problem for a few weeks, searching many pages with no solution found.
    Can anyone tell me what the problem is?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Could this be a confusion between an init.ora file and a SP file? Using startup with no PFILE paramter should default to an SP file.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post results of following OS commands

    id
    env | sort
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Aug 2011
    Posts
    2
    Quote Originally Posted by MCrowley View Post
    Could this be a confusion between an init.ora file and a SP file? Using startup with no PFILE paramter should default to an SP file.
    Thanks for the advice!
    this really helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •