connect "SYS"/"&&sysPassword" as SYSDBA
set echo on
spool C:\oraclexe\logs\CreateDB.log
shutdown;
startup nomount pfile="C:\oraclexe\oradata\ok\init.ora";
CREATE DATABASE ok
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'C:\oraclexe\oradata\ok\system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE 'C:\oraclexe\oradata\ok\sysaux01.dbf' SIZE 120M 
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\oraclexe\oradata\ok\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:\oraclexe\oradata\ok\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET JA16EUC
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('C:\oraclexe\oradata\ok\redo01.log') SIZE 102400K,
GROUP 2 ('C:\oraclexe\oradata\ok\redo02.log') SIZE 102400K,
GROUP 3 ('C:\oraclexe\oradata\ok\redo03.log') SIZE 102400K
USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";
create spfile='C:\oraclexe\app\oracle\product\10.2.0\server\database\spfileok.ora' FROM pfile='C:\oraclexe\oradata\ok\init.ora';
shutdown;
spool off
