Friday, July 16, 2010

ORA-15061: ASM operation not supported

When ASM and RDBMS are in two seperate homes in 11gR1 and 11gR2
SQL> create tablespace test datafile '+DATA(datafile)' size 10m
2 ;
create tablespace test datafile '+DATA(datafile)' size 10m
*
ERROR at line 1:
ORA-19510: failed to set size of 1280 blocks for file
"+DATA/livedb/datafile/test.285.724527409" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 1280 blocks
ORA-15061: ASM operation not supported [41]
could be seen when RDBMS has been applied a PSU while ASM isn't.

To resovle apply the PSU to ASM Home as well.

Above has been observed in 11gR1.

What this means in 11gR2 is that before applying the PSU to RDBMS home have to wait and see if the patch for grid infrastructure is released, since as of 11gR2 grid home is also the ASM home.
metalink note 1070880.1 describes the issue in 11gR2.

Updated information for PSU 11.2.0.1.2 available on metalink note 1089071.1