Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00210: cannot open the specified controlfile

user12039257Aug 7 2015 — edited Aug 10 2015

Hi All ,

I was working on my database and was able to insert /truncate and delete also . however i was not able to create objects . As soon as i created one .i got an error ORA-00210: cannot open the specified controlfile.

How did this happen ???

my database did not have any controlfiles and database was still working . opened a ticket with Oracle and the lady was confused and called me and said its not possible for a database to run but she was not ready to give this to me in writing .

Attached image clearly shows error while trying to create .

i checked and didnt find any controlfiles .

she was unable to tell me how oracle internals works and how this happened .

Does anyone else have an explanation for this .

This is possible .. system was working and without controlfiles .

before saying no ..i would request please do a testing .

output.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2015
Added on Aug 7 2015
17 comments
11,446 views