In Oracle : TKPROF Utility in Oracle

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Errors (ORA-NNNNN)

-> ORA-00210: cannot open the specified control file

 

 ORA-00210: cannot open the specified control file

 

 

This message appears when one of the control file is missing (a control file was moved or removed from the disk). Also a hard disk could not be seen by the system.

 

This message could be seen when you start the database, when you shutdown the database and when the database is running. In fact when the database is trying to write something in the control files.

 

In this case the database cannot be in NOMOUNT state (this state needs the control files to be available).

 

SQL> shutdown immediate;
Database closed.
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u02/oracle/oradata/control02.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

 

What you have to do:

 

A. IF you have a valid control file (  I suppose you have it multiplexed :-)    ) and the /u02/oracle/oradata/control02.ctl missed file is no longer on the disk

 

1. Shutdown the database.

SQL> shutdown abort;
ORACLE instance shut down.

 

2. copy the control file from one valid location to the /u02/oracle/oradata/

cp /u01/oracle/oradata/control01.ctl /u02/oracle/oradata/control02.ctl

 

3. Startup database

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 616566616 bytes
Database Buffers 444596224 bytes
Redo Buffers 5554176 bytes
Database mounted.
Database opened.

 

Note: If you don't know where the control files are on the disks, you can see these locations in alert.log . Each time the database is started these locations are written in alert.log. This is something you can see:

 

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options.
Using parameter settings in server-side pfile /u01/oracle/OHome11gR2/dbs/initdb11g.ora
System parameters with non-default values:
processes = 150
memory_target = 1G
control_files = "/u01/oracle/oradata/control01.ctl"
control_files = "/u02/oracle/oradata/control02.ctl"
control_files = "/u03/oracle/oradata/control03.ctl"

db_block_size = 8192
log_archive_dest_1 = "location=/u01/oracle/archive"
log_archive_format = "log_%r_%t_%S.arc"
db_recovery_file_dest = "/u01/oracle/flash_recovery_area"
db_recovery_file_dest_size= 2G
audit_file_dest = "/u01/oracle/admin/db11g/adump"
db_name = "db11g"
diagnostic_dest = "/u01/oracle"

 

 

 

 

In-Oracle.com  -> Oracle DBA -> Oracle Errors (ORA-NNNNN)

-> ORA-00210: cannot open the specified control file

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.