Example script for creating a database using the oracle command line

Oracle command line to create a database sample script [SQL] set echo on spool D: \ oracle \ app \ admin \ ocp11g \ sctripts \ cteatedb. log startup nomount pfile "D: \ oracle \ app \ admin \ ocp11g \ sctrpts \ init. ora "; create database" ocp11g "maxinstances 8 maxloghistory 1 maxlogfiles 16 maxlogmembers 3 maxdatafiles 100 datafile 'd: \ oracle \ app \ oradata \ ocp11g \ system01.dbf 'size 300 m reuse autoextend on next 10240 k maxsize unlimited extent management local sysaux datafile 'd: \ oracle \ app \ oradata \ ocp11g \ sysaux01.dbf 'size 120 m reuse autoextend on next 10240 k maxsize unlimited smallfile default temporary tablespace temp tempfile 'd: \ oracle \ app \ oradata \ ocp11g \ temp01.dbf 'size 20 m reuse autoextend on next 640 k maxsize unlimited smallfile undo tablespace "undotbs1" datafile 'd: \ oracle \ app \ oradata \ ocp11g \ undotbs01.dbf 'size 200 m reuse autoextend on next 5120 k maxsize unlimited character set we8mswin1252 national character set al16utf16 logfile group 1 ('d: \ oracle \ app \ oradata \ ocp11g \ redo01.log ') size 51200 k, group 2 ('d: \ oracle \ app \ oradata \ ocp11g \ redo02.log') size 51200 k, group 3 ('d: \ oracle \ app \ oradata \ ocp11g \ redo03.log ') size 51200 k user sys identified by "& systemPassword" user system identified by "& systemPassword "; spool off