My Oracle Support Banner

ASM UPGRADE to 11.2 WITH ASMCA FAILED ON ORA-1507 (Doc ID 971500.1)

Last updated on JANUARY 24, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

CRS and ASM upgrade to 11.2 from 2 node RAC 10.2.0.4.
The ASM upgrade with ASMCA failed on ORA-1507: database not mounted

ASMCA was not able to verify the existing 10g ASM instances.

[main] [ 2009-10-29 12:49:09.813 CDT ] [OracleHome.getVersion:896] Homeinfo <ORACLE_HOME>,2
[main] [ 2009-10-29 12:49:10.823 CDT ] [OracleHome.getVersion:922] OracleHome.server.getVersion Version: 10.2.0.4.0
[main] [ 2009-10-29 12:49:10.824 CDT ] [OracleHome.getVersion:943] Current Version From Inventory: 10.2.0.4.0
[main] [ 2009-10-29 12:49:10.825 CDT ] [OracleHome.getVersion:948] using sqlplus: <ORACLE_HOME>/bin/sqlplus
[main] [ 2009-10-29 12:49:10.825 CDT ] [UsmcaLogger.logInfo:141] Role SYSDBA
[main] [ 2009-10-29 12:49:10.826 CDT ] [UsmcaLogger.logInfo:141] OS Auth true
[main] [ 2009-10-29 12:49:10.928 CDT ] [SQLEngine.done:2148] Done called
[main] [ 2009-10-29 12:49:10.930 CDT ] [UsmcaLogger.logException:171] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstanceRac:checkAndStartupInstance
[main] [ 2009-10-29 12:49:10.931 CDT ] [UsmcaLogger.logException:172] ORA-1507: database not mounted
.
[main] [ 2009-10-29 12:49:10.932 CDT ] [UsmcaLogger.logException:173] oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-1507: database not mounted
.
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:973)
oracle.sysman.assistants.usmca.backend.USMInstance.connectToASM(USMInstance.java:548)
oracle.sysman.assistants.usmca.backend.USMInstance.checkAndStartupInstance(USMInstance.java:568)
oracle.sysman.assistants.usmca.backend.USMInstanceRac.checkAndStartupInstance(USMInstanceRac.java:2668)
oracle.sysman.assistants.usmca.backend.USMInstanceRac.discoverASMInstance(USMInstanceRac.java:2383)
oracle.sysman.assistants.usmca.backend.USMInstance.initialize(USMInstance.java:248)
oracle.sysman.assistants.usmca.backend.USMInstanceRac.initialize(USMInstanceRac.java:275)
oracle.sysman.assistants.usmca.backend.USMInstance.getInstance(USMInstance.java:213)
oracle.sysman.assistants.usmca.service.UsmcaService.migrateASMInstance(UsmcaService.java:204)


Tried unsetting all Oracle related environment variables. not working.
Made sure the nodes were pinned. not working.
Tried applying <Patch 8288940>. not working.


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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.