Wednesday, 28 September 2011

Create oracle database manualy 9i

I supposed that the Oracle Database Software is already installed.

1- Creat the required directories
    mkdir -p /OraData/drportal/CtlF    
    mkdir -p /OraData/drportal/DataF   
    mkdir -p /OraData/drportal/OnRdLog
    mkdir -p /oracle/OraHome9i/drportal/bdump
    mkdir -p /oracle/OraHome9i/drportal/cdump
    mkdir -p /oracle/OraHome9i/drportal/udump

2- Set the instance name:
export ORACLE_SID=DRPORTAL


3- create the init file /oracle/OraHome9i/dbs/initDRPORTAL.ora
control_files = (/OraData/drportal/CtlF/control01.ctl,
                 /OraData/drportal/CtlF/control02.ctl,
                 /OraData/drportal/CtlF/control03.ctl)
undo_management = auto
db_name         = DRPORTAL
instance_name   = DRPORTAL
db_block_size       = 8192
background_dump_dest = /oracle/OraHome9i/drportal/bdump
core_dump_dest = /oracle/OraHome9i/drportal/cdump
user_dump_dest = /oracle/OraHome9i/drportal/udump
COMPATIBLE=9.2.0
PROCESSES=150
UNDO_TABLESPACE=undotbs1


4- Start the instance

       sqlplus / as sysdba
       select  instance_name from v$instance;
       startup nomount pfile='/oracle/OraHome9i/dbs/initDRPORTAL.ora';

5- Create the database as the following:

CREATE DATABASE DRPORTAL
   USER SYS IDENTIFIED BY system12
   USER SYSTEM IDENTIFIED BY system12
   LOGFILE GROUP 1 ('/OraData/drportal/OnRdLog/redo01.log') SIZE 10M,
           GROUP 2 ('/OraData/drportal/OnRdLog/redo02.log') SIZE 10M,
           GROUP 3 ('/OraData/drportal/OnRdLog/redo03.log') SIZE 10M
   MAXLOGFILES 192
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 37394
   MAXDATAFILES 500
   MAXINSTANCES 32
   CHARACTER SET WE8ISO8859P1
   DATAFILE '/OraData/drportal/DataF/system.dbf' SIZE 300M REUSE
   EXTENT MANAGEMENT LOCAL
   DEFAULT TEMPORARY TABLESPACE temp
      TEMPFILE '/OraData/drportal/DataF/temp01.dbf'
      SIZE 500M REUSE
   UNDO TABLESPACE undotbs1
      DATAFILE '/OraData/drportal/DataF/undotbs01.dbf'
      SIZE 2000M REUSE AUTOEXTEND Off ;

6- Create the spfile for this database:
    create spfile from pfile;

7- Post steps for the database creation are to run:
-- As sys  user
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

No comments:

Post a Comment

Number of Visitors