You might get following error with 11gR1 or 11gR2 when you are trying to resize datafile:
Failed to commit: ORA-01237: cannot extend datafile 37 ORA-01110: data file 37: '+TESTDB_DATA0/testdb/datafile/testdata_01.dbf' ORA-17505: ksfdrsz:1 Failed to resize file to size 219136 blocks ORA-15061: ASM operation not supported [41]
a) Usually this is because you have separe homes for Oracle RDBMS and Grid Infra (clusterware (ASM uses this)). And you have different PSU upgrades installed in these Homes. You can check this with opatch. Run this in both homes and check that they got same PSU's installed:
opatch lsinventory -oh RDBMS_HOME
opatch lsinventory -oh GRID_HOME
More info about this can be seen in MOS document:
ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database home [ID 1070880.1]
b) But if there are same PSU installed in both Homes then problem is probably with relinking.
Patch (for example PSU) is not correctly relinked or there is OS update installed and it's have effected Grid Infra Home files so that they need to be relinked.
If you have Oracle RAC do following for all nodes one by one:
1) Stop first databases for the instance you are relinking then stop crs:
# GRID_HOME/bin/crsctl stop crs
2) Run following as root user:
# cd GRID_HOME/crs/install
# perl rootcrs.pl -unlock
3) Run following as the Oracle Grid Infrastructure for a Cluster owner:
$> export ORACLE_HOME=GRID_HOME
$> GRID_HOME/bin/relink
4) And run following as root user:
# cd GRID_HOME/rdbms/install/
# ./rootadd_rdbms.sh
# cd GRID_HOME/crs/install
# perl rootcrs.pl -patch
Then check that crs is up and running:# GRID_HOME/bin/crsctl check crs
After crs is started start databases and check that you can make resize operations again.
More info about this can be seen in MOS document:
ORA-15061: ASM Operation Not Supported [41] After Apply PSU #1 & PSU #2 [ID 1126113.1]
No comments:
Post a Comment