How to create a database with minimum configuration and parameters

Step 1 : Export the required PATH

export ORACLE_SID=TEST5
export ORACLE_HOME=/u11m/app/ilproddb/9.2.0/
export PATH=$PATH:$ORACLE_HOME/lib:$ORACLE_HOME/bin

Step 2 : Create pfile with the minimum configuration

[ilerpap03:ilmis] /u11m/app/ilproddb/9.2.0/dbs> vi initTEST5.ora
"initTEST5.ora" [New file]
instance_name=TEST5
db_name=TEST5



Step 3 : Now , create the database

[ilerpap03:ilmis] /u11m/app/ilproddb/9.2.0/dbs> sysdba

SQL*Plus: Release 9.2.0.5.0 - Production on Mon Nov 9 12:26:31 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

12:26:38 TEST5 > startup nomount
ORACLE instance started.

Total System Global Area 178227232 bytes
Fixed Size 743456 bytes
Variable Size 121634816 bytes
Database Buffers 50331648 bytes
Redo Buffers 5517312 bytes
12:26:46 TEST5 > create database ;

Database created

12:30:46 TEST5 >


That's it . Database is created now .