Search This Blog

Friday, April 9, 2010

Upgrade db 11gr1 to 11gr2 on windows

Dear All,

I am upgrading database from 11gr1 to 11gr2 on windows 2003r2.
my database configured with DATA GUARD and i am upgrade PRIMARY DATABASE.
during the upgrade through DBUA getting error message 'ORA-16024 : LOG_ARCHIVE_DEST_1='LOCATION= XXXXX' CAN'T PARSED. AND upgrade process abort.
Actually this was happen due to bug.
Kindly find the below details.
Upgrading a 11.1.0.6 database which is part of Data Guard environment to
11.1.0.7 using dbua.

The log_archive_dest parameters are written on more than one line in the
11.1.0.6 database parameter file, for example.,

log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=testp"
log_archive_dest_2 = "SERVICE=p9secs ASYNC COMPRESSION=ENABLE
VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)
DB_UNIQUE_NAME=tests"

While upgrading to 11.1.0.7 using DBUA, these parameters are truncated to a
single line as below

log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST"
log_archive_dest_2 = "SERVICE=p9secs ASYNC COMPRESSION=ENABLE"

Since the init parameters are truncated by dbua, this has caused problems
with the rolling upgrade in the data guard environment for the customer


Bug: Bug 8225933: DBUA TRUNCATES INITIALIZATION PARAMETER(S)

1 comment:

Anonymous said...

I've already bookmark this article and will definitely refer this article to all my close friends and colleagues. Thanks for posting!