DBUA Error – ORA-00205: Error in identifying Control file, check alertlog for more info

Issue:

While Upgrading Oracle Database from 11.2.0.4 to 12.1.0.2 using DBUA, I happened to see the error “ORA-00205: Error in identifying Control file, check alertlog for more info” as a Pop-up on the screen.

dbua_control

 

Cause:

The Path/Location of Controlfile may be a set to default path and Controlfile entry might be missing in Paramater file in 11g Database.

Resolution:

  1. Check the parameter “Control” in sqlplus,

SQL> sho parameter control

NAME                                                                             TYPE        VALUE

———————————— ———– ————————–control_file_record_keep_time                             integer         45

control_files                              string      /mnt/oracle/oradb/product/11.2.0.4/dbs/cntrloracle.dbf

control_management_pack_access       string      DIAGNOSTIC+TUNING

2. Cross check the Entry of Controlfile in Parameterfile,

$ cat initoracle.ora|grep control

*.control_file_record_keep_time=45

#*.control_files=’/mnt/oracle/oradata/fs01/cntrl01.dbf’,’/mnt/oracle/oradata/fs01/cntrl02.dbf’

The above mentioned line is commented in Parameter file.

3. Take a backup of Parameter file, uncomment the line “*.control_files” and copy the controlfile from $ORACLE_HOME/dbs to fs01,

$ cp -pr cntrloracle.dbf /mnt/oracle/oradata/fs01/cntrl01.dbf

$ cp -pr cntrloracle.dbf /mnt/oracle/oradata/fs01/cntrl02.dbf

4. Make sure to start the instance with the Modified Parameter file. Start the instance to cross check of Controlfile is pointing to right location.

SQL> sho parameter control

NAME                                 TYPE        VALUE

———————————— ———– ——————————

control_file_record_keep_time        integer     45

control_files                        string     /mnt/oracle/oradata/fs01/cntrl01.dbf, /mnt/oracle/oradata/fs01/cntrl02.dbf

5. Create spfile from pfile and start the database

SQL> create spfile from pfile;

File created.

6. Restart the database (11g), and re-initiate the DBUA for upgrading DB to 12c

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

Advertisements
This entry was posted in Oracle Database Upgrades. Bookmark the permalink.

One Response to DBUA Error – ORA-00205: Error in identifying Control file, check alertlog for more info

  1. RP says:

    Thanks….It helps…:)

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s