Home » RDBMS Server » Server Administration » Problem of creating Control File
Problem of creating Control File [message #52495] Fri, 26 July 2002 03:01 Go to next message
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
Re: Problem of creating Control File [message #52497 is a reply to message #52495] Fri, 26 July 2002 06:45 Go to previous messageGo to next message
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
Re: Problem of creating Control File [message #52505 is a reply to message #52495] Fri, 26 July 2002 08:11 Go to previous message
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
Previous Topic: Re: How to create a block out of a procedure
Next Topic: Re: snap shoot too old ora 01555
Goto Forum:
  


Current Time: Thu Dec 26 07:13:32 CST 2024