Category Archives: Oracle

I am learning Oracle. All my lesson learned in Oracle

#ORACLE-1 Steps For Manual Database Creation for Oracle

This is my first post for oracle. I am learning it and here is the very basic work Creation Of Oracle Database. Ohh God So much of Work..!! I always miss at least some of it. 😛

DB2 database creation is way simpler than the oracle one.

So documenting steps I followed for the database creation:

Follow the following steps

1. Prepare the pfile File:-

    a. When an Oracle Instance is started, the characteristics of the Instance are established by parameters          specified within the initialization parameter file. These initialization parameters are either stored in a PFILE or    SPFILE. We commonly refer it as the INIT.ORA file. Specifically  I used the PFILE for my database creation.

    b. In pfile path for the parameters like control_file,db_recovery_file_dest,audit_file_dest,diagnostic_dest etc is     mentioned. During the manual db creation we need to manually create these paths as mentioned in pFile.

2. Setting the environment:-
Set the Oracle instance environment by exporting the ORACLE_SID,ORACLE_HOME etc.
e.g. : export ORACLE_SID=

Read the rest of this entry »

Leave a comment

Posted by on November 21, 2013 in Oracle


Tags: , , , ,