Create database Manually without DBCA

Create a new database manually without help of DBCA utility

1) Login with Oracle user or user which oracle software is installed on Operating System.

su - oracle

2) create a oradata directory structure & for trace directories

mkdir -p /u01/oradata/orcl
mkdir -p /u01/app/oracle/admin/orcl
cd /u01/app/oracle/admin/orcl
mkdir bdump cdump udump pfile adump

3) Create parameter file manually with mandatory parameters

vi initorcl.ora


Note: the parameter file name format must be init.ora, here i am going to create a database name as orcl and used initorcl.ora
Remember, this parameter file should be placed in $ORACLE_HOME/dbs
The order of the pfile read by oracle is
it will read spfile if its there in $ORACLE_HOME/dbs
if not read pfile if its there in $ORACLE_HOME/dbs
if not read the pfile given in prompt like startup pfile=”

4) Set oracle sid

export ORACLE_SID=orcl

Note the oracle_sid is case sensitive

5) set oracle home

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

6) set path variable

export PATH=/u01/app/oracle/product/11.2.0/db_1:$PATH

5) Create a password file

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/pwdorcl.ora password=oracle entries=5

6) start the instance

sqlplus / as sysdba
startup nomount

7) In SQLPLUS run the following statement for creating the database:

create database orcl
logfile group 1 ('/u01/oradata/orcl/redo1.log') size 100M,
            group 2 ('/u01/oradata/orcl/redo2.log') size 100M,
            group 3 ('/u01/oradata/orcl/redo3.log') size 100M
character set WE8ISO8859P1
national character set utf8
datafile '/u01/oradata/orcl/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/u01/oradata/orcl/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1 datafile '/u01/oradata/orcl/undotbs1.dbf' size 100M
default temporary tablespace temp tempfile '/u01/oradata/orcl/temp01.dbf' size 100M;

8) Create dictionary views

Sqlplus / as sysdba

9) Shutdown the database and restart

sqlplus / as sysdba
shut immediate

sqlplus / as sysdba

10) compile invalids objects


11) create a users tablespace

create tablespace users datafile '/u01/oradata/orcl/users.dbf' size 100m maxsize unlimited extent management local segment space management auto;

12) Create network files
cd /u01/app/oracle/product/11.2.0/db_1/network/admin
vi tnsnames.ora

DEMO =  
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))  
(SERVICE_NAME = orcl)  

in Listener.ora in sid_list

      (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

13) Start the listener

14) add entry in oratab


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s