Database Creation.

Firstly u have to do following to set the parameter for database creation.
for you practice i am telling u by applying practically for DB creation.

For manually DB Creation

1..db_name=kamran

*.db_block_size=8192
*.sga_target=1677721600
*.undo_management=’AUTO’
*.control_files = (‘/home/oracle/oracle/product/10.2.0/control01.ctl’)
*.user_dump_dest=’/home/oracle/oracle/product/10.2.0/udump’
*.background_dump_dest=’/home/oracle/oracle/product/10.2.0/bdump’
*.core_dump_dest=’/home/oracle/oracle/product/10.2.0/cdump’


2.After creation of this parameter file, create below folders in /home/oracle/oracle/product/10.2.0/ directory. Three of them are dump folders (needed for trace files and alert.log file). We’re going to keep Control Files and DataFiles in oradata folder.
-          oradata
-          udump
-          bdump
-          cdump


 3. Create Server parameter file (SPFILE) using this parameter file and STARTUP the instance in NOMOUNT mode.
 CREATE SPFILE FROM PFILE=’/home/oracle/oracle/product/10.2.0/init.ora’;
STARTUP NOMOUNT

4. To create a new database, use the CREATE DATABASE statement. As a result, below files will be created:
-          Redo Log files
-          system.dbf and sysaux.dbf (files for SYSTEM tablespace)
-          undo01.dbf file (for UNDO tablespace)
-          temp_tbs.dbf file (for TEMPORARY tablespace)
-          users.dbf (for DEFAULT PERMANENT tablespace)

//######## Database Creation Code #######
CREATE DATABASE kamran
    USER SYS IDENTIFIED BY kamran
    USER SYSTEM IDENTIFIED BY kamran




after applying these steps u gauranteed to make full database creation by manually.

Tool for DB creation.

on sql prumpt type DBCA to create DB by help of tools..