DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: error in identifying control file, check alert log

  1. #1
    Join Date
    Jun 2007
    Posts
    17

    error in identifying control file, check alert log

    Hello all,

    I am trying to create a database using OMF.
    This is what I put in the init file:

    db_name=test1
    db_block_size=8192
    undo_management=auto
    db_create_file_dest= '/oracle/database/test1'
    db_create_online_log_dest_1 = '/oracle/database/test1'
    db_create_online_log_dest_2 = '/oracle/database/test1'
    sga_target=116m
    pga_aggregate_target=30m
    #control_files='/oracle/10g/dbs/cntrlorcl.dbf'

    I did create the appropriate directory test1 inside 'database' and Oracle created another directory 'TEST1" inside the directory i created and created folders for 'controlfiles', 'redologfiles' and 'datafiles' in the new TEST1 directory. I tried setting the db_create_online_log_dest_1 = '/oracle/database/test1/TEST1/controlfiles/OMFgeneratedname.ctl'

    You will also notice that the 'control_files' parameter is commented. Initially I was not using this at all but something on google suggested that i should; so I :

    SQL>show parameters control_files;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    control_files string /oracle/10g/dbs/cntrlorcl.dbf

    and I used this address for the control_file parameter in the init.ora file.

    The problem:

    I can not mount the database and keep getting the error 'ORA-00205: error in identifying control file, check alert log for more info'

    Any helpful advise will be greatly appreciated.
    Thanks,
    Arpan.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    and... what the Alert Log says?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jun 2007
    Posts
    17

    checking the alert log

    I dont know how to check it.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    show parameter background_dump_dest
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Jun 2007
    Location
    İstanbul/Turkey
    Posts
    25
    There can be several reasons for this error:

    -Another Oracle instance has this database open.
    -Two init.ora files are pointing at the same control files.
    -The database instance was not shutdown properly.
    -The control file was renamed or moved to a new location.
    -The $ORACLE_HOME is a symbolic link.
    -The database was previously started (or failed to start) in another
    $ORACLE_HOME.

    1. Look in the init.ora file for the location of the control file.
    *Note: The control files may also be located in the config.ora file.

    2. Verify the location of the control file and ensure that the directory
    matches the location in the init.ora file.

    3. Change directories to the location of the control file.

    % strings control-file | more

    In the header, it has the $ORACLE_SID/$ORACLE_HOME. The $ORACLE_HOME
    shows the path for the RDBMS version and the correct sid.

    4. Change directories to the $ORACLE_HOME indicated in the strings of
    the control file.

    % cd $ORACLE_HOME

    5. Change directories to the dbs directory and list the contents of the
    directory.

    % cd dbs

    % ls

    6. Check for a file called sgadef.dbf, if present, remove it.

  6. #6
    Join Date
    Jun 2007
    Posts
    17

    Error Identigying Control File

    Thanks a lot for your help.

    turns out that after creating the database I had to shutdown and update the init file with the new controlfile address.

    It works like a charm now :~)

    This was my first post here and I am sure I am gonna hang around for a long time.

    Thanks again,
    Arpan.

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