解决Oracle错误ORA-15061一例

最新推荐文章于 2024-04-01 14:59:27 发布

weixin_33841503

最新推荐文章于 2024-04-01 14:59:27 发布

阅读量250

点赞数

文章标签：数据库操作系统

一套Linux上的11.2.0.1系统，告警日志中出现以下错误:

ORA-00202: control file: '+DATA/controlfile/current.256.7446483424'
ORA-17505: ksfdrsz:1 Failed to resize file to size 612 blocks
ORA-15061: ASM operation not supported [41]
WARNING: Oracle Managed File +FRA in the recovery area is orphaned by the control file.
The control file can not keep all recovery area files due to space limitation.
krse.c
Archived Log entry 200 added for thread 1 sequence 200 ID 0x3739c2f0 dest 1:

RMAN backup failed with

Rman backup error:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 
ORA-19510: failed to set size of 6800 blocks for file "+FRA" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 6800 blocks
ORA-15061: ASM operation not supported [41]

[oracle@rh2 ~]$ oerr ora 15061
15061, 00000, "ASM operation not supported [%s]"
// *Cause:  An ASM operation was attempted that is invalid or not supported
//          by this version of the ASM instance.
// *Action: This is an internal error code that is used for maintaining
//          compatibility between software versions and should never be
//          visible to the user; contact Oracle support Services.
//

提交SR后，根据Oracle GCS确认为BUG:9788316:

1.The following error indicates that it failed to resize the controlfile to 612 blocks. If the DB_BLOCK_SIZE is 8192, 
then 612 blocks is not more than 5MB. According to the results of the query on V$ASM_DISKGROUP in 'results01.txt' file, 
the ASM diskgroup +DATA has 108605 MB free space. So, the ASM diskgroup +DATA has enough space for the 612 blocks.

2. By the way, please confirm whether you have recently applied PSU #1. Anyway, 
please try to relink the Oracle executables, as shown here. Before you run the "relink" command, 
make sure to shutdown both the ASM instance and target database.

$ORACLE_HOME/bin/relink all

3 After relinking the Oracle executables, please confirm whether you are still 
experiencing the same ORA-15061 error.

ORA-15061: ASM Operation Not Supported [41] After Apply PSU #1 (Doc ID 1126113.1)
ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database home (Doc ID 1070880.1)

Hdr: 9788316 11.2.0.1.1 RDBMS 11.2.0.1.0 ASM PRODID-5 PORTID-267 Abstract: AFTER APPLY PSU 1 (11.2.0.1.1) ON RDBMS HOME UNABLE TO RESIZE ASM DATAFILE. *** 06/07/10 02:09 pm *** ---- 3-1827355081 PROBLEM: -------- 1) After apply PSU 1 (11.1.0.2.1) on the 11.2.0.1.0 RDBMS 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. DIAGNOSTIC ANALYSIS: -------------------- (see below) WORKAROUND: ----------- None RELATED BUGS: ------------- REPRODUCIBILITY: ---------------- TEST CASE: ---------- STACK TRACE: ------------ SUPPORTING INFORMATION: ----------------------- 24 HOUR CONTACT INFORMATION FOR P1 BUGS: ---------------------------------------- DIAL-IN INFORMATION: -------------------- IMPACT DATE: ------------ *** 06/07/10 02:09 pm *** 4) I can confirm that at (Jun 07 10:55:59 EDT 2010) customer installed the Patch: 9355126 (on the Grid OH), which includes the fix for Bug: 8898852: ============================================================ Invoking OPatch 11.2.0.1.2 Oracle Interim Patch Installer version 11.2.0.1.2 Oracle Home : /u01/grid/oracle/product/grid Central Inventory : /u01/app/oracle/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 11.2.0.1.2 OUI version : 11.2.0.1.0 OUI location : /u01/grid/oracle/product/grid/oui ------------------------------------------------------------------------------ -- Installed Top-level Products (1): Oracle Grid Infrastructure 11.2.0.1.0 There are 1 products installed in this Oracle Home. Installed Products (87): There are 87 products installed in this Oracle Home. Interim patches (1) : Patch 9355126 : applied on Mon Jun 07 10:55:59 EDT 2010 Unique Patch ID: 12175902 Created on 5 Feb 2010, 07:38:30 hrs PST8PDT Bugs fixed: 8974548, 8898852 ============================================================ 5) Also, I can confirm that at (Mon May 03 00:01:14 EDT 2010) customer installed the 11.2.0.1.1 Patch Set Update (PSU #1) which include as well the patch for Bug: 8898852 (on the RDBMS OH): ============================================================ Invoking OPatch 11.2.0.1.2 Oracle Interim Patch Installer version 11.2.0.1.2 Oracle Home : /u01/app/oracle/product/11.2.0/db1 Central Inventory : /u01/app/oracle/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 11.2.0.1.2 OUI version : 11.2.0.1.0 OUI location : /u01/app/oracle/product/11.2.0/db1//oui ------------------------------------------------------------------------------ -- Installed Top-level Products (1): Oracle Database 11g 11.2.0.1.0 There are 1 products installed in this Oracle Home. Installed Products (134): . 11.2.0.1.0 There are 134 products installed in this Oracle Home. Interim patches (1) : Patch 9352237 : applied on Mon May 03 00:01:14 EDT 2010 Unique Patch ID: 12366369 Created on 6 Apr 2010, 05:03:41 hrs PST8PDT Bugs fixed: 8661168, 8769239, 8898852, 8801119, 9054253, 8706590, 8725286, 8974548 8778277, 8780372, 8769569, 9027691, 9454036, 9454037, 9454038, 8761974 7705591, 8496830, 8702892, 8639114, 8723477, 8729793, 8919682, 8818983 9001453, 8475069, 9328668, 8891929, 8798317, 8820324, 8733749, 8702535 8565708, 9036013, 8735201, 8684517, 8870559, 8773383, 8933870, 8812705 8405205, 8822365, 8813366, 8761260, 8790767, 8795418, 8913269, 8897784 8760714, 8717461, 8671349, 8775569, 8898589, 8861700, 8607693, 8642202 8780281, 9369797, 8780711, 8784929, 8834636, 9015983, 8891037, 8828328 8570322, 8832205, 8665189, 8717031, 8685253, 8718952, 8799099, 8633358 9032717, 9321701, 8588519, 8783738, 8796511, 8782971, 8756598, 9454385 8856497, 8703064, 9066116, 9007102, 8721315, 8818175, 8674263, 9352237 8753903, 8720447, 9057443, 8790561, 8733225, 9197917, 8928276, 8991997, 8837736 ============================================================ 6) But the problem persists: ============================================================ 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] ============================================================ 7) 11.2.0.1.1 Patch Set Update (PSU #1) should include the fix for bug: 8898852 (ORA-15061: ASM operation not supported [41]). This PSU contains a fix that adds an operation to the ASM protocol. The problem is that the PSU has been applied correctly to the RDBMS home, but the fix is not correctly applied to the ASM HOME. So either install that patch to the ASM HOME, or if that has been done check why it failed. A common reason for failure is a permission problem. Check bug 9711074 and its duplicates for more background. And check documentation bug 8629483 for the solution. How do I know the fix is not missing? This error message is the key: ORA-15061: ASM operation not supported [41] (especially with operation 41) If the patch was applied to the grid home, then probably the relink failed due to permission problems. ORA-15061: ASM Operation Not Supported [41] After Apply PSU #1 [ID 1126113.1] pplies to: Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ] Information in this document applies to any platform. Symptoms 1) After apply PSU 1 (11.2.0.1.1 ) 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 ) patchset was installed on the Grid Infrastructure Oracle Home Cause The PSU #1 (11.2.0.1.1 ) patch on the Grid Infrastructure Oracle Home was not correctly linked by opatch. The PSU #1 (11.2.0.1.1 ) patch on the Grid Infrastructure Oracle Home needs to be relinked. Solution Relink the PSU #1 patch on the Grid Infrastructure Oracle Home as follow: 1) Shutdown the database instances. 2) Shutdown the ASM instance. 3) Relink the Grid Infrastructure Oracle Home as follow: script /tmp/relink_GI.txt env | sort $ORACLE_HOME/bin/relink all exit 4) Startup the ASM instance. 5) Startup the databases. 6) Resize the datafile: SQL> alter database datafile '+DATA/brg13ed/datafile/ts_brg_users.1279.711064345' resize 560M;

该bug一般是由于对grid infrastructure实施了PSU 1 (11.2.0.1.1 )后，Oracle binary没有正确link导致的，可行的解决方案是relink all，但这需要重启instance!