Home » Infrastructure » Linux » error ORA-00205: error in identifying control file
error ORA-00205: error in identifying control file [message #421482] Tue, 08 September 2009 12:06 Go to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

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



my alertlog detaills r (last few lines)

System parameters with non-default values:
processes = 50
shared_pool_size = 92274688
control_files = /disk1/sun/controlfile/contro101.ctl, /disk2/sun/controlfile/control02.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=7968
MMAN started with pid=4, OS id=7972
PSP0 started with pid=3, OS id=7970
DBW0 started with pid=5, OS id=7974
LGWR started with pid=6, OS id=7976
CKPT started with pid=7, OS id=7978
SMON started with pid=8, OS id=7980
RECO started with pid=9, OS id=7982
MMON started with pid=10, OS id=7984
MMNL started with pid=11, OS id=7986
Tue Sep 8 18:59:42 2009
ALTER DATABASE MOUNT
Tue Sep 8 18:59:42 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 18:59:42 2009
ORA-205 signalled during: ALTER DATABASE MOUNT...
Tue Sep 8 19:06:50 2009
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 7987


pls help me where i hv gone wrong pls help me to create database
Re: error ORA-00205: error in identifying control file [message #421485 is a reply to message #421482] Tue, 08 September 2009 12:21 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
ambitn324 wrote on Tue, 08 September 2009 19:06

ORA-00202: control file: '/disk1/sun/controlfile/contro101.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory



Isn't it pretty obvious? There is no /disk1/sun/controlfile/contro101.ctl on the file system.
Re: error ORA-00205: error in identifying control file [message #421486 is a reply to message #421485] Tue, 08 September 2009 12:56 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

[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

pls see /disk1 is there
Re: error ORA-00205: error in identifying control file [message #421487 is a reply to message #421485] Tue, 08 September 2009 13:02 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Received via PM :"Please help me how to do it."

How to do what? You tried to start an Oracle database with a non-existent control file.

That could have hundreds of reasons.

- The disk might be broken
- You think you have installed Oracle, but the install is not complete.
- You environment setup is wrong
- You are logged in with the wrong user
- Is this a fresh install, or an install that used to work? If the later, what changed after it worked?
Re: error ORA-00205: error in identifying control file [message #421488 is a reply to message #421487] Tue, 08 September 2009 13:04 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Post the output of

ls -l /disk1/sun/controlfile/contro101.ctl
Re: error ORA-00205: error in identifying control file [message #421490 is a reply to message #421488] Tue, 08 September 2009 13:12 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

[oracle@ambi bdump]$ ls -l /disk1/sun/controlfile/contro101.ctl
ls: /disk1/sun/controlfile/contro101.ctl: No such file or directory
Re: error ORA-00205: error in identifying control file [message #421491 is a reply to message #421490] Tue, 08 September 2009 13:17 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
So.

- Do you know what a file is?
- Do you know what a directory is?

Could it be that somewhere along the line someone misspelled "control01.ctl" to "contro101.ctl"?
Re: error ORA-00205: error in identifying control file [message #421493 is a reply to message #421491] Tue, 08 September 2009 13:38 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

i know the diff b/w
file and the directory


creating database wt i did

step 1 : Set Environment
this is hw itt looks

# .bash_profile.

export ORACLE_SID=sun
export ORACLE_HOME=/u01/ofa/product/10.2.0
export PATH=$ORACLE_HOME/bin:$PATH:

:wq

2)created Pfile or Init file
[oracle@ambi ~]$ cd $ORACLE_HOME/dbs [oracle@ambi dbs]$ ls
hc_sun.dat initdw.ora init.ora initsun.ora lkSUN
[oracle@ambi dbs]$ cd vi initsun.ora

# replace DEFAULT with your database name
db_name=sun

db_files = 80 # SMALL
# db_files = 400 # MEDIUM
# db_files = 1500 # LARGE

db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
# db_file_multiblock_read_count = 32 # LARGE

db_block_buffers = 100 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE

#shared_pool_size = 3500000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
shared_pool_size = 90000000 # LARGE

log_checkpoint_interval = 10000

processes = 50 # SMALL
# processes = 100
undo_tablespace=UNDOTBS
undo_management=auto
user_dump_dest='/disk2/sun/udump'
background_dump_dest='/disk2/sun/bdump'
core_dump_dest='/disk2/sun/cdump'

parallel_max_servers = 5 # SMALL
# parallel_max_servers = 4 x (number of CPUs) # MEDIUM
# parallel_max_servers = 4 x (number of CPUs) # LARGE

log_buffer = 32768 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE

# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
global_names = TRUE
# define two control files by default
control_files='/disk1/sun/controlfile/contro101.ctl'

3)step i created dumps
[oracle@ambi sun]$ pwd
/disk2/sun
[oracle@ambi sun]$ ls
bdump cdump create udump
[oracle@ambi sun]$

4) created databasescript i.e createsun.sql
[oracle@ambi create]$ pwd
/disk2/sun/create
[oracle@ambi create]$ ls
createsun.sql
[oracle@ambi create]$ vi createsun.sql

create database sun
datafile '/disk1/sun/datafile/system.dbf' size 170m
sysaux datafile '/disk1/sun/datafile/sysaux.dbf' size 150m
default temporary tablespace TEMP tempfile
'/disk1/sun/datafile/temp1.dbf' size 10m
default tablespace USERS datafile
'/disk1/sun/datafile/user1.dbf' size 20m
undo tablespace UNDOTBS datafile
'/disk1/sun/datafile/undo1.dbf' size 20m
logfile
group 1 ('/disk1/sun/redologfile/redolog1a.log') size 4m,
group 2 ('/disk1/sun/redologfile/redolog2a.log') size 4m;

[oracle@ambi ~]$ sqlplus '/as sysdba';

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 8 23:54:34 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

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



this is wt i did
Re: error ORA-00205: error in identifying control file [message #421494 is a reply to message #421493] Tue, 08 September 2009 13:54 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can't "startup" the database before you have created it.

You have to "startup nomount", and then run the creation script in the nomount stage.

Have a look at the example here.

And please format your posts in the future, it gave me headaches trying to decipher what script started/ended where.

Re: error ORA-00205: error in identifying control file [message #421496 is a reply to message #421494] Tue, 08 September 2009 14:12 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

i am telling i hv problem in installing database nw the time here is 12.41 am wed in india
Re: error ORA-00205: error in identifying control file [message #421497 is a reply to message #421496] Tue, 08 September 2009 14:15 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
ambitn324 wrote on Tue, 08 September 2009 21:12
i am telling i hv problem in installing database nw the time here is 12.41 am wed in india


There seems to be some strange bug that Oracle can't be installed after 12:00 o'Clock, then? Laughing
Re: error ORA-00205: error in identifying control file [message #421498 is a reply to message #421497] Tue, 08 September 2009 14:20 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

from morning i am trying wt to do

one more problem i hv [oracle@ambi ~]$ su
Password:
[root@ambi 10.2.0]# cd
[root@ambi ~]# su - oracle
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$

<ctrl - d> if i do
-bash-3.00$ logout

[root@ambi ~]#

if i give
[root@ambi ~]# su oracle

its going
[oracle@ambi ~]$



Re: error ORA-00205: error in identifying control file [message #421499 is a reply to message #421498] Tue, 08 September 2009 14:50 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
And where is the problem there?.

That is just how you change between users in Linux/Unix.
Re: error ORA-00205: error in identifying control file [message #421511 is a reply to message #421499] Tue, 08 September 2009 23:43 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

[root@ambi ~]# su - oracle
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
-bash-3.00$
Re: error ORA-00205: error in identifying control file [message #421516 is a reply to message #421499] Wed, 09 September 2009 00:03 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

are you reading full msg
Re: error ORA-00205: error in identifying control file [message #421616 is a reply to message #421482] Wed, 09 September 2009 08:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
as user oracle post results from following


env | sort
Re: error ORA-00205: error in identifying control file [message #421618 is a reply to message #421516] Wed, 09 September 2009 08:45 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You "su" to oracle and get a bash prompt.

One time with the "-" to load the Oracle environment, one time witout it.

And? That's the way it should be.

[Updated on: Wed, 09 September 2009 08:49]

Report message to a moderator

Re: error ORA-00205: error in identifying control file [message #421670 is a reply to message #421618] Wed, 09 September 2009 12:42 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

u mean to say its correct
Re: error ORA-00205: error in identifying control file [message #421676 is a reply to message #421670] Wed, 09 September 2009 13:53 Go to previous messageGo to next message
ambitn324
Messages: 29
Registered: September 2009
Location: India
Junior Member

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
Re: error ORA-00205: error in identifying control file [message #421683 is a reply to message #421676] Wed, 09 September 2009 16:10 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

i am nt able to enter in to the 10.2.0



Why? Are the required keys missing from your keyboard? What does "hv" mean? what does "nw" mean?

And what you posted is still perfectly normal IF /u01/ofa/product/10.2.0 is your home directory. (then ~ is displayed instead of the actual directory)

I think you need to go and take some introductory class into Unix/Linux before you try to get into Oracle.
Re: error ORA-00205: error in identifying control file [message #421804 is a reply to message #421676] Thu, 10 September 2009 12:56 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
ambitn324 wrote on Wed, 09 September 2009 14:53

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


Based on the way you spell, sounds like you probably misspelled every command in oracle along with every directory name.
Previous Topic: expdp in 10g
Next Topic: please help on installing oracle9i on linux4
Goto Forum:
  


Current Time: Thu Mar 28 12:33:56 CDT 2024