My Oracle Support Banner

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

Last updated on AUGUST 22, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.