ORA-15061: ASM Operation Not Supported [41] After Apply PSU #1 & PSU #2 (Doc ID 1126113.1)

Last updated on JULY 24, 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 24-Jul-2013***

Symptoms

1) After apply PSU 1 (11.2.0.1.1 ) or  PSU 2 (11.2.0.1.2 ) on the Grid Infrastructure Oracle Home
customer is unable to resize an ASM datafile:


SQL> alter database datafile
'+DATA/brg13ed/datafile/ts_brg_users.1279.711064345' resize 560M;
alter database datafile '+DATA/brg13ed/datafile/ts_brg_users.1279.711064345'
resize 560M
*
ERROR at line 1:
ORA-1237: cannot extend datafile 4
ORA-1110: data file 4: '+DATA/brg13ed/datafile/ts_brg_users.1279.711064345'
ORA-17505: ksfdrsz:1 Failed to resize file to size 71680 blocks
ORA-15061: ASM operation not supported [41]




2) DB alertlog reports (alert_brg13ed1.log):

Mon Jun 07 11:27:57 2010
Stopping background process CJQ0
Mon Jun 07 12:30:28 2010
alter database datafile '+DATA/brg13ed/datafile/ts_brg_users.1279.711064345'
resize 536870915
ORA-1237 signalled during: alter database datafile
'+DATA/brg13ed/datafile/ts_brg_users.1279.711064345' resize 536870915...
Mon Jun 07 13:07:40 2010
alter database datafile '+DATA/brg13ed/datafile/ts_brg_users.1279.711064345'
resize 560m
ORA-1237 signalled during: alter database datafile
'+DATA/brg13ed/datafile/ts_brg_users.1279.711064345' resize 560m...
Mon Jun 07 13:49:50 2010
alter database datafile '+DATA/brg13ed/datafile/ts_brg_users.1279.711064345'
resize 800M
ORA-1237 signalled during: alter database datafile
'+DATA/brg13ed/datafile/ts_brg_users.1279.711064345' resize 800M...
Mon Jun 07 13:58:51 2010
alter database datafile '+DATA/brg13ed/datafile/ts_brg_users.1279.711064345'
resize 560M
ORA-1237 signalled during: alter database datafile
'+DATA/brg13ed/datafile/ts_brg_users.1279.711064345' resize 560M...
Mon Jun 07 14:25:43 2010



3) ASM alert.log does not report any problem.

Changes

PSU 1 (11.2.0.1.1 ) or PSU 2 (11.2.0.1.2 ) patchset was installed on the Grid Infrastructure Oracle 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