Oracle 10g to 11g dbua-upgrade failes with ORA-16024

The following is the solution .

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=’*’;

or

Change in init.ora

Leave a Reply

Your email address will not be published. Required fields are marked *