| ORA-01503:CREATE CONTROLFiLE failed [message #142154] |
Thu, 13 October 2005 11:11  |
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 #142440 is a reply to message #142306] |
Fri, 14 October 2005 10:26  |
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 |
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 #176109 is a reply to message #176098] |
Wed, 07 June 2006 00:54 |
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 (  ).
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
