-
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
-
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.
-
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
-
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?
-
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
-
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.
-
ORA-00205: error in identifying control file
-
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?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|