Manual Creation of Database for RAC and Non RAC in 11gR2 environments steps wise.

1)       Create pfile in $ORACLE_HME/dbs 

2)       Create all the required directory in system.

a.       adump

b.       cdump

c.        diag

3)       create password file if required.

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw<SID> password=xxxxxx entries=5

4)       Check the FS where you are going to create datafile

5)       Create database as like below:

create database <Instance Name>

    USER SYS IDENTIFIED BY <password>

    USER SYSTEM IDENTIFIED BY <password>

    MAXLOGFILES 10

    MAXLOGMEMBERS 2

    MAXDATAFILES 200

    MAXINSTANCES 1

    MAXLOGHISTORY 1

logfile

        group 1 ('</FS> /<Instance>/redo/redo1a.log','</FS> /<Instance>/redo/redo1b.log') size 400M,

        group 2 ('</FS> /<Instance>/redo/redo2a.log','</FS> /<Instance>/redo/redo2b.log') size 400M,

        group 3 ('</FS> /<Instance>/redo/redo3a.log','</FS> /<Instance>/redo/redo3b.log') size 400M,

        group 4 ('</FS> /<Instance>/redo/redo4a.log','</FS> /<Instance>/redo/redo4b.log') size 400M

datafile  '</FS> /<Instance>/data/system01.dbf' size 1000M

extent management local

sysaux datafile '</FS> /<Instance>/data/sysaux01.dbf' size 1000M

undo tablespace UNDOTBS1

datafile '</FS> /<Instance>/data/undotbs01.dbf' size 5000M

default temporary tablespace temp tempfile '</FS> /<Instance>/data/temp01.dbf' size 5000M

character set  AL32UTF8

national character set AL16UTF16;

6)       Run below scripts to create data dictionary.

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

connect system/manager

@?/sqlplus/admin/pupbld

For RAC there is one more script that need to run to create RAC Dictionary.

@?/rdbms/admin/catclust.sql

connect system/manager

@?/sqlplus/admin/pupbld

Conn /as sysdba

@?/rdbms/admin/utlrp.sql

Setting up database to using java

@?/javavm/admin/initjvm 

To enable the database in cluster mode:

create spfile='<Spfile_path_RAW_device>.ora' from pfile;

shutdown immediate;
startup;

alter system set cluster_database=true scope=spfile; 

(We can also update the init file with cluster enable with true option  and then create spfile)

shutdown immediate;

startup;

alter database add logfile thread 2

group 5  ('</FS> /<Instance>/redo/redo6a.log','</FS> /<Instance>/redo/redo6b.log') size 400M,

group 6 ('</FS> /<Instance>/redo/redo6a.log','</FS> /<Instance>/redo/redo6b.log') size 400M,

group 7 ('</FS> /<Instance>/redo/redo7a.log','</FS> /<Instance>/redo/redo7b.log') size 400M,

group 8 ('</FS> /<Instance>/redo/redo8a.log','</FS> /<Instance>/redo/redo8b.log') size 400M


alter database enable public thread 2;

create undo tablespace UNDOTBS2 datafile '</FS> /<Instance>/data/undotbs01.dbf' size 5000M

Register the database in cluster:

srvctl add database -d <DB_NAME> -o <$ORACLE_HOME>
srvctl add instance -d <DB_NAME> -i <Instance_Name> -n rac1
srvctl add instance -d <DB_NAME>  -i <Instance_Name> -n rac2
srvctl enable database -d <DB_NAME>
srvctl enable instance -d <DB_NAME>  -i <Instance_Name>
srvctl enable instance -d <DB_NAME>  -i <Instance_Name>

srvctl remove instance -d  <DB_NAME>  -i <Instance_Name>

srvctl remove instance -d  <DB_NAME>  -i <Instance_Name>

srvctl remove database -d <DB_NAME>  -o <$ORACLE_HOME>