ASM upgrade failure from 10.2 to 11.2/12.1
(Doc ID 1336812.1)
Last updated on JANUARY 24, 2020
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
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 |