Create database error.

[nibiranijum]

hello everyone.
I run a create database command in 9i. at the end it give the following error.

Oracle instance terminated, Disconnection forced.

can you please help me...?

For ur consideration i am giving here the command i applied:
create database ocp
logfile
GROUP 1 ('c:\oracle\oradata\ocp\redo1.log','c:\oracle\orad ata\ocp\redo2.log') SIZE 100,
GROUP 2 ('c:\oracle\oradata\ocp\redo3.log','c:\oracle\orad ata\ocp\redo4.log') SIZE 100

datafile 'c:\oracle\oradata\ocp\system01.dbf' size 500m
undo tablespace UNDO
datafile 'c:\oracle\oradata\ocp\undotbs.dbf' SIZE 100M
default temporary tablespace TEMP
tempfile 'c:\oracle\oradata\ocp\temp01.dbf' SIZE 100M;

[amitpatel66]

hello everyone.
I run a create database command in 9i. at the end it give the following error.

Oracle instance terminated, Disconnection forced.

can you please help me...?

For ur consideration i am giving here the command i applied:
create database ocp
logfile
GROUP 1 ('c:\oracle\oradata\ocp\redo1.log','c:\oracle\orad ata\ocp\redo2.log') SIZE 100,
GROUP 2 ('c:\oracle\oradata\ocp\redo3.log','c:\oracle\orad ata\ocp\redo4.log') SIZE 100

datafile 'c:\oracle\oradata\ocp\system01.dbf' size 500m
undo tablespace UNDO
datafile 'c:\oracle\oradata\ocp\undotbs.dbf' SIZE 100M
default temporary tablespace TEMP
tempfile 'c:\oracle\oradata\ocp\temp01.dbf' SIZE 100M;

First I would recommend you to check your alert file for error:

Try this query to get the path where the alert file is stored:

 
select value from v$parameter where name = 'background_dump_dest'
 
 

Post your alert file information here for reference of our experts.

[nibiranijum]

First I would recommend you to check your alert file for error:

Try this query to get the path where the alert file is stored:

 
select value from v$parameter where name = 'background_dump_dest'
 
 

Post your alert file information here for reference of our experts.

Hey.. Thanx for instant reply...
Here is my arert file contents:

__________________________________________________ ______

Dump file c:\oracle\admin\ocp\bdump\ocpALRT.LOG
Mon Mar 03 10:02:09 2008
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = c:\oracle\oradata\ocp\CONTROL01.CTL, c:\oracle\oradata\ocp\CONTROL02.CTL, c:\oracle\oradata\ocp\CONTROL03.CTL
db_block_size = 4096
db_cache_size = 33554432
compatible = 9.0.0
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain = localhost
instance_name = ocp
dispatchers = (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer ), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServe r)
background_dump_dest = c:\oracle\admin\ocp\bdump
user_dump_dest = c:\oracle\admin\ocp\udump
core_dump_dest = c:\oracle\admin\ocp\cdump
sort_area_size = 524288
db_name = ocp
open_cursors = 300
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon Mar 03 10:02:10 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Mar 03 10:02:12 2008
alter database mount exclusive
Mon Mar 03 10:02:14 2008
ORA-00202: controlfile: 'c:\oracle\oradata\ocp\CONTROL01.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Mon Mar 03 10:02:14 2008
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 3168

__________________________________________________ _____





Waiting for reply.. thanxxxxxxxxx a lotttttttttt

[amitpatel66]

>>ORA-00202: controlfile: 'c:\oracle\oradata\ocp\CONTROL01.CTL'
>>ORA-27041: unable to open file
>>OSD-04002: unable to open file
>>O/S-Error: (OS 3) The system cannot find the path specified.

From the above lines, it seems that a control file is not created while creating a database. Check if the control file exists in a proper path as mentioned above

[nibiranijum]

>>ORA-00202: controlfile: 'c:\oracle\oradata\ocp\CONTROL01.CTL'
>>ORA-27041: unable to open file
>>OSD-04002: unable to open file
>>O/S-Error: (OS 3) The system cannot find the path specified.

From the above lines, it seems that a control file is not created while creating a database. Check if the control file exists in a proper path as mentioned above

__________________________________________________ _______
So, what is the solution of it. This time, I didnt change the path of Cotrol file in pfile (initocp.ora). I have another database named test. In oradata folder control file of test is present inside test folder.

After applying create database command i checked ocp folder where control01.ctl file is present.

So, how can i make control file or what should i do... Plzzzz tell me.
I applied this code:
create database ocp
controlfile reuse
datafile 'c:\oracle\oradata\ocp\system01.dbf' size 400m
undo tablespace undotbs
datafile 'c:\oracle\oradata\ocp\undotbs.dbf' size 100m
default temporary tablespace temp
tempfile 'c:\oracle\oradata\ocp\temp01.dbf' size 100m
logfile group 1('c:\oracle\oradata\ocp\redo1.log','c:\oracle\ora data\ocp\redo2.log') size 100m,

group 2('c:\oracle\oradata\ocp\redo3.log','c:\oracle\ora data\ocp\redo4.log') size 100m
__________________________________________________ _
Giving same error. Plzzz give a solution. Waiting for reply