Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Wednesday, December 15, 2010

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

No comments: