ASM upgrade failure from 10.2 to 11.2/12.1 (Doc ID 1336812.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

1. asmca shows the following error message but ASM upgrade in single instance environment was successful.


[Thread-46] [ 2011-07-03 13:51:35.534 CEST ] [UsmcaLogger.logInfo:142] Unable to grant SYSASM to SYS user. The following error occured:
Unable to grant SYSASM to SYS user. The following error occured:
ORA-01034: ORACLE not available
..
[Thread-46] [ 2011-07-03 13:51:35.611 CEST ] [UsmcaLogger.logInfo:142] Adding ASMSNMP user failed. The following error occured:
Adding ASMSNMP user failed. The following error occured:
ORA-01034: ORACLE not available
..
[Thread-46] [ 2011-07-03 13:51:38.913 CEST ] [UsmcaLogger.logExit:123] Exiting oracle.sysman.assistants.usmca.backend.USMInstance Method : doASMUpgrade
[Thread-46] [ 2011-07-03 13:51:38.913 CEST ] [UsmcaLogger.logInfo:142] ASM instance configured in EM successfully
[Thread-46] [ 2011-07-03 13:51:38.913 CEST ] [UsmcaLogger.logExit:123] Exiting oracle.sysman.assistants.usmca.backend.USMInstance Method : upgradeASMInstance
[Thread-46] [ 2011-07-03 13:51:38.913 CEST ] [UsmcaLogger.logExit:123] Exiting oracle.sysman.assistants.usmca.model.UsmcaModel Method : performOperation



2. As a result of the error above, no user including ASMSNMP has been created in new ASM environment.

+ASM> select * from v$pwfile_users;
no rows selected

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms