REM THIS SCRIPT IS CUSTOMIZED FROM crdb.orc 
REM 
REM *********************** I M P O R T A N T *******************************
REM WHEN YOU CREATE A DATABASE, COPY THIS SCRIPT TO crdbTESTDB.sql and 
REM MODIFY ALL TESTDB OCCURENCES ON THIS FILE TO THE SID YOU WISH TO CREATE
REM MAKE SURE YOU HAVE ORACLE_HOME AND ORACLE_SID VALUES SET PROPERLY
REM 
REM TO CHANGE ALL TESTDB TO YOURDB IN vi, TYPE 
REM    1.  Esc
REM    2.  :
REM    3.  %s/TESTDB/YOURDB/g
REM **************************************************************************
REM
REM THIS SCRIPT CREATES THE DATABASE 
REM
REM **************************************************************************
REM STEP 1 : CREATE THE DATABASE
REM **************************************************************************
set termout on 
set echo on 
spool crdb1TESTDB.lst 

REM * Start the <sid> instance (ORACLE_SID here must be set to <sid>).
REM *
connect internal
startup nomount pfile=${ORACLE_HOME}/dbs/initTESTDB.ora

create database "TESTDB"
controlfile reuse
    maxinstances 8
    maxlogfiles 32 
    maxlogmembers 4
    maxdatafiles 9000
    character set "US7ASCII"
    datafile
        '/ora0/oradata/TESTDB/system01.dbf'  size   100M
    logfile
        group 1 ('/ora3/oradata/TESTDB/redo0101.log') size 5M,
        group 2 ('/ora4/oradata/TESTDB/redo0201.log') size 5M, 
        group 3 ('/ora3/oradata/TESTDB/redo0301.log') size 5M,
        group 4 ('/ora4/oradata/TESTDB/redo0302.log') size 5M;
disconnect
spool off

REM **************************************************************************