DbaNotePad

Oracle APPS DBA Blog

11g ORA-15061: ASM operation not supported [41] with unpatched PSU2 ASM

Posted by dbanotepad on April 5, 2010

On our 11.1.0.7 Instance using Solaris SPARC 64 bit OS was trying to add datafiles to existing tablespace and it was erroring out:

SQLPUS> alter tablespace TSNAME add datafile ‘+SID_DG_DG’ size 32m;
alter tablespace TSNAME add datafile ‘+SID_DG_DG’ size 32m
*
ERROR at line 1:
ORA-19510: failed to set size of 4096 blocks for file “+SID_DG_DG/SIDDG/datafile/tsname.680.715525589″ (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 4096 blocks
ORA-15061: ASM operation not supported [41]

Checked view v$asm_diskgroup and there was enough free space in the DG

We have SINGLE 11.1.0.7 ASM codetree and several RDBMS codetrees.

Several RDBMS Instances make use of common ASM Instance.

One of the RDBMS codetree was recently upgraded to PSU2 (while others were at PSU1) but corresponding ASM Instance was left un patched which caused this problem.

To resolve the issue have patched the ASM Instance to PSU2.

NOTE: This worked fine with PSU1 but looks like oracle made this more strict with PSU2.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: