Database Creation

1. Decide where to store pfile, Datafile, Controlfile and Redo log file. For example here we decide to store those file in C:\

2. Create the folder in the following orders

bdump: Store Background process trace files.

cdump: Core dump files.

ddump: The dpdump directory has files created by the data pump export/import utility.

adump: The adump directory seems to be the area that Oracle ASM (automatic storage management) utility writes to.

pfile: Instance parameter files

udump: User SQL trace files

3. Copy an existing INIT.ORA file and paste it in pfile directory

4. Rename the file initdba1.ora

5. Password File Creation:

C:\>orapwd file=C:\oracle\product\10.2.0\db_1\database\pwddba1 password=admin entries=10

6. Instance Creation:

C:\>oradim -new -sid dba1 -intpwd admin -maxusers 10 -startmode auto -pfile C:\oracle\product\10.2.0\admin\dba1\pfile\initdba1.ora

7. Oracle Base, Home and SID Creation

C:\>set oracle_base=C:\oracle

C:\>set oracle_home=C:\oracle\product\10.2.0\db_1

C:\>set orcle_sid=dba1

C:\>sqlplus/nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 12 16:25:14 2010

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

SQL> connect sys/admin as sysdba

Connected.

SQL> startup nomount pfile='C:\oracle\product\10.2.0\admin\dba1\pfile\initdba1.ora';

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1247876 bytes

Variable Size 62915964 bytes

Database Buffers 96468992 bytes

Redo Buffers 7139328 bytes

8. Database Creation

SQL> create database dba1

controlfile reuse

logfile

group 1

('C:\oracle\product\10.2.0\oradata\dba1\redo1a.log',

'C:\oracle\product\10.2.0\oradata\dba1\redo1b.log') size 5m,

group 2

('C:\oracle\product\10.2.0\oradata\dba1\redo2a.log',

'C:\oracle\product\10.2.0\oradata\dba1\redo2b.log') size 5m

maxlogfiles 4

maxlogmembers 2

maxdatafiles 5

maxinstances 2

maxloghistory 0

datafile 'C:\oracle\product\10.2.0\oradata\dba1\system01.dbf' size 100

SYSAUX

datafile 'C:\oracle\product\10.2.0\oradata\dba1\sysaux01.dbf' size 50m

undo tablespace UNDOTBS1

datafile 'C:\oracle\product\10.2.0\oradata\dba1\utable01.dbf' size 10m

default temporary tablespace temp

tempfile 'C:\oracle\product\10.2.0\oradata\dba1\temp01.dbf' size 10m

character set we8iso8859p1;

Database created.

Maxlogfiles: maximum number of redo log groups that can be created for the database.

Maxlogmembers: maximum number of members for each group.

Maxdatafiles: Maximum number of datafile that can be created.

Maxinstances: The number of instances that can access a database concurrently.

Maxloghistory: specifies the maximum number of redo log files that can be recorded in the log history of the control file.

9. Executing Scripts

SQL>@C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catalog.sql

SQL>@C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catprc.sql