OraFAQ Forum: Server Administration » Problem of creating Control File

Home » RDBMS Server » Server Administration » Problem of creating Control File

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem of creating Control File [message #52495]

Fri, 26 July 2002 03:01

steph
Messages: 15
Registered: July 2002

Junior Member

Hello,

I've got with control file.
When I create my new database, I've got an error in the alertfile.log. theerror message is :

alter database "rep3" mount exclusive
Fri Jul 26 12:06:25 2002
ORA-00202: controlfile: 'D:databasesACCREP3controlcontrol_ACR301.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

but I've control directory and Files. all is good. I don't understand.
I've ever tested to change directory of control files and I've ever tested to change the name of control file, but I've the error

Thanks in advance

Steph

Report message to a moderator

Re: Problem of creating Control File [message #52497 is a reply to message #52495]

Fri, 26 July 2002 06:45

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

probably, when u are creating a new database..its expecting the control file should be there at that locaion...so check wether the Control file is present at the above location is with the same name or not...

sai

Report message to a moderator

Re: Problem of creating Control File [message #52505 is a reply to message #52495]

Fri, 26 July 2002 08:11

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

Hii,
I think when the new database is getting created, it was looking for the corresponding control file at the above location..so check it wether the control file with the same name is existing or not ...

Byee
sai

Report message to a moderator

Previous Topic:	Re: How to create a block out of a procedure
Next Topic:	Re: snap shoot too old ora 01555

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 21:45:20 CDT 2024