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;