Find the command set to create the Oracle Database 10g:
please make sure that ORACLE HOME is set :
$ echo $ORACLE_HOME /orahome/product/10g
YOU CAN CHANGE THE PARAMETER AS PER YOUR REQUIREMENTS:
CREATE DATABASE TEST
LOGFILE GROUP 1 ('+TESTDATA','+TESTDATA') SIZE 500M,
GROUP 2 ('+TESTDATA','+TESTDATA') SIZE 500M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '+TESTDATA' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '+TESTDATA' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '+TESTDATA' SIZE 200M REUSE
UNDO TABLESPACE UNDOTBS1
DATAFILE '+TESTDATA'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;