| error ORA-00205: error in identifying control file [message #421482] |
Tue, 08 September 2009 12:06  |
|
|
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  |
ThomasG
Messages: 3212
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 |
|
|
[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 |
ThomasG
Messages: 3212
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 #421493 is a reply to message #421491] |
Tue, 08 September 2009 13:38 |
|
|
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 |
ThomasG
Messages: 3212
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 #421498 is a reply to message #421497] |
Tue, 08 September 2009 14:20 |
|
|
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 #421683 is a reply to message #421676] |
Wed, 09 September 2009 16:10 |
ThomasG
Messages: 3212
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
