Manually Creating an Oracle 11g Database

Creating manually oracle 11g database is just the same as 10g . Here are steps to create the oracle Database manually .

Step 1:  Create initialization parameter file name 
Create initialization parameter file name as initdelhi.ora .Below are the contents of my initdelhi.ora:-

audit_file_dest='D:\oracle\admin\delhi\adump'

compatible='11.1.0.0.0'

control_files='D:\ORACLE\ORADATA\DELHI\CONTROL01.CTL'

db_block_size=8192

db_name='delhi'

diagnostic_dest='D:\oracle'

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

Step 2 :  Create Oracle service

C:\>  oradim    -new    -sid    delhi    -startmode  m     -intpwd    oracle 

 Instance created.

Step 3: Create the folder 
Create the folder as specified location in pfile (i.e in oradata and admin folder) .

Step 4:  Create Database

C:\>set ORACLE_SID=delhi

C:\>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Apr 20 12:43:03 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='D:\oracle\admin\delhi\pfile\initdelhi.ora';

ORACLE instance started.

Total System Global Area  150667264 bytes

Fixed Size                  1331740 bytes

Variable Size              92278244 bytes

Database Buffers           50331648 bytes

Redo Buffers                6725632 bytes

SQL>  create database

  2  datafile 'D:\oracle\oradata\delhi\system01.dbf' size 1G

  3  sysaux datafile 'D:\oracle\oradata\delhi\sysaux.dbf' size 800M

  4  UNDO TABLESPACE "UNDOTBS1"

  5  DATAFILE 'D:\oracle\oradata\delhi\UNDOTBS01.DBF' size 200m

  6  LOGFILE group 1 'D:\oracle\oradata\delhi\REDO01.LOG' SIZE 100M,

  7  group 2'D:\oracle\oradata\delhi\REDO02.LOG' SIZE 100M,

  8  group 3'D:\oracle\oradata\delhi\REDO03.LOG' SIZE 100M;

Database created.

Step 5 : Run the following scripts

C:\>@ D:\oracle\product\11.1.0\db_1\RDBMS\ADMIN\catalog.sql
C:\>@ D:\oracle\product\11.1.0\db_1\RDBMS\ADMIN\catproc.sql

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

--------- ----------

DELHI     READ WRITE

SQL> select program from v$session;

PROGRAM

sqlplus.exe

ORACLE.EXE (q000)

ORACLE.EXE (QMNC)

ORACLE.EXE (W000)

ORACLE.EXE (FBDA)

ORACLE.EXE (SMCO)

ORACLE.EXE (DBRM)

ORACLE.EXE (PMON)

ORACLE.EXE (DIAG)

ORACLE.EXE (DBW0)

ORACLE.EXE (CKPT)

ORACLE.EXE (SMON)

ORACLE.EXE (RECO)

ORACLE.EXE (MMON)

ORACLE.EXE (MMNL)

ORACLE.EXE (LGWR)

ORACLE.EXE (VKTM)

ORACLE.EXE (DIA0)

ORACLE.EXE (MMAN)

ORACLE.EXE (PSP0)

sqlplus.exe

21 rows selected.

Enjoy         J J J