10g- to 11g dbua-upgrade failes with ora-16024

Hello,

when I start the migration process with database upgrade assistant (dbua),
the parameter LOG_ARCHIVE_DEST_1 is set to 'LOCATION=""' in the init.ora file on the new Oracle 11g Home.

In the further processing the following error occures:

Code:

---

"Error-Message: ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed"

---

The database is running in the NOARCHIVELOG-Mode.

How can I influence the setting of LOG_ARCHIVE_DEST_1 ???

Code:

---

OS: Win Server 2003 R2
DB1: 10.2.0.4
DB2: 11.2.0.2

---

I hope you can help me!

Christian

Please check bug#8225933

Hello,

it is very closed to!!!

but log_archive_dest_1 ist set from 'LOCATION=F:\oracle\flash_recovery_area\\ARCHIVELOG' to the following: 'LOCATION=""' and is written in one line.

When LOG_ARCHIVE_DEST_1 is reset I got the same behaviour.

Is there any other parameter who is influencing this behaviour?

Thank you in advance!

Hello,

has someone else an idea?

What steps do you prefer, to upgrade from Oracle 10.2.0.4 to 11.2.0.2 ?

The DB is more than one TB in size ...

So I dont want to use expdp/impdp.

Hello,

the solution of the mistery is:

The spfile parameter LOG_ARCHIVE_DEST was set to LOG_ARCHIVE_DEST='' !
So "SHOW PARAMETER" is showing nothing but in the spfile you can see the difference!

ALTER SYSTEM RESET LOG_ARCHIVE_DEST SCOPE=BOTH SID='*';

Regards,

Christian