ORA-29701 from 10.2 databases after ASM upgraded to 11.2 in HP-UX Itanium (Doc ID 1323826.1)

Last updated on SEPTEMBER 05, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 05-Sep-2013***

Symptoms

non-RAC - 112010(asm) - 112010(db) - 10205(db) - HP-UX Itanium (11.31)

After migrating 10.2 ASM to 11.2, now only the 10.2 database instances error out with ORA-29701: unable to connect to Cluster Manager


10.2 database alert log:
~~~~~~~~~~~~~~~~~~~~~~~~
ALTER DATABASE MOUNT
Fri Mar 11 14:26:17 2011
ORA-00202: control file:
'+NSHDEVHORA01_DATA/devphrm4/controlfile/current.394.683466541'
ORA-17503: ksfdopn:2 Failed to open file
+NSHDEVHORA01_DATA/devphrm4/controlfile/current.394.683466541
ORA-15001: diskgroup "NSHDEVHORA01_DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager

10.2 database sqlplus session:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL> create tablespace test_asm datafile '+NSHDEVHORA01_DATA' size 10M;
create tablespace test_asm datafile '+NSHDEVHORA01_DATA' size 10M
*
ERROR at line 1:
ORA-01119: error in creating database file '+NSHDEVHORA01_DATA'
ORA-17502: ksfdcre:4 Failed to create file +NSHDEVHORA01_DATA
ORA-15001: diskgroup "NSHDEVHORA01_DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager


Additional information
~~~~~~~~~~~~~~~~~~~~~~~
* This is not affecting any of the 11.2 database instances or any non-ASM 10.2 database instances.
* Same OS software owner for all homes (11.2 asm_home, 11.2 or 10.2 db_home)
.

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