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