REM * Set terminal output and command echoing on; log output of this script.
REM *
#set termout on
#set echo on
spool /home/oracle/admin/test/create/crdbtest.lst

REM * Start the <sid> instance (ORACLE_SID here must be set to <sid>).
REM *
connect internal
startup nomount pfile=/home/oracle/admin/test/pfile/inittest_0.ora

REM * Create the <dbname> database.
REM * SYSTEM tablespace configuration guidelines:
REM *   General-Purpose ORACLE RDBMS      5Mb
REM *   Additional dictionary for applications 10-50Mb
REM * Redo Log File configuration guidelines:
REM *   Use 3+ redo log files to relieve ``cannot allocate new log...'' waits.
REM *   Use ~100Kb per redo log file per connection to reduce checkpoints.
REM *
create database "test"
    maxinstances 8
    maxlogfiles  32
    character set "JA16SJIS"
    national character set "JA16SJISFIXED"
    datafile
 '/home/oracle/oradata/test/system01.dbf' size   80M
    logfile
 '/home/oracle/oradata/test/redotest01.log' size 500k,
 '/home/oracle/oradata/test/redotest02.log' size 500k,
 '/home/oracle/oradata/test/redotest03.log' size 500k;

disconnect
spool off