Creating a database manually

Hi,
   
      I am trying to create a database manually in Oracle9i. Windows 2000 is the OS. There is a database already running.

These are the steps I followed ...

1. Shut down the database
2. Startup using an init.ora file

 These is the file I am using to start an instance
-----------------------------------------------------------------
   
Cache and I/O
db_block_size=4096
db_cache_size=33554432

open_cursors=300

background_dump_dest=D:\oracle\admin\test\bdump
core_dump_dest=D:\oracle\admin\test\cdump
timed_statistics=TRUE
user_dump_dest=D:\oracle\admin\test\udump
 
db_domain=""
remote_login_passwordfile=EXCLUSIVE
 
control_files=("D:\oracle\oradata\test\CONTROL01.CTL", "D:\oracle\oradata\test\CONTROL02.CTL", "D:\oracle\oradata\test\CONTROL03.CTL")
 
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
 
compatible=9.0.0
db_name=test
 
instance_name=test
 
java_pool_size=33554432
large_pool_size=1048576
shared_pool_size=33554432
 
processes=50
 
fast_start_mttr_target=300
 
sort_area_size=524288
 
undo_management=AUTO
undo_tablespace=UNDOTBS
 ------------------------------------------------------

I have given the database name as 'test'.

3. I started the instance by giving
    startup nomount pfile=d:\oracle\admin\test\init.ora
   
    It started an instance.

4. Then I gave


CREATE DATABASE test
LOGFILE GROUP 1 ('D:\oracle\oradata\test\redo01.log') SIZE 100M,
GROUP 2 ('D:\oracle\oradata\test\redo02.log') SIZE 100M,
GROUP 3 ('D:\oracle\oradata\test\redo03.log') SIZE 100M;

It started creating the control and redolog sucessfully then
it gave an error.

    ORA-01092: ORACLE instance terminated. Disconnection
forced.

Can anybody help me out in this problem Or please tell me the list of steps to be followed in manually creating the database.Start Free Trial