Share |

ORA-00202: control file: '%s'

There was a problem with one of the control file of the Oracle database.

You need to check if the control files are still available to the system, and if they are not opened by another program, such as a virus scanner, ... 
SQL> select value from v$parameter where name='control_files';

VALUE
--------------------------------------------------------------------------------
/u01/app/oracle/product/11.2.0/dbs/cntrlORA112.dbf
Now, we remove the controlfile: 
SQL> host mv /u01/app/oracle/product/11.2.0/dbs/cntrlORA112.dbf /u01/app/oracle/product/11.2.0/dbs/cntrlORA112.dbf.old
And we try to do a database action that requires the controlfile, such as selecting from certain data dictionary views, or shutdown of the database: 
SQL> shutdown immediate

ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/dbs/cntrlORA112.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
You need to make sure (all) the control file(s) are available. If necessary, you need to restore from backup.
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-00202 Add your own message



At the moment there are no forum messages. You can add your own question.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: vu5qb84xj7p84quh4


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.