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\ora data\ocp\redo1. log','c:\oracle \oradata\ocp\re do2.log') SIZE 100,
GROUP 2 ('c:\oracle\ora data\ocp\redo3. log','c:\oracle \oradata\ocp\re do4.log') SIZE 100

datafile 'c:\oracle\orad ata\ocp\system0 1.dbf' size 500m
undo tablespace UNDO
datafile 'c:\oracle\orad ata\ocp\undotbs .dbf' SIZE 100M
default temporary tablespace TEMP
tempfile 'c:\oracle\orad ata\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\ora data\ocp\redo1. log','c:\oracle \oradata\ocp\re do2.log') SIZE 100,
GROUP 2 ('c:\oracle\ora data\ocp\redo3. log','c:\oracle \oradata\ocp\re do4.log') SIZE 100

datafile 'c:\oracle\orad ata\ocp\system0 1.dbf' size 500m
undo tablespace UNDO
datafile 'c:\oracle\orad ata\ocp\undotbs .dbf' SIZE 100M
default temporary tablespace TEMP
tempfile 'c:\oracle\orad ata\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:

[code=oracle]

select value from v$parameter where name = 'background_dum p_dest'

[/code]

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:

[code=oracle]

select value from v$parameter where name = 'background_dum p_dest'

[/code]

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\ocpA LRT.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_statistic s = TRUE
shared_pool_siz e = 46137344
large_pool_size = 1048576
java_pool_size = 33554432
control_files = c:\oracle\orada ta\ocp\CONTROL0 1.CTL, c:\oracle\orada ta\ocp\CONTROL0 2.CTL, c:\oracle\orada ta\ocp\CONTROL0 3.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_pa sswordfile= EXCLUSIVE
db_domain = localhost
instance_name = ocp
dispatchers = (PROTOCOL=TCP)( SER=MODOSE), (PROTOCOL=TCP)( PRE=oracle.auro ra.server.GiopS erver), (PROTOCOL=TCP)( PRE=oracle.auro ra.server.SGiop Server)
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=(PART IAL=YES)(PROTOC OL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PART IAL=YES)(PROTOC OL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PART IAL=YES)(PROTOC OL=TCP))'...
Mon Mar 03 10:02:12 2008
alter database mount exclusive
Mon Mar 03 10:02:14 2008
ORA-00202: controlfile: 'c:\oracle\orad ata\ocp\CONTROL 01.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\orad ata\ocp\CONTROL 01.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\orad ata\ocp\CONTROL 01.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\orad ata\ocp\system0 1.dbf' size 400m
undo tablespace undotbs
datafile 'c:\oracle\orad ata\ocp\undotbs .dbf' size 100m
default temporary tablespace temp
tempfile 'c:\oracle\orad ata\ocp\temp01. dbf' size 100m
logfile group 1('c:\oracle\or adata\ocp\redo1 .log','c:\oracl e\oradata\ocp\r edo2.log') size 100m,

group 2('c:\oracle\or adata\ocp\redo3 .log','c:\oracl e\oradata\ocp\r edo4.log') size 100m
_______________ _______________ _______________ ______
Giving same error. Plzzz give a solution. Waiting for reply