Home » RDBMS Server » Server Administration » ORA-01503:CREATE CONTROLFiLE failed
ORA-01503:CREATE CONTROLFiLE failed [message #142154] Thu, 13 October 2005 11:11 Go to next message
mitra fatolahi
Messages: 38
Registered: October 2002
Member
Hello,

I've been using Database Configuration Application to create Oracle 9i database so many times with no problem and I had also saved a couple of templates for future use.
For the first time after deleting my templates, I cannot create any database using the database configuration wizard with Oracle 9i Transaction processing template (Transaction_Processing.dbc).

I keep getting the following error:

ORA-01503:CREATE CONTROLFiLE failed
ORA-01565: error in identifying file 'c:\oracle\oradata\SSDB1\DRSYS01.DBF'
ORA-27041: unable to open file.

Please help!
Thank you,
-Mitra
Re: ORA-01503:CREATE CONTROLFiLE failed [message #142306 is a reply to message #142154] Fri, 14 October 2005 02:03 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Error says:
ORA-01565: error in identifying file 'c:\oracle\oradata\SSDB1\DRSYS01.DBF'
ORA-27041: unable to open file.


check if the file exists in the specified path.

--Girish
Re: ORA-01503:CREATE CONTROLFiLE failed [message #142440 is a reply to message #142306] Fri, 14 October 2005 10:26 Go to previous messageGo to next message
mitra fatolahi
Messages: 38
Registered: October 2002
Member
I checked before posting the question, the file does not exist (
'c:\oracle\oradata\SSDB1\DRSYS01.DBF').

What I don't understand is what could had happened to cause this problem. I didn't have any problem creating any of the pervious 10 databases I created using Database Configuration Assistance. This happened right after I deleted two of my own database templates. I appreciate if you could help me to resolve the problem.

Thank you,
-Mitra
Re: ORA-01503:CREATE CONTROLFiLE failed [message #142877 is a reply to message #142440] Tue, 18 October 2005 02:14 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
I am not sure, but by the looks of it, it appears when you are creating a controlfile, oracle checks the existence of files referenced, i.e. whether the files are actually existing or not. & this may be the cause for you getting this error.

Expert comments awaited on this reasoning!!!!

--Girish
Re: ORA-01503:CREATE CONTROLFiLE failed [message #176098 is a reply to message #142877] Tue, 06 June 2006 23:55 Go to previous messageGo to next message
swatiwalimbe
Messages: 1
Registered: June 2006
Junior Member
Hello

Have u got the solution for u r control file problem. I am having the same problem. If u have got any solution pls. send reply.



with regards
swati
Re: ORA-01503:CREATE CONTROLFiLE failed [message #176109 is a reply to message #176098] Wed, 07 June 2006 00:54 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


As Girish already suggested, Oracle is trying to locate the file and but the file does not exist physically. As you said that you deleted few templates, it could be an issue ( Razz ).

DBCA is only meant for beginners so try to create a database manually so that you can have better control over the commands used for database creation.


Regards


Previous Topic: Recovery
Next Topic: Please help me to upgrade from 8i rel 8.1.7 to 9i rel 9.2
Goto Forum:
  


Current Time: Tue Mar 19 05:40:47 CDT 2024