Steps to create 11g R2 Database on NON-ASM Storage:

Create the below dir , With full permissions for OINSTALL [775]

-bash-4.1$  pwd

/scratch/app/oracle/oradata/IRT

-bash-4.1$ ls -tlRR

total 32

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:46 adump

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:46 bdump

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:46 cdump

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:46 udump

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:18 fra

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:18 datafiles

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:17 onlinelogfiles

drwxrwxr-x 2 orausr oinstall 4096 Nov 16 11:17 controlfiles

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

cat > initIRT.ora

db_name = IRT

db_block_size = 8192

memory_target = 1024M

memory_max_target = 1024M

processes = 300

control_files = (/scratch/app/oracle/oradata/IRT/controlfiles/control1.ctl,/scratch/app/oracle/oradata/IRT/controlfiles/control2.ctl,/scratch/app/oracle/oradata/IRT/controlfiles/control3.ctl)

job_queue_processes = 10

open_cursors = 300

fast_start_mttr_target = 500

undo_management = AUTO

undo_tablespace = UNDOTBS1

remote_login_passwordfile = EXCLUSIVE

CTRL+D

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

set the environment:

export ORACLE_SID=IRT

export ORACLE_BASE=/scratch/app/oracle

export ORACLE_HOME=/scratch/app/oracle/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

SQL> startup nomount;

ORACLE instance started.

SQL> show parameter db_name

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_name                              string      IRT

SQL> CREATE DATABASE IRT

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE

GROUP 1 ('/scratch/app/oracle/oradata/IRT/onlinelogfiles/redo01.log') SIZE 100M,

GROUP 2 ('/scratch/app/oracle/oradata/IRT/onlinelogfiles/redo02.log') SIZE 100M,

GROUP 3 ('/scratch/app/oracle/oradata/IRT/onlinelogfiles/redo03.log') SIZE 100M

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

DATAFILE '/scratch/app/oracle/oradata/IRT/datafiles/system01.dbf' SIZE 325M REUSE

EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/scratch/app/oracle/oradata/IRT/datafiles/sysaux01.dbf' SIZE 325M REUSE

DEFAULT TABLESPACE USERS DATAFILE

'/scratch/app/oracle/oradata/IRT/datafiles/users01.dbf' SIZE 325M REUSE

DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE

'/scratch/app/oracle/oradata/IRT/tempfiles/temp01.dbf' SIZE 20M REUSE

UNDO TABLESPACE undotbs1 DATAFILE

'/scratch/app/oracle/oradata/IRT/datafiles/undotbs01.dbf' SIZE 200M REUSE

AUTOEXTEND ON MAXSIZE 300M;

SQL> spool create_dd.lis

SQL> @?/rdbms/admin/catalog.sql

SQL> @?/rdbms/admin/catproc.sql

SQL> connect system/<password>

SQL> @?/sqlplus/admin/pupbld