Creating Oracle database with scripts

I took the manual approach (without DBCA) for creating database. Steps followed-

1. Setup ORACLE_HOME and ORACLE_SID

I edited my .profile file and put accordingly

export ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1
export ORACLE_SID=SRCSWN

To use sqlplus

export PATH
export PATH=$PATH:/usr/sfw/bin:$ORACLE_HOME/bin

To activate my profile without relogin - I used

# . .profile

2. Create a minimal pfile

$ORACLE_HOME/dbs/initSRCSWN.ora

*.control_files = '/export/home/shawon/oradata/srcswn/control01.ctl','/export/home/shawon/oradata/srcswn/control02.ctl','/export/home/sh
awon/oradata/srcswn/control03.ctl'
*.undo_management = AUTO
*.undo_tablespace = UNDOTBS1
*.db_name = SRCSWN
*.db_block_size = 8192
*.sga_max_size = 262144000
*.sga_target = 262144000


3. Start the instance

# sqlplus / as sysdba

4. Create Database

create database SRCSWN
logfile group 1 ('/export/home/shawon/oradata/srcswn/redo1.log') size 100M,
group 2 ('/export/home/shawon/oradata/srcswn/redo2.log') size 100M,
group 3 ('/export/home/shawon/oradata/srcswn/redo3.log') size 100M
character set WE8ISO8859P1
national character set utf8
datafile '/export/home/shawon/oradata/srcswn/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/export/home/shawon/oradata/srcswn/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1 datafile '/export/home/shawon/oradata/srcswn/undotbs1.dbf' size 100M
default temporary tablespace temp tempfile '/export/home/shawon/oradata/srcswn/temp01.dbf' size 100M;


5. Run catalog and catproc scripts

@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

6. Change sys and system password

alter user sys identified by *****;
alter user system identified by *****;

One helpful URL here -
http://www.dba-oracle.com/oracle_create_database.htm#extreme_minimal_create_database