-
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
-
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?
-
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
-
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.
-
ORA-00205: error in identifying control file
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
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
|