10g/11g database creation manually

set time on timing on feed on
spool cr_db.log
CREATE DATABASE "RMANDR"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/oracle/RMAN/oradata/system1a.dbf' SIZE 1000M extent management local
SYSAUX DATAFILE '/oracle/RMAN/oradata/sysaux1a.dbf' SIZE 1000M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oracle/RMAN/oradata/temp1a.dbf' SIZE 1000M
extent management local uniform size 1m
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oracle/RMAN/oradata/undotbs1a.dbf' SIZE 1000M
LOGFILE
GROUP 1 ('/oracle/RMAN/oradata/log1a.dbf','/oracle/RMAN/oradata/log1b.dbf') SIZE 200M,
GROUP 2 ('/oracle/RMAN/oradata/log2a.dbf','/oracle/RMAN/oradata/log2b.dbf') SIZE 200M,
GROUP 3 ('/oracle/RMAN/oradata/log3a.dbf','/oracle/RMAN/oradata/log3b.dbf') SIZE 200M
USER SYS IDENTIFIED BY manager
USER SYSTEM IDENTIFIED BY manager
/



connect /as sysdba
spool dictionary.out
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catoctk.sql
@?/rdbms/admin/owminst.plb
@?/javavm/install/initjvm.sql
@?/xdk/admin/initxml.sql
@?/xdk/admin/xmlja.sql
@?/rdbms/admin/catjava.sql
@?/rdbms/admin/catexf.sql
@?/rdbms/admin/catclust.sql

connect SYSTEM/manager
spool sqlplus.log
@?/sqlplus/admin/pupbld.sql
@?/sqlplus/admin/help/hlpbld.sql helpus.sql
spool off

spool off