Manual DB Creation Oracle 11g

- Create a Directory for Your Database(DB Name) in $ORACLE_BASE/oradata location.

- Create a Directory for Your Database(DB Name) in $ORACLE_BASE/flash_recovery_area

- Create a Directory for Your Database(DB Name) in $ORACLE_BASE/admin

- Create below dirs in $ORACLE_BASE/admin/DBNAME dirs

adump

dpdump

pfile

- Copy  /u01/app/oracle/admin/orcl/pfile/init.ora.999 To $ORACLE_BASE/admin/<DBlocationDir>/pfile

--- Rename (mv) "init.ora.123456" file in $ORACLE_BASE/admin/<DBlocationDir>/pfile

...TO...init.ora

--- IN pfile as above mention ------change the name of database name parameter

-- cp init.ora to init<dbname>.ora.... then....

--- IN DBS..open in VI init<dbname>.ora   ---change the name of database name parameter

change ORACLE_BASE parameter in this file with installation base path.

In $ORACLE_HOME/dbs....

$ orapwd file=$ORACLE_HOME/dbs/orapw<dbname> password=sys

--- export ORACLE_SID=<dbname>

-- sqlplus /  as sysdba

-- before startup instance...SQL> create spfile from pfile;

--- Startup nomount 

--- Create database 

SQL>  create database <dbname>

datafile '/u01/app/oracle/oradata/<dbname>/system01.dbf' size 100m autoextend on

sysaux datafile '/u01/app/oracle/oradata/<dbname>/sysaux01.dbf' size 100m autoextend on

logfile group 1 ('/u01/app/oracle/oradata/<dbname>/redo01a.log') size 4m,

group 2 ('/u01/app/oracle/oradata/<dbname>/redo02a.log') size 4m

default temporary tablespace temp

tempfile '/u01/app/oracle/oradata/<dbname>/temp01.tmp' size 100m

undo tablespace undotbs1

datafile '/u01/app/oracle/oradata/<dbname>/undotbs01.dbf' size 100m

--- run these two script

SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql

SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql