Oracle Database::Manually Database Creation In Linux

ORACLE DATABASE::MANUALLY DATABASE CREATION IN LINUX

THROUGH VI EDITOR

1.FIRST CREATE THE PARAMETER FILE (PFILE) IN $ORACLE_HOME/DBS/INIT{SID}.ORA .
Which Defines

(i) core dump dest location $ORACLE_BASE/ADMIN/{SID NAME FOLDER}/CDUMP

(ii) user dump dest location $ORACLE_BASE/ADMIN/{SID NAME FOLDER}/UDUMP

(iii) background dump dest location $ORACLE_BASE/ADMIN/{SID NAME FOLDER}/BDUMP

(iv) db_name

(v) control_file(s) location $ORACLE_BASE/ORADATA/{SID NAMEFOLDER}/.CTL(FILE(S))

(vi) undo_management parameter

(vii) compatibility parameter


2. CREATE THE BDUMP,CDUMP,UDUMP FOLDERS IN $ORACLE_BASE/ADMIN/ .

3. EXPORT ORACLE SID
Like

export oracle_sid={SID NAME}


4. SET THE TNSNAMES AND LISTENER FILE PROPERLY.
THROUGH SQLPLUS


5. STARTUP NOMOUNT WITH PFILE LOCATED AT $ORACLE_HOME/DBS/INIT{SID}.ORA .

6. CREATE DATABASE SCRIPT
Which includes

(i) datafile address and size $ORACLE_BASE/ORADATA/{SID NAME FOLDER}/

(ii) redo log groups(2) at $ORACLE_BASE/ORADATA/{SID NAME FOLDER}/

(iii) undo tablespace address and size $ORACLE_BASE/ORADATA/{SID NAME FOLDER}/

(iv) temporary tablespace file address and size $ORACLE_BASE/ORADATA/{SID NAME FOLDER}/


7.RUN THE CATPROC AND CATALOG PATCHES FROM $ORACLE_HOME/RDBMS/ADMIN FOLDER
Like @?/rdbms/admin/catproc.sql

And @?/rdbms/admin/catalog.sql


8.MOUNT THE DATABASE
alter database mount


9.OPEN THE DATABASE
alter database open


10.DATABASE IS READY FOR WORK
Done !!