Step 1 Create a initSID.ora (Example: initTEST.ora) file in $ORACLE_HOME/dbs/ directory.

Example: $ORACLE_HOME/dbs/initTEST.ora

Put following entry in initTEST.ora file

background_dump_dest=
core_dump_dest=
user_dump_dest=
control_files = (/control1.ctl, /control2.ctl,//control3.ctl) 
undo_management = AUTO
undo_tablespace = UNDOTBS1

db_name = TEST

db_block_size = 8192

sga_max_size = 1073741824

sga_target = 1073741824

Step 2 Create a password file

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/pwd.ora password= entries=5

Step 3 Set your ORACLE_SID

$ export ORACLE_SID=test
$ export ORACLE_HOME=/

Step 4 Run the following sqlplus command to connect to the database and startup the instance.

$sqlplus '/ as sysdba'

SQL> startup nomount

Step 5 Create the Database. Use following scripts

create database test

logfile group 1 ('/redo1.log') size 100M,

group 2 ('/redo2.log') size 100M,

group 3 ('/redo3.log') size 100M

character set WE8ISO8859P1

national character set utf8

datafile '/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local

sysaux datafile '/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited

undo tablespace undotbs1 datafile '/undotbs1.dbf' size 100M

default temporary tablespace temp tempfile '/temp01.dbf' size 100M;

Step 6 Run the scripts necessary to build views, synonyms, etc.:

CATALOG.SQL-- creates the views of data dictionary tables and the dynamic performance views.

CATPROC.SQL-- establishes the usage of PL/SQL functionality and creates many of the PL/SQL Oracle supplied packages.