dbua Unexpected Error Occured

DBUA Fails : " Unexpected Error Occured", In Log : "Db_recovery_file_dest_size....Java.Util.NoSuchElementException" [ID 1469938.1] Applies to: Oracle Server - Enterprise Edition - Version 10.2.0.4 to 11.2.0.3 [Release 10.2 to 11.2] Information in this document applies to any platform. Symptoms Database Upgrade Assistant (DBUA)  stops during the upgrade of database to 11.2.0.2 . Error returned by DBUA :  " Unexpected error occured. Look at the log file for more details " $ORACLE_BASE/cfgtoollogs/dbua/trace.log shows : [Thread-19] [ 2012-06-21 05:55:07.750 IST ] [InitParamAttributes.loadInitParams:1975]  DBParameter created:=db_name = test [Thread-19] [ 2012-06-21 05:55:07.750 IST ] [InitParamAttributes.loadInitParams:1975]  DBParameter created:=db_recovery_file_dest_size = 4039114752 java.util.NoSuchElementException     at java.util.StringTokenizer.nextToken(StringTokenizer.java:332)     at oracle.sysman.assistants.util.attributes.InitParamAttributes.loadInitParams(InitParamAttributes.java:1967)     at oracle.sysman.assistants.dbma.backend.Database.updateNonDefaultInitParams(Database.java:1175)     at oracle.sysman.assistants.dbma.backend.CompManager.obtainGenericDbInfo(CompManager.java:2449)     at oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:4181)     at oracle.sysman.assistants.dbma.ui.DatabasesPage.doProcessing(DatabasesPage.java:810)     at oracle.sysman.assistants.util.WaitDialog.run(WaitDialog.java:187)     at java.lang.Thread.run(Thread.java:595) Changes  Database Upgrade to 11.2.0.2 Cause Value is not set for db_recovery_file_dest ,it can be verified by the following statement : SQL> show parameter db_recovery% NAME                                 TYPE        VALUE ------------------------------------ ----------- ----------------------------- db_recovery_file_dest                string db_recovery_file_dest_size           big integer 3852M Solution If the server is started with spfile then use the following to specify the location : alter system set db_recovery_file_dest=...... scope=both;  Restart DBUA If the server is started with a pfile then  specify the location db_recovery_file_dest=...... in parameter file . If Flash Recovery is not used then the following parameters can be removed from pfile : db_recovery_file_dest db_recovery_file_dest_size Restart the Database and invoke DBUA again to perform the upgrade .   See also : DBUA 11.2.0.2 Fails With "Unexpected error occured: Look at the log file for more details" [ID 1306326.1] .....This implies that there is a problem with the definition of the log_archive_dest_10 parameter In this case, the definition of the log_archive_dest_10 parameter was split over multiple lines of the init.ora/spfile.ora The same error could occur with definition of other parameters which are split over multiple lines Solution 1. Either unset the parameter or change the definition of the parameter so that it is on one line (not multiple lines) 2. Upgrade the database using DBUA