Oracle RDBMS 版本已經升級11.2.0.1.1的PSU, 但是Grid infrastructure 沒有此對應的PSU，還是11.2.0.1.0版本。

如此在resize 檔案時候報錯：

SQL> alter database datafile 37 resize 110M;
alter database datafile 37 resize 110M
*
ERROR at line 1:
ORA-01237: cannot extend datafile 37
ORA-01110: data file 37: '+DATADG1/cddwh01/datafile/vip_stage.326.747253621'
ORA-17505: ksfdrsz:1 Failed to resize file to size 14080 blocks
ORA-15061: ASM operation not supported [41]

檢視官方資料如下：

The reason for ORA-15061 is that fix for 8898852 is included in PSU which is installed in RDBMS home. However, ASM home (11.2) is unpatched.

The fix for 8898852 is important as it avoids a potential database corruption when ASM/RDBMS compatible parameters are advanced to >=11.1.

The Grid Infrastructure PSU for Solaris Sparc is not available. Patch.8898852 must be applied to the Grid Infrastructure home separately for this platform. Patch.8898852 is included in the merge patch. 9355126 for Grid home.

決定給GI home打補丁8898852 :

chndsora9:/ora/u01/oracle/product/11.2/grid/OPatch\> ./opatch lsinventory
Invoking OPatch 11.2.0.1.5

Oracle Home       : /ora/u01/oracle/product/11.2/grid
Central Inventory : /ora/u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.5
OUI version       : 11.2.0.1.0
OUI location      : /ora/u01/oracle/product/11.2/grid/oui
Log file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch2011-09-13_16-52-49PM.log

Patch history file: /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/lsinv/lsinventory2011-09-13_16-52-49PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.
chndsora9:/ora/u01/oracle/product/11.2/grid/OPatch\> cd /ora/u01/Oracle11gR2/8898852
chndsora9:/ora/u01/Oracle11gR2/8898852\> /ora/u01/oracle/product/11.2/grid/OPatch/opatch apply
Invoking OPatch 11.2.0.1.5

Oracle Home       : /ora/u01/oracle/product/11.2/grid
Central Inventory : /ora/u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.5
OUI version       : 11.2.0.1.0
OUI location      : /ora/u01/oracle/product/11.2/grid/oui
Log file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch2011-09-13_16-53-48PM.log

Patch history file: /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '8898852' to OH '/ora/u01/oracle/product/11.2/grid'

Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ora/u01/oracle/product/11.2/grid')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8898852' for restore. This might take a while...
Backing up files affected by the patch '8898852' for rollback. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/kfds.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/kff.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/kfio.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/kfio0.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/kfn.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/kfnc.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/kfns.o"
Updating archive file "/ora/u01/oracle/product/11.2/grid/lib/libserver11.a" with "lib/libserver11.a/ksfd.o"
Running make for target ioracle
ApplySession adding interim patch '8898852' to inventory

Verifying the update...
Inventory check OK: Patch ID 8898852 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8898852 are present in Oracle Home.

The local system has been patched and can be restarted.

OPatch succeeded.
chndsora9:/ora/u01/Oracle11gR2/8898852\> /ora/u01/oracle/product/11.2/grid/OPatch/opatch lsinventory
Invoking OPatch 11.2.0.1.5

Oracle Home       : /ora/u01/oracle/product/11.2/grid
Central Inventory : /ora/u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 11.2.0.1.5
OUI version       : 11.2.0.1.0
OUI location      : /ora/u01/oracle/product/11.2/grid/oui
Log file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch2011-09-13_16-57-00PM.log

Patch history file: /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /ora/u01/oracle/product/11.2/grid/cfgtoollogs/opatch/lsinv/lsinventory2011-09-13_16-57-00PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 8898852      : applied on Tue Sep 13 16:56:22 CST 2011
Unique Patch ID: 12572687
   Created on 10 May 2010, 09:19:54 hrs UTC
   Bugs fixed:
     8898852

--------------------------------------------------------------------------------

OPatch succeeded.
chndsora9:/ora/u01/Oracle11gR2/8898852\> sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 13 16:57:11 2011

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01031: insufficient privileges
SQL> conn / as sysasm
Connected to an idle instance.
SQL> startup
ASM instance started

Total System Global Area 284008448 bytes
Fixed Size                  2147392 bytes
Variable Size             256695232 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted

重新對RDBMS 的資料檔案做 resize, 就能正確執行了：

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1069252608 bytes
Fixed Size                  2154936 bytes
Variable Size             817897032 bytes
Database Buffers          243269632 bytes
Redo Buffers                5931008 bytes
Database mounted.
Database opened.
SQL> alter database datafile 37 resize 110M;

Database altered.

SQL>

11.2.0.1.0 ASM 不能resize 檔案

相關文章