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

[ambi_001]

No i dint use dbca tool

i manually created started creating database
i dont hv any data
i learnt DBA 1month back nw i started working out

creatind 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

[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

[ambi_001]

i am waiting fr ur reply

[ambi_001]

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$

if i do
-bash-3.00$ logout

[root@ambi ~]#

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

its going
[oracle@ambi ~]$

[davey23uk]

go to otn.oracle.com and read the concepts manual

then go and learn the difference between su and su - in a unix environemnt, the help you needc cannot be give on a forum.

I even severely doubt that you have even created a database

[ambi_001]

so hw should i follow the steps

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

[davey23uk]

have you even created a database?

[gandolf989]

You need to learn this yourself. I think you have been given enough help.