首页 > 其他分享 >ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database

ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database

时间：2023-06-25 16:35:43浏览次数：43  
标签：applied 15061 RDBMS database 11.2 home ORA ASM PSU 

ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database home [ID 1070880.1] 
--------------------------------------------------------------------------------
 
  修改时间 26-OCT-2011     类型 PROBLEM     状态 PUBLISHED   
In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

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

Applies to: 
Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 to 11.2.0.1.0 - Release: 11.2 to 11.2
Information in this document applies to any platform.
Symptoms
ORA-15061 reported when resizing/creating a datafile. 
ERROR at line 1:
ORA-19510: failed to set size of 1280 blocks for file .........
ORA-17505: ksfdrsz:1 Failed to resize file to size 1280 blocks
ORA-15061: ASM operation not supported [41]

Another symptom is
ORA-00202: control file: '+DGESBP1_DATA01/esbp1/control01.ctl' 
ORA-17505: ksfdrsz:1 Failed to resize file to size 1144 blocks 
ORA-15061: ASM operation not supported [41] 
Control file expansion from 1128 blocks to 1144 blocks denied by OS
Changes
Database PSU (9209238  or 9352237 )  is applied in RDBMS home. RDBMS and ASM home versions are:
RDBMS Version 11.1.0.7.3 (PSU 9352179 applied)
RDBMS Version 11.1.0.7.2 (PSU 9209238 applied)
RDBMS Version 11.2.0.1.1 (PSU 9352237 applied)
ASM Version 11.2, 11.1
For ASM Version 11.1:
It applies to all platforms.
For ASM Version 11.2:
Problem only applies to platforms:  Linux.x32, Linux.x64, or Solaris.SPARC(64-bit)
If patch.8898852 or a PSU (9209238  or 9352237 ) containing the fix for 8898852 is applied to the RDBMS home, but the equivalent fix is not applied in the Grid Infrastructure or ASM Home, ORA-15061 problem will happen for file operations.  
Cause
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. 
Solution
Download patch 8898852 from My Oracle Support and install in the ASM home.
For ASM Version 11.1:
If ASM and RDBMS home executables are installed in a shared home, problem doesn't happen.
Latest PSU should be applied in ASM home if ASM executables are installed in a separate home. 

For ASM Version 11.2:
Bug 8898852 fix has been included in 11.2.0.2 for all the platforms. 
For Solaris.x64, AIX, HP-UX, and Windows platforms, bug fix has been included in 11.2.0.1.
 
1] For Linux x86 and Linux x86-64 on 11.2.0.1 
EITHER 
Apply 8898852 to GI Home plus PSU Patch 9654983 ( 11.2.0.1.2 ) to RDBMS Home 
OR 
Apply Grid Infrastructure PSU 9655006 ( 11.2.0.1.2 ) to both Grid and RDBMS Homes or the latest PSU. 
2] If the Database PSU has already been installed in the RDBMS Home, then the latest Grid Infrastructure PSU can still be installed to the Grid Infrastructure home. 
3] For Solaris Sparc on 11.2.0.1, apply the latest PSU 
We recommend to apply the very latest PSU to both the homes. 



References
BUG:8898852 - DATAFILE CORRUPTION WHEN FILE CREATED WITH COMPATIBLE.ASM LESS THAN 11 RESIZED
NOTE:965751.1 - Error ORA-1578 reported on the database after changing compatible.rdbms >= 11 and resizing a datafile
NOTE:1117514.1 - ORA-15061 Creating database even with RDBMS PSU#1 and GRID patch 8898852 applied
 相关内容

--------------------------------------------------------------------------------
产品 
--------------------------------------------------------------------------------
•Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition 
关键字 
--------------------------------------------------------------------------------
ASM; LINUX; PATCH; PSU; SOLARIS 
错误 
--------------------------------------------------------------------------------
ORA-202; ORA-1578; ORA-17505; ORA-19510; ORA-15061



ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database home [ID 1070880.1] 

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


 


  修改时间 26-OCT-2011     类型 PROBLEM     状态 PUBLISHED   

In this Document 

   Symptoms 

   Changes 

   Cause 

   Solution 

   References 


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


 Applies to: 

 Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 to 11.2.0.1.0 - Release: 11.2 to 11.2 

 Information in this document applies to any platform. 

 Symptoms 

 ORA-15061 reported when resizing/creating a datafile. 

 ERROR at line 1: 

 ORA-19510: failed to set size of 1280 blocks for file ......... 

 ORA-17505: ksfdrsz:1 Failed to resize file to size 1280 blocks 

 ORA-15061: ASM operation not supported [41] 


 Another symptom is 

 ORA-00202: control file: '+DGESBP1_DATA01/esbp1/control01.ctl' 

 ORA-17505: ksfdrsz:1 Failed to resize file to size 1144 blocks 

 ORA-15061: ASM operation not supported [41] 

 Control file expansion from 1128 blocks to 1144 blocks denied by OS 

 Changes 

 Database PSU (9209238  or 9352237 )  is applied in RDBMS home. RDBMS and ASM home versions are: 

 RDBMS Version 11.1.0.7.3 (PSU 9352179 applied) 

 RDBMS Version 11.1.0.7.2 (PSU 9209238 applied) 

 RDBMS Version 11.2.0.1.1 (PSU 9352237 applied) 

 ASM Version 11.2, 11.1 

 For ASM Version 11.1: 

 It applies to all platforms. 

 For ASM Version 11.2: 

 Problem only applies to platforms:  Linux.x32, Linux.x64, or Solaris.SPARC(64-bit) 

 If patch.8898852 or a PSU (9209238  or 9352237 ) containing the fix for 8898852 is applied to the RDBMS home, but the equivalent fix is not applied in the Grid Infrastructure or ASM Home, ORA-15061 problem will happen for file operations.  

 Cause 

 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. 

 Solution 

 Download patch 8898852 from My Oracle Support and install in the ASM home. 

 For ASM Version 11.1: 

 If ASM and RDBMS home executables are installed in a shared home, problem doesn't happen. 

 Latest PSU should be applied in ASM home if ASM executables are installed in a separate home. 


 For ASM Version 11.2: 

 Bug 8898852 fix has been included in 11.2.0.2 for all the platforms. 

 For Solaris.x64, AIX, HP-UX, and Windows platforms, bug fix has been included in 11.2.0.1. 

   

 1] For Linux x86 and Linux x86-64 on 11.2.0.1 

 EITHER 

 Apply 8898852 to GI Home plus PSU Patch 9654983 ( 11.2.0.1.2 ) to RDBMS Home 

 OR 

 Apply Grid Infrastructure PSU 9655006 ( 11.2.0.1.2 ) to both Grid and RDBMS Homes or the latest PSU. 

 2] If the Database PSU has already been installed in the RDBMS Home, then the latest Grid Infrastructure PSU can still be installed to the Grid Infrastructure home. 

 3] For Solaris Sparc on 11.2.0.1, apply the latest PSU 

 We recommend to apply the very latest PSU to both the homes. 




 References 

 BUG:8898852 - DATAFILE CORRUPTION WHEN FILE CREATED WITH COMPATIBLE.ASM LESS THAN 11 RESIZED 

 NOTE:965751.1 - Error ORA-1578 reported on the database after changing compatible.rdbms >= 11 and resizing a datafile 

 NOTE:1117514.1 - ORA-15061 Creating database even with RDBMS PSU#1 and GRID patch 8898852 applied


 相关内容



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


产品


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


•Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition


关键字 

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

 ASM; LINUX; PATCH; PSU; SOLARIS


错误 

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

 ORA-202; ORA-1578; ORA-17505; ORA-19510; ORA-15061 




 
ORA-15061 reported while doing a file operation with 11.1 or 11.2 ASM after PSU applied in database home [ID 1070880.1] 
--------------------------------------------------------------------------------


 
  修改时间 26-OCT-2011     类型 PROBLEM     状态 PUBLISHED   

In this Document
   Symptoms
   Changes
   Cause
   Solution
   References 
--------------------------------------------------------------------------------
 
Applies to: 
 Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 to 11.2.0.1.0 - Release: 11.2 to 11.2
 Information in this document applies to any platform.Symptoms
 ORA-15061 reported when resizing/creating a datafile. ERROR at line 1:
 ORA-19510: failed to set size of 1280 blocks for file .........
 ORA-17505: ksfdrsz:1 Failed to resize file to size 1280 blocks
 ORA-15061: ASM operation not supported [41] Another symptom is
ORA-00202: control file: '+DGESBP1_DATA01/esbp1/control01.ctl' 
 ORA-17505: ksfdrsz:1 Failed to resize file to size 1144 blocks 
 ORA-15061: ASM operation not supported [41] 
 Control file expansion from 1128 blocks to 1144 blocks denied by OSChanges
 Database PSU (9209238  or 9352237 )  is applied in RDBMS home. RDBMS and ASM home versions are:RDBMS Version 11.1.0.7.3 (PSU 9352179 applied)
 RDBMS Version 11.1.0.7.2 (PSU 9209238 applied)
 RDBMS Version 11.2.0.1.1 (PSU 9352237 applied)
 ASM Version 11.2, 11.1For ASM Version 11.1:
 It applies to all platforms.For ASM Version 11.2:
 Problem only applies to platforms:  Linux.x32, Linux.x64, or Solaris.SPARC(64-bit)If patch.8898852 or a PSU (9209238  or 9352237 ) containing the fix for 8898852 is applied to the RDBMS home, but the equivalent fix is not applied in the Grid Infrastructure or ASM Home, ORA-15061 problem will happen for file operations.  
Cause
 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. 
Solution
 Download patch 8898852 from My Oracle Support and install in the ASM home.For ASM Version 11.1:
 If ASM and RDBMS home executables are installed in a shared home, problem doesn't happen.
 Latest PSU should be applied in ASM home if ASM executables are installed in a separate home.  For ASM Version 11.2:
 Bug 8898852 fix has been included in 11.2.0.2 for all the platforms. 
 For Solaris.x64, AIX, HP-UX, and Windows platforms, bug fix has been included in 11.2.0.1. 
1] For Linux x86 and Linux x86-64 on 11.2.0.1 
EITHER 
 Apply 8898852 to GI Home plus PSU Patch 9654983 ( 11.2.0.1.2 ) to RDBMS Home 
 OR 
 Apply Grid Infrastructure PSU 9655006 ( 11.2.0.1.2 ) to both Grid and RDBMS Homes or the latest PSU. 2] If the Database PSU has already been installed in the RDBMS Home, then the latest Grid Infrastructure PSU can still be installed to the Grid Infrastructure home. 
3] For Solaris Sparc on 11.2.0.1, apply the latest PSU 
We recommend to apply the very latest PSU to both the homes. 
 
 
 References
 BUG:8898852 - DATAFILE CORRUPTION WHEN FILE CREATED WITH COMPATIBLE.ASM LESS THAN 11 RESIZED
 NOTE:965751.1 - Error ORA-1578 reported on the database after changing compatible.rdbms >= 11 and resizing a datafile
 NOTE:1117514.1 - ORA-15061 Creating database even with RDBMS PSU#1 and GRID patch 8898852 applied

 相关内容

 

--------------------------------------------------------------------------------
产品
--------------------------------------------------------------------------------

•Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
--------------------------------------------------------------------------------
ASM; LINUX; PATCH; PSU; SOLARIS
错误
--------------------------------------------------------------------------------
ORA-202; ORA-1578; ORA-17505; ORA-19510; ORA-15061

 

 

标签：applied,15061,RDBMS,database,11.2,home,ORA,ASM,PSU
From： https://blog.51cto.com/prudentwoo/6546751

相关文章

  • 【DataBase】SQL函数_ substr()函数
    substr()函数用于截取对应字段指定长度。SUBSTR(string,pos,len)string:指定字符串pos:规定字符串从何处开始，（这里的第一个位置是1而不是0）为正数时则从字段开始出开始，为负数则从结尾出开始。len:要截取字符串的长度。（是从1开始计数而不是0）  INSTR()......
  • 使用自己的数据库SQLite database
    http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/MostalloftheAndroidexamplesandtutorialsoutthereassumeyouwanttocreateandpopulateyourdatabaseatruntimeandnottouseandaccessanindependent,prelo......
  • 【数据库原理、编程与性能】Programming to access a Database
    文章目录1.IntroductiontoEmbeddedSQLinC1.1Declaresection1.2Connect/Disconnect1.2.1Connect1.2.2Disconnect1.3Commit/Rollback1.4Whenever1.5一个实例：1.6HostVariable1.6.1Definition1.6.2说明1.6.3用法1.6.4实例1.6.5IndicatorVar2.CommonEmbedded......
  • ETCD连接报错：database space exceeded
    ETCD连接报错：databasespaceexceeded一：背景此etcd不是k8s集群中的etcd，是kuboard中使用etcd报错，kuboard稳定运行了一年多，上周还正常访问，今天上班访问kuboard报错，然后顺着排查发现kuboard中使用了etcd（之前一直没注意），查看kuboard日志，发现如下报错信息：二：报错分析：大致意思就是kubo......
  • How to Tell if the I/O of the Database is Slow - 2
    IO的类型：平均响应时间直接关联到具体的IO类型：1.读或写2.单块或多块dbfilesequentialread”，表明正在等待需要的块。dbfilescatteredread”，表明正在等待需要的块。3.同步或异步    同步(阻塞)操作等待硬件完成物理IO，完成后能得到通知，合理地管理操作的成功或失败(成......
  • 修复 Sqlite "database disk image is malformed"
    Sqlite是用于移动设备的轻量级数据库。Android编译遇到出错异常：databasediskimageismalformed 处理方法为通过对sqlite提供的修复命令建立脚本封装自动处理。修复方法来自网络搜索，年代久远，出处不可考，如找到出处，本文引用改为链接。 1#1.dumpSQL语句2def__d......
  • database/sql库
    database/sql是Go语言中一个标准库，用于处理关系型数据库的操作。它是一个轻量级的SQL数据库抽象，提供了一些基本的接口，包括连接、查询、事务等。database/sql使用SQL驱动程序的方式连接不同的数据库，让我们可以使用统一的API，而不用考虑底层数据库驱动的差异性。连接数据库......
  • Database System Concepts——读书笔记 第二章 关系模型简介
    关系模型简介在关系模型中，术语relation用于指代table，而术语tuple用于指代row。类似地，术语attribute（属性）指的是表中的一column（列）。我们必须区分数据库模式和数据库实例，前者是数据库的逻辑设计，后者是给定时刻数据库中数据的快照。关系的模式指的是它的逻辑设计，而关系的实例指的......
  • Database System Concepts——读书笔记 第一章 介绍
    数据库系统概念——第一章数据库管理系统（DBMS）由相互关联的数据集合和访问这些数据的程序集合组成。数据库相对于文件系统，更规范化，提供条件查询能力，避免冗余数据。类似操作系统于底层硬件，提供抽象能力，易用性。physicallevel->logicallevel->viewlevelinstance和schem......
  • Database System Concepts——读书笔记 第三、四、五章 SQL简介
    SQL简介关系代数运算和SQL运算之间有着密切的联系。一个关键的区别是，与关系代数不同，SQL允许重复与select子句不同，union联合操作会自动消除重复项.如果我们想保留所有的副本，我们就必须用“unionall”代替“union.intersectall,exceptall您可以验证，如果r.A为null，则“1<r.A”......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99