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

[ambi_001]

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

[gandolf989]

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.

[ambi_001]

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

[gandolf989]

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?

[ambi_001]

[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

[gandolf989]

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?

[PAVB]

so... how about '/disk1/sun/controlfile/contro101.ctl'
... would you mind in answering Gandolf's questions about this particular file?

[ambi_001]

sorry i dint get u

pls

[gandolf989]

Since you are learning Oracle, I would suggest that you delete the old database and use dbca to create a new database. You should also review the concepts manual, http://download.oracle.com/docs/cd/B...b28301/toc.htm, to see what the various parts of an Oracle database are and how they interact. Recreating the database should help you to learn more about Oracle.

[ambi_001]

wt i hv to do nw

should i delete
/u01 folder contents

and

.bash_profile.

and

initsun.ora which is in [oracle@ambi ~]$ cd $ORACLE_HOME/dbs

and

[oracle@ambi sun]$ ls
bdump cdump create udump

delete this dimps nad

delete createsun.sql