1. Decide where to store pfile, Datafile, Controlfile and Redo log
file. For example here we decide to store those file in C:\ 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.ora5. 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 CreationC:\>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 |