set echo on

spool CreateDB.log

CREATE DATABASE TEST
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/u01/oracle/dbs/TEST/system_01.dbf' SIZE 400M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u03/oracle/dbs/TEST/temp_01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u03/oracle/dbs/TEST/undotbs_01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED 
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1 ('/u02/oracle/dbs/TEST/redo/redo_01a.log', '/u04/oracle/dbs/TEST/redo/redo_01b.log') SIZE 102400K,
GROUP 2 ('/u02/oracle/dbs/TEST/redo/redo_02a.log', '/u04/oracle/dbs/TEST/redo/redo_02b.log') SIZE 102400K,
GROUP 3 ('/u02/oracle/dbs/TEST/redo/redo_03a.log', '/u04/oracle/dbs/TEST/redo/redo_03b.log') SIZE 102400K;

spool off