DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

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

  1. #1
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file, check alert log for more info

    Hi my name is Ambarish i got this problem when i run database
    i am runing on linux
    can any one help me

    SQL> startup
    ORACLE instance started.

    Total System Global Area 125829120 bytes
    Fixed Size 1218052 bytes
    Variable Size 117443068 bytes
    Database Buffers 4194304 bytes
    Redo Buffers 2973696 bytes
    ORA-00205: error in identifying control file, check alert log for more info

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You should be able to look at the init/spfile and find out where the control files should be. Are they there? Did they get corrupted? Did someone chmod them so that the database could not read/write to them? Are you using the wrong init/spfile? You can also look through the alert log and see which control files were used that last time the database started successfully.

  3. #3
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file,

    Thanks fr ur reply
    Mr gandolf

    i hv sent u the alert log details pls go tru this ull come to know i think

    Starting up ORACLE RDBMS Version: 10.2.0.1.0.
    System parameters with non-default values:
    processes = 50
    shared_pool_size = 92274688
    control_files = /disk1/sun/controlfile/contro101.ctl
    db_block_buffers = 512
    log_buffer = 2927616
    log_checkpoint_interval = 10000
    db_files = 80
    db_file_multiblock_read_count= 8
    undo_management = AUTO
    undo_tablespace = UNDOTBS
    global_names = TRUE
    parallel_max_servers = 5
    background_dump_dest = /disk2/sun/bdump
    user_dump_dest = /disk2/sun/udump
    max_dump_file_size = 10240
    core_dump_dest = /disk2/sun/cdump
    db_name = sun
    PMON started with pid=2, OS id=6744
    PSP0 started with pid=3, OS id=6746
    MMAN started with pid=4, OS id=6748
    DBW0 started with pid=5, OS id=6750
    LGWR started with pid=6, OS id=6752
    CKPT started with pid=7, OS id=6754
    SMON started with pid=8, OS id=6756
    RECO started with pid=9, OS id=6758
    MMNL started with pid=11, OS id=6762
    Tue Sep 8 23:02:22 2009
    ALTER DATABASE MOUNT
    Tue Sep 8 23:02:22 2009
    ORA-00202: control file: '/disk1/sun/controlfile/contro101.ctl'
    ORA-27037: unable to obtain file status
    Linux Error: 2: No such file or directory
    Additional information: 3
    Tue Sep 8 23:02:22 2009
    ORA-205 signalled during: ALTER DATABASE MOUNT...
    MMON started with pid=10, OS id=6760

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    So if you do an 'ls -l /disk1/sun/controlfile/contro101.ctl' what happens? Does the file exist? if you do a df -h does the volume exist? Can you cd to /disk1/sun/controlfile?

  5. #5
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file

    [oracle@ambi bdump]$ df -h
    Filesystem Size Used Avail Use% Mounted on
    /dev/hdd10 1012M 319M 642M 34% /
    /dev/hdd2 1012M 45M 916M 5% /boot
    none 375M 0 375M 0% /dev/shm
    /dev/hdd7 2.0G 36M 1.9G 2% /disk1
    /dev/hdd6 2.0G 36M 1.9G 2% /disk2
    /dev/hdd9 1012M 49M 912M 6% /tmp
    /dev/hdd3 9.7G 2.8G 6.4G 30% /u01
    /dev/hdd5 9.7G 6.3G 2.9G 69% /usr
    /dev/hdd11 1012M 244M 718M 26% /var
    [oracle@ambi bdump]$ ls -l /disk1/sun/controlfile/contro101.ctl
    ls: /disk1/sun/controlfile/contro101.ctl: No such file or directory

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    so... how about '/disk1/sun/controlfile/contro101.ctl'
    ... would you mind in answering Gandolf's questions about this particular file?
    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.

  7. #7
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file

    sorry i dint get u

    pls

  8. #8
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    I hope your whole database is not on /disk1. If so there is only 35MB there now. "/dev/hdd7 2.0G 36M 1.9G 2% /disk1"

    So how am I going to search through you server and find the missing control file? Is there anything in /disk1/sun/controlfile? Did someone delete the control file? Did someone delete the database? Did this database ever start before? Where is your backup?

  9. #9
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file

    see ill tel u in details abt my set up


    Oracle binaries installed here

    [oracle@ambi ~]$ cd /u01/ofa/product
    [oracle@ambi product]$ cd 10.2.0
    [oracle@ambi ~]$
    [oracle@ambi ~]$

    i am nt able to enter in to the 10.2.0 where i hv installed binaries
    but the filles r there in the 10.2.0 i saw nw only

  10. #10
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    All that you told me is that you have Oracle binaries. How did you create the database? Did you use the dbca tool? How long have you been using this database? How much data should be in the database? When did the database suddenly stop? Did the database ever exist?

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