ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database home (Doc ID 1070880.1)

Last updated on APRIL 30, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.1.0 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-03-2013***

Symptoms

ORA-15061 reported when resizing/creating a datafile.

ERROR at line 1:
ORA-19510: failed to set size of 1280 blocks for file .........
ORA-17505: ksfdrsz:1 Failed to resize file to size 1280 blocks
ORA-15061: ASM operation not supported [41]

Another symptom is

ORA-00202: control file: '+DGESBP1_DATA01/esbp1/control01.ctl'
ORA-17505: ksfdrsz:1 Failed to resize file to size 1144 blocks
ORA-15061: ASM operation not supported [41]
Control file expansion from 1128 blocks to 1144 blocks denied by OS

Changes

Database PSU (9209238  or 9352237 )  is applied in RDBMS home. RDBMS and ASM home versions are:

RDBMS Version 11.1.0.7.3 (PSU 9352179 applied)
RDBMS Version 11.1.0.7.2 (PSU 9209238 applied)
RDBMS Version 11.2.0.1.1 (PSU 9352237 applied)
ASM Version 11.2, 11.1

For ASM Version 11.1:
It applies to all platforms.

For ASM Version 11.2:
Problem only applies to platforms:  Linux.x32, Linux.x64, or Solaris.SPARC(64-bit)

If patch.8898852 or a PSU (9209238  or 9352237 ) containing the fix for 8898852 is applied to the RDBMS home, but the equivalent fix is not applied in the Grid Infrastructure or ASM Home, ORA-15061 problem will happen for file operations. 

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