Wednesday, April 20, 2011

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 4Create 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


No comments: