Database Creation 10g Win - non ASM

The following will help you to create the database (non-ASM) on Windows environment

1- Create parameter file, all parameters are self explanatory. Create all the directories as per parameter file in your environment.

############################PARAMETER FILE#####################
control_files=("D:\FRATEST\FRADB\fracontrol01.ctl", "D:\FRATEST\FRADB\fracontrol02.ctl", "D:\FRATEST\FRADB\fracontrol03.ctl")
db_name = FRADB
db_block_size = 8192
sga_max_size = 1073741824
sga_target = 1073741824
background_dump_dest=D:\FRATEST\FRADB/admin/bdump
core_dump_dest=D:\FRATEST\FRADB/admin/cdump
user_dump_dest=D:\FRATEST\FRADB/admin/udump
audit_file_dest=D:\FRATEST\FRADB/adminظadmin/adump
undo_management=AUTO
###############################################################
2- Create the Instance

 C:\Documents and Settings\inam>oradim -new -sid FRADB -syspwd fradb123 -pfile D:\FRATEST\FRADB\pfile\initFRADB.ora

Instance created.

3- Start the Instance
C:\Documents and Settings\inam>set ORACLE_SID=FRADB

C:\Documents and Settings\inam>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 15 13:35:58 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to an idle instance.



SQL> startup nomount pfile=D:\FRATEST\FRADB\pfile\initFRADB.ora
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  1253124 bytes
Variable Size             264241404 bytes
Database Buffers          801112064 bytes
Redo Buffers                7135232 bytes
4- Create Database

SQL> create database fradb
  2    logfile   group 1 ('D:\FRATEST\FRADB\fraredo1.log') size 10M,
  3              group 2 ('D:\FRATEST\FRADB\fraredo2.log') size 10M,
  4              group 3 ('D:\FRATEST\FRADB\fraredo3.log') size 10M
  5    character set          WE8ISO8859P1
  6    national character set utf8
  7    datafile 'D:\FRATEST\FRADB\system.dbf'
  8              size 50M
  9              autoextend on
 10              next 10M maxsize unlimited
 11              extent management local
 12    sysaux datafile 'D:\FRATEST\FRADB\sysaux.dbf'
 13              size 50M
 14              autoextend on
 15              next 10M
 16              maxsize unlimited
 17    undo tablespace undotbs01
 18              datafile 'D:\FRATEST\FRADB\undotbs01.dbf'
 19              size 50M
 20    default temporary tablespace temp
 21              tempfile 'D:\FRATEST\FRADB\temp.dbf'
 22              size 30M
 23  /

Database created.

5- Create DD, Run following scripts

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