Error on DBUA - Upgrade 10.2.0.4 to 11.2.0.2

[Former Member]

Hi All,

I have an issue with DBUA.

The Database Upgrade Assistant has been executed, and after click on "FINISH" the X-Session finished with an unexpected error.

I check the log directory:

AUSR3DCI:~ # cd /oracle/cfgtoollogs/dbua/UE1/upgrade1

AUSR3DCI:/oracle/cfgtoollogs/dbua/UE1/upgrade1 # ls -ltr

total 176

-rw-r----- 1 oraue1 dba 1962 Jul 4 11:07 upgrade.xml

-rw-r----- 1 oraue1 dba 1127 Jul 4 11:07 Upgrade_Directive.log

-rw-r----- 1 oraue1 dba 3044 Jul 4 11:07 mapfile.txt

-rw-r----- 1 oraue1 dba 469 Jul 4 11:19 SpaceUsage.txt

-rw-r----- 1 oraue1 dba 5550 Jul 4 11:19 PreUpgradeResults.html

-rw-r----- 1 oraue1 dba 46025 Jul 4 11:20 sqls.log

-rw-r----- 1 oraue1 dba 488 Jul 4 11:20 PreUpgrade.log

-rw-r----- 1 oraue1 dba 91767 Jul 4 11:20 trace.log

-rw-r----- 1 oraue1 dba 69 Jul 4 11:20 Oracle_Server.log

I tried to re-launch the DBUA, but this message appear:

"Database is not open. Restart database in open mode and try again"

I check the Oracle 10g DB, and I found the following ORA-messages:

ORA-00202: control file: '/oracle/UE1/origlogA/cntrl/cntrlUE1.dbf'

ORA-27086: unable to lock file - already in use

If I try to stop and start it again, the ORA-00202 and ORA-27086 appear, plus:

"ORA-00205: error in identifying control file, check alert log for more info"

The Oracle 11g DB start successfully.

Any idea ?

Thanks!

[Former Member]

>> The Oracle 11g DB start successfully.

Are you able to start the Oracle 11g, after these errors or not?

Best regards,

Orkun Gedik

[Former Member]

Hi Orkun Gedik,

I'm running the upgrade.. I have 2 intance, 10g and 11g.

The Upgrade didn't finish.

Because DBUA only works for a couple of minutes.

I check the 11g instance, and is up and running.

But the 10g instance, not.

Here the log:

SQL> startup

ORACLE instance started.

Total System Global Area 1124073472 bytes

Fixed Size 2083368 bytes

Variable Size 570426840 bytes

Database Buffers 536870912 bytes

Redo Buffers 14692352 bytes

ORA-00205: error in identifying control file, check alert log for more info

in the Alert log, error database not mounted appear.

Regards,

Juan.

[Former Member]

Hi Juan,

Take backup of your existing control files and execute the commands below;

Restart the Oracle service

>> sqlplus "/as sysdba"

startup nomount;

alter database mount;

recover database;

alter database open;

Best regards,

Orkun Gedik

[Former Member]

This error causes, because of one or more control files have been corrupted. At this stage, you can check the control files date and time whether one of them is created succesfully. Please note that they are mirror of each other. It means that, if you can find a correct control file, you can replace with the corrupted one.

Second solution is creating and executing control.sql. Then, executing the "alter database open resetlogs;" statement.

Best regards,

Orkun Gedik