init_create ()
{ echo "db_name=$db" >>$ORACLE_BASE/admin/$db/pfile/init$db.ora
choice=""
until [ -n "$choice" ]
do
  echo "Please Enter The Drive For Control File #1"
read reply1
if [ -d $reply1 ]
then choice=TRUE
fi
done
choice1=""
until [ -n "$choice1" ]
do
echo "Please Enter The Drive For Control File #2"
read reply2
if [ -d $reply2 ]
then choice1=TRUE
fi
done
choice2=""
until [ -n "$choice2" ]
do
echo "Please Enter The Drive For Control File #3"
read reply3
if [ -d $reply3 ]
then choice2=TRUE
fi
done
if [ ! -d $reply1/ORACLE/$db ]
then mkdir -p $reply1/ORACLE/$db
fi
if [ ! -d $reply2/ORACLE/$db ]
then mkdir -p $reply2/ORACLE/$db
fi
if [ ! -d $reply3/ORACLE/$db ]
then mkdir -p $reply3/ORACLE/$db
fi
echo "control_files=($reply1/ORACLE/$db/control01.ctl ,$reply2/ORACLE/$db/control02.ctl,$reply3/ORACLE/$db/control03.ctl)" >>$ORACLE_BASE/admin/$db/pfile/init$db.ora
blockchoice=""
until [ -n "$blockchoice" ]
do
echo "Please enter the db_block_size in bytes (2048,4096 or 8192)"
read dbblock
if [ $dbblock -eq 2048 -o $dbblock -eq 4096 -o $dbblock -eq 8192 ]
then blockchoice=TRUE
fi
done
echo "db_block_size=$dbblock" >> $ORACLE_BASE/admin/$db/pfile/init$db.ora
echo " Please Enter The Database Type (B for Big , S for Small)"
read type
case $type in
b|B) echo "db_block_buffers=6000 " >>$ORACLE_BASE/admin/$db/pfile/init$db.ora 
    echo "shared_pool_size=30000000" >> $ORACLE_BASE/admin/$db/pfile/init$db.ora
	;;
s|S) echo "db_block_buffers=2000" >> $ORACLE_BASE/admin/$db/pfile/init$db.ora 
	echo "shared_pool_size=15000000" >> $ORACLE_BASE/admin/$db/pfile/init$db.ora ;;
esac
echo "db_file_multiblock_read_count=`expr 64 \* 1024 / $dbblock`" >> $ORACLE_BASE/admin/$db/pfile/init$db.ora
echo "Please Enter The Oracle Version For COMPATIBLE parameter"
read version 
echo "Compatible=$version" >> $ORACLE_BASE/admin/$db/pfile/init$db.ora
cat >> $ORACLE_BASE/admin/$db/pfile/init$db.ora <<EOF
rollback_segments=(r01,r02,r03,r04)
log_checkpoint_interval = 1000000000
log_checkpoints_to_alert = TRUE 
#checkpoint_process = TRUE
sort_direct_writes = TRUE
sort_write_buffers = 4
sort_write_buffer_size = 65536
sort_area_size = 1048576  
sort_area_retained_size=65536
processes = 200          
transactions=300
distributed_transactions=250
dml_locks = 200                                 
log_buffer = 1048576                           
open_cursors=250
sequence_cache_entries = 10                                           
#sequence_cache_hash_buckets = 10                                    
open_cursors = 300
#audit_trail = true            # if you want auditing
timed_statistics = false       # if you want timed statistics
max_dump_file_size = 10240      # limit trace file size to 5 Meg each
global_names=false
optimizer_mode=rule
log_archive_format=arch%s.log
remote_os_authent = true    # enable remote ops$ logins
#remote_login_passwordfile= exclusive   
os_authent_prefix=ops$
#db_writers = 2
#job_queue_processes=2
#job_queue_interval=240
#job_queue_keep_connections=FALSE
nls_date_format=DD-MON-RR    
background_dump_dest=$ORACLE_BASE/admin/$db/bdump
user_dump_dest=$ORACLE_BASE/admin/$db/udump
core_dump_dest=$ORACLE_BASE/admin/$db/cdump
EOF
}

tput clear
echo "DATABASE CREATION - Please Enter The Required Information"
echo "*********************************************************"
echo
echo "Please Note :"
echo "* Ensure that the variables ORACLE_HOME,ORACLE_BASE, etc are set."
echo "* Please set the COMPATIBLE parameter to the current ver. of Oracle"
echo "* Please Check The File \$CREATE/createdb.log for any errors "
echo
echo " Checking Enviroment Variables ....."
echo "ORACLE_BASE is `echo $ORACLE_BASE`"
echo "ORACLE_HOME is `echo $ORACLE_HOME`"
echo " Okay to Proceed (Y/N) ?"
read go
if [ "$go"  = n -o "$go" = N ]
then exit
fi
echo "Please Enter The SID For The Database"
read db
echo "Creating The Directories And Sub Directories For Database $db ..."
if [ ! -d $ORACLE_BASE/admin ]
then mkdir $ORACLE_BASE/admin
fi
if [ ! -d $ORACLE_BASE/admin/$db ]
then
mkdir -p $ORACLE_BASE/admin/$db
cd $ORACLE_BASE/admin/$db
mkdir pfile udump bdump cdump create 
fi
echo Directories And Subdirectories Created

#main
echo " Checking For init$db.ora ....."
if [ ! -f $ORACLE_BASE/admin/$db/pfile/init$db.ora ]
then 
	echo " init$db.ora not found .... creating   !"
	init_create
fi
if [  ! -d $ORACLE_BASE/scripts ]
then
 echo "Creating $SCRPT Directory"
  mkdir $ORACLE_BASE/scripts
else echo Scripts directory Already Exists
fi
echo "creating set$db file ..."
cat >> $ORACLE_BASE/scripts/set$db <<EOF
ORACLE_SID=$db;export ORACLE_SID
PFILE=$ORACLE_BASE/admin/$db/pfile; export PFILE
BDUMP=$ORACLE_BASE/admin/$db/bdump; export BDUMP
UDUMP=$ORACLE_BASE/admin/$db/udump; export UDUMP
CDUMP=$ORACLE_BASE/admin/$db/cdump; export CDUMP
CREATE=$ORACLE_BASE/admin/$db/create; export CREATE
EOF
echo "set$db file created in $SCRPT directory"
. set$db
echo "ORACLE_SID is now set to $ORACLE_SID"
choice3=""
until [ -n "$choice3" ]
do
echo Please Enter The Location For The System Datafile
read sys 
if [ -d $sys ]
then choice3=TRUE
fi
done
if [ ! -d $sys/ORACLE/$db ]
then mkdir -p $sys/ORACLE/$db
fi
sysfile="'$sys/ORACLE/$db/system01.dbf'"
echo $sysfile
echo "Please Enter The Size Of The Datafile In Megabytes"
read syssize
syssize1=`echo $syssize |tr -d '[a-z]'|tr -d '[A-Z]'`
A=`echo "datafile $sysfile" size "$syssize1"M`
choice4=""
until [ -n "$choice4" ]
do
echo Please Enter The Location For The RBS Datafile
read rbs 
if [ -d $rbs ]
then choice4=TRUE
fi
done
if [ ! -d $rbs/ORACLE/$db ]
then mkdir -p $rbs/ORACLE/$db
fi
rbsfile="'$rbs/ORACLE/$db/rbs01.dbf'"
echo $rbsfile
echo "Please Enter The Size Of The Datafile In Megabytes"
read rbssize
rbssize1=`echo $rbssize |tr -d '[a-z]'|tr -d '[A-Z]'`
B=`echo "datafile $rbsfile" size "$rbssize1"M`
choice5=""
until [ -n "$choice5" ]
do
echo Please Enter The Location For The TEMP Datafile
read tmp 
if [ -d $tmp ]
then choice5=TRUE
fi
done
if [ ! -d $tmp/ORACLE/$db ]
then mkdir -p $tmp/ORACLE/$db
fi
tmpfile="'$tmp/ORACLE/$db/temp01.dbf'"
echo $tmpfile
echo "Please Enter The Size Of The Datafile In Megabytes"
read tmpsize
tmpsize1=`echo $tmpsize |tr -d '[a-z]'|tr -d '[A-Z]'`
C=`echo "datafile $tmpfile" size "$tmpsize1"M`
choice6=""
until [ -n "$choice6" ]
do
echo Please Enter The Location For The TOOLS Datafile
read tll 
if [ -d $tll ]
then choice6=TRUE
fi
done
if [ ! -d $tll/ORACLE/$db ]
then mkdir -p $tll/ORACLE/$db
fi
tllfile="'$tll/ORACLE/$db/tools01.dbf'"
echo $tllfile
echo "Please Enter The Size Of The Datafile In Megabytes"
read tllsize
tllsize1=`echo $tllsize |tr -d '[a-z]'|tr -d '[A-Z]'`
D=`echo "datafile $tllfile" size "$tllsize1"M`
choice7=""
until [ -n "$choice7" ]
do
echo Please Enter The Location For The USERS Datafile
read usr 
if [ -d $usr ]
then choice7=TRUE
fi
done
if [ ! -d $usr/ORACLE/$db ]
then mkdir -p $usr/ORACLE/$db
fi
usrfile="'$usr/ORACLE/$db/users01.dbf'"
echo $usrfile
echo "Please Enter The Size Of The Datafile In Megabytes"
read usrsize
usrsize1=`echo $usrsize |tr -d '[a-z]'|tr -d '[A-Z]'`
E=`echo "datafile $usrfile" size "$usrsize1"M`
choice8=""
until [ -n "$choice8" ]
do
echo Please Enter The Path Of Redo Log Files
read redo
if [ -d $redo ]
then choice8=TRUE
fi
done
if [ ! -d $redo/ORACLE/$db ]
then mkdir -p $redo/ORACLE/$db
fi
r1="'$redo/ORACLE/$db/redo01.log'"
r2="'$redo/ORACLE/$db/redo02.log'"
r3="'$redo/ORACLE/$db/redo03.log'"
echo "Please Enter The Size Of The Redo Log Files - suffix with a 'k' or 'm'"
read redosize
echo $r1 size $redosize,
echo $r2 size $redosize,
echo $r3 size $redosize
echo " Starting Database Creation ...."
echo " Please Wait - It will take appx 15 mins - grab a coffee !"
$ORACLE_HOME/bin/svrmgrl <<EOF
spool $ORACLE_BASE/admin/$db/create/createdb.log
connect internal
startup nomount pfile=$ORACLE_BASE/admin/$db/pfile/init$db.ora
create database "$db"
    maxinstances 1
    maxlogfiles  16
    maxdatafiles 200
    character set "US7ASCII"
    $A
    logfile
 $r1 size $redosize,
 $r2 size $redosize,
 $r3 size $redosize ;
create rollback segment r0 tablespace system
storage (initial 16k next 16k minextents 2 maxextents 20);
alter rollback segment r0 online;
create tablespace rbs 
$B
default storage (
    initial      1m
    next         1m
    pctincrease    0
    minextents     10
);
create tablespace temp temporary 
$C
default storage (
    initial      1024k
    next         1024k
        pctincrease  0
maxextents unlimited
);
create tablespace tools 
 $D ;

create tablespace users
$E ;
create rollback segment r01 tablespace rbs;
create rollback segment r02 tablespace rbs;
create rollback segment r03 tablespace rbs;
create rollback segment r04 tablespace rbs;
 alter rollback segment r01 storage (optimal 10m);
 alter rollback segment r02 storage (optimal 10m);
 alter rollback segment r03 storage (optimal 10m);
 alter rollback segment r04 storage (optimal 10m);
alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;
alter rollback segment r0 offline;
drop rollback segment r0;
alter user sys temporary tablespace temp;
alter user system default tablespace tools temporary tablespace temp;
create user ops\$oracle
identified externally
default tablespace tools
temporary tablespace temp
quota unlimited on  tools;
grant dba to ops\$oracle;
connect sys/change_on_install ;
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/catblock.sql;
connect system/manager ;
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
 spool off
EOF
echo "Please Enter The Names Of The Dba's ....(eg. jack jill john )"
read dbalist
echo " Creating The Dba Accounts "
for i in $dbalist
do
sqlplus -s system/manager  <<EOF
create user ops\$$i identified externally
default tablespace users 
temporary tablespace temp
quota unlimited on users;
grant dba to ops\$$i;
EOF
done
echo Please enter the password for SYS
read pwd1
syspwd=$pwd1
sqlplus -s system/manager <<EOF
alter user sys identified by $syspwd ;
EOF
 echo "Password Set For SYS"
echo Please enter the password for SYSTEM
read pwd2
systempwd=$pwd2
sqlplus -s sys/$syspwd <<EOF
alter user system identified by $systempwd ;
EOF
 echo "Password Set For SYSTEM"
echo "Updating The Network Configuration Files"
echo "Amending Oratab ...."
if
        test -f /var/opt/oracle/oratab
        then
        ORATAB=/var/opt/oracle/oratab
        else
        ORATAB=/etc/oratab
fi
echo "Please Enter a Brief Description For The New Database"
read desc
dbcap=`echo $db | tr '[a-z]' '[A-Z]'`
cat >> $ORATAB <<EOF
$db:$ORACLE_HOME:Y:$desc:$dbcap
EOF
echo "Amending tnsnames.ora"
if
        test -f /var/opt/oracle/tnsnames.ora
        then
        TNS=/var/opt/oracle/tnsnames.ora
        else
        TNS=/etc/tnsnames.ora
fi
echo "Please Enter The TNS Alias ....."
read alias
echo "Updating tnsnames.ora ....."
cat >> $TNS  <<EOF
$alias =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = TCP)
          (PROTOCOL = TCP)
          (HOST = `hostname`)
          (PORT = 1640)
        )
    )
    (CONNECT_DATA =
      (SID = $db)
     )
  )
EOF
echo "tnsnames.ora updated"
echo " Please Copy The listener.ora file from /tmp to either"
echo " a) /etc - for IBM machines "
echo " b) /var/opt/oracle - for SUN machines "
cat >> /tmp/listener.ora <<EOF
`hostname` =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY=`hostname`)
        )
        (ADDRESS =
          (PROTOCOL = TCP)
          (HOST = `hostname`)
          (PORT = 1640)
        )
  )
 
STARTUP_WAIT_TIME_`hostname` = 0
CONNECT_TIMEOUT_`hostname` = 10
 
SID_LIST_`hostname` =
  (SID_LIST =
EOF
if
        test -f /var/opt/oracle/oratab
        then
        ORATAB=/var/opt/oracle/oratab
        else
        ORATAB=/etc/oratab
fi
cat $ORATAB | while read LINE
do
LISTENER_SID=`echo $LINE | awk -F: '{ print $1 }'`
LISTENER_HOME=`echo $LINE | awk -F: '{ print $2 }'`
cat >> /tmp/listener.ora <<EOC
 (SID_DESC =
      (SID_NAME = $LISTENER_SID)
      (ORACLE_HOME=$LISTENER_HOME)
    )
EOC
done
cat >> /tmp/listener.ora <<EOF
)
EOF
echo "Creating symbolic link "
 cd $ORACLE_HOME/dbs
ln -s $ORACLE_BASE/admin/$db/pfile/init$db.ora init$db.ora
if test $? -eq 0 ;
then echo  Symbolic Link Created
else echo Failed To Create Link
fi
echo "Do You Wish To Run The Database In ARCHIVELOG Mode ?"
read arcreply
if [ "$arcreply" = y -o "$arcreply" = Y ]
then
archchoice=""
until [ -n "$archchoice" ]
do
 echo "Please Enter The Disk To Hold the Archive Log Files"
        read arcdest
if [ -d $arcdest ]
then archchoice=TRUE
if [ ! -d $arcdest/ORACLE/$db/arch ]
then mkdir -p $arcdest/ORACLE/$db/arch
fi                        
echo "The LOG_ARCHIVE_DEST is $arcdest/ORACLE/$db/arch"
echo "log_archive_dest=$arcdest/ORACLE/$db/arch" >>$ORACLE_BASE/admin/$db/pfile/init$db.ora
echo "log_archive_start=TRUE" >>$ORACLE_BASE/admin/$db/pfile/init$db.ora
fi
done                                      
$ORACLE_HOME/bin/svrmgrl << EOF
connect internal
shutdown immediate
startup mount
alter database archivelog;
alter database open;
EOF
else exit
fi
echo "******** SCRIPT OVER *********"