CreateDB.sql

connect SYS/&&sysPassword as SYSDBA
set echo on

spool /xfer/oracle/OraHome10g/assistants/dbca/logs/CreateDB.log

startup nomount pfile="/u01/oracle/10g/ILMG1/scripts/init.ora";

CREATE DATABASE "ILMG1"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/u01/oracle/10g/ILMG1/data/system01.dbf' 
   SIZE 300M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
   EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oracle/10g/ILMG1/data/sysaux01.dbf' 
   SIZE 120M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oracle/10g/ILMG1/tmp/temp01.dbf' 
   SIZE 20M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/u01/oracle/10g/ILMG1/tmp/undotbs01.dbf' 
   SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/u01/oracle/10g/ILMG1/redo/redo01a.log', 
                 '/u01/oracle/10g/ILMG1/redo/redo01b.log') SIZE 10M,
        GROUP 2 ('/u01/oracle/10g/ILMG1/redo/redo02a.log', 
                 '/u01/oracle/10g/ILMG1/redo/redo02b.log') SIZE 10M,
        GROUP 3 ('/u01/oracle/10g/ILMG1/redo/redo03a.log', 
                 '/u01/oracle/10g/ILMG1/redo/redo03b.log') SIZE 10M
USER SYS IDENTIFIED BY "&&sysPassword" 
USER SYSTEM IDENTIFIED BY "&&systemPassword";

spool off