http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html
shutdown abort;
startup mount exclusive restrict;
drop database;
startup nomount;
CREATE DATABASE ask
USER SYS IDENTIFIED BY pwd
USER SYSTEM IDENTIFIED BY pwd
LOGFILE
GROUP 1 ('/home/oracle/oracle/product/10.2.0/oradata/askprod/redo01.log') SIZE 100M,
GROUP 2 ('/home/oracle/oracle/product/10.2.0/oradata/askprod/redo02.log') SIZE 100M,
GROUP 3 ('/home/oracle/oracle/product/10.2.0/oradata/askprod/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET CL8MSWIN1251
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/ask/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/ask/sysaux01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/home/oracle/oracle/product/10.2.0/oradata/ask/temp01.dbf'SIZE 300M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
UNDO TABLESPACE UNDOTBS1
DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/ask/undotbs01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
CREATE TABLESPACE USERS
DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/ask/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED,
'/home/oracle/oracle/product/10.2.0/oradata/ask/savefile.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
CREATE TABLESPACE RMAN
DATAFILE '/home/oracle/oracle/product/10.2.0/oradata/ask/rman01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;
@/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql;
@/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql;
@/home/oracle/oracle/product/10.2.0/db_1/sqlplus/admin/pupbld.sql;
@/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin/owminst.plb;
@/home/oracle/oracle/product/10.2.0/db_1/olap/admin/olap.sql SYSAUX TEMP;
@/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sql;
CREATE OR REPLACE DIRECTORY TEMP_DIR AS '/home/oracle/oracle/TEMP';
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/utlrp.sql;