When ASM disk is specified as FRA. 11.2.0.3 's Dbua Hang
From:
11.2.0.3 Dbua hangs while specifying ASM Disk to FRA (document ID 1427179.1)
Suitable for:
Oracle Database Upgrade assistant-version 10.2.0.1 and later
Oracle Server-standard edition-version 10.2.0.1 and later
Oracle server-enterprise edition-version 10.2.0.1 and later
Information in this document applies to any platform.
Symptoms:
Dbua hangs if ASM disk is specified to FRA (Fast Recovery area).
Dbua Trace.log shows the following errors:
Exception in Thread "awt-eventqueue-0" Java.lang.NullPointerExceptionat Oracle.sysman.assistants.util.InstallUtils.compareVersion (installutils.java:266)---Note this line at Oracle.sysman.assistants.util.asm.ASMUtils.validateDiskGroup (asmutils.java:1154) at Oracle.sysman.assistants.dbma.backend.CloneValidator.isDiskGroupCompatible (clonevalidator.java:654) at Oracle.sysman.assistants.dbma.backend.CloneValidator.isRecoveryAreaValidated (clonevalidator.java:431) at Oracle.sysman.assistants.dbma.ui.OracleBasePage.doNext (oraclebasepage.java:956)
Reason:
While moving FRA to ASM disk, as a part of validation, Dbua compares disk group and RDBMS compatibilty. The validation fails with null pointer exception because the compatible parameter is not set in the Pfile (or spfile) of The source database.
How to resolve:
Set the compatible parameter in the pfile of the source database as shown below and rerun Dbua.
compatible=x.x.0.0
Where x.x.0.0 is the value of the compatible parameter set in the source database.
For example, if the source database was 10.2.0.5 then it could be set as:
compatible=10.2.0orcompatible=10.2.0.5
"Translated from MoS article" when specifying ASM disk as FRA, 11.2.0.3 's Dbua hang