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

最新推荐文章于 2024-08-20 13:24:05 发布
最新推荐文章于 2024-08-20 13:24:05 发布
阅读量103 收藏
点赞数
文章标签： 数据库 
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 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




iteye_13254
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle Database on Linux Fails to Start - ORA-27154 ORA-27300 OR
05-25
在本文中，我们将深入探讨一个特定的Oracle数据库在Linux环境下启动失败的问题，涉及错误代码ORA-27154、ORA-27300、ORA-27301和ORA-27302，这些错误通常与系统信号量相关。此问题可能发生在尝试启动一个新的数据库...
oracle错误日志4,Oracle错误一览表4
weixin_35941169的博客
04-05 503
ORA-16789: 备用重做日志缺失 ORA-16790: 可配置属性的值无效ORA-16791: 无法检查备用重做日志是否存在 ORA-16792: 某些可配置属性的值与数据库设置不一致 ORA-16793: 逻辑备用数据库 Guard 意外关闭 ORA-16794: 数据库 Guard 已为主数据库打开ORA-16795: 数据库资源防护程序检测到数据库需要重新实例化 ORA-16...
ora-01237 ora-01110 ora-17505 ora-15041
喝醉酒的小白
01-13 2781
rename
Oracle事件诊断列表
热门推荐
10-13 1万+
oracle事件诊断列表，从0到20000，并输出到文件oracle.txt中。 SET linesize 120 SET feedback off SET SERVEROUTPUT ON spool "d:\oracl.txt" DECLARE err_msg VARCHAR2(120); BEGIN dbms_output.enable(1000000); FOR err
解决Oracle错误ORA-15061一例
weixin_33841503的博客
03-19 241
一套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 supporte...
ASM磁盘空间假装耗尽，ORA-15041: diskgroup space exhausted
byebyegov5qq
04-17 421
一个DATAGUARD，当主库RESIZE扩大一个数据文件后，DG上面却不能应用这个RESIZE的操作，导致MPR进程停掉，报错如下： ORA-01237: cannot extend datafile 123 ORA-01110: data file 516: '+DG01/dg/datafile/aa.276.689185035' ORA-17505: ksfdrsz:1 Failed ...
expdp 中ORA-39002、ORA-39070错误详解及解决办法
09-09
在使用Oracle数据库进行数据泵导出操作(expdp)时，可能会遇到错误ORA-39002和ORA-39070。ORA-39002通常表示遇到了无效的操作，而ORA-39070则指出无法打开日志文件。这两个错误通常会伴随其他错误信息，如ORA-29283...
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法.pdf
07-16
Oracle数据库不同版本间的客户端与服务端的连接问题通常涉及到安全和兼容性配置，这篇文章主要讲述了在Oracle 11g R2客户端尝试连接Oracle 19c服务端时，遇到了两个特定的错误：ORA-28040和ORA-01017，以及如何解决...
oracle报错（ORA-00600）问题处理
09-10
Oracle数据库在运行过程中可能会遇到各种错误，其中ORA-00600是一个内部错误代码，表示遇到了数据库系统内部无法处理的异常情况。这个错误通常与数据库的底层结构或数据不一致有关，它不是一个通用错误，而是针对...
ORA-01654处理表空间不足问题.pdf
06-12
ORA-01654处理表空间不足问题 Oracle 数据库中，表空间不足是非常常见的问题，主要体现在两个方面：一是原表空间大小不够，二是表空间自动扩展功能未开启。今天我们就来详细讨论如何解决ORA-01654处理表空间不足...
11.2.0.1.0 ASM 不能resize 文件
09-13 203
Oracle RDBMS 版本已经升级11.2.0.1.1的PSU, 但是Grid infrastructure 没有此对应的PSU，还是11.2.0.1.0版本。 如此在resize 文件时候报错： SQL> alt...
ORA-15041: diskgroup "DATAVG" space exhausted ASM空间假装耗尽不足，resize数据文件和增加数据文件失败
Martin201609的博客
10-12 1463
ORA-15041: diskgroup “DATAVG” space exhausted ASM空间假装耗尽不足，resize数据文件和增加数据文件失败 查看asm磁盘组的使用 su - grid asmcmd lsdg ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req
【达梦数据库】-导入导出过程中get DDL复现过程
weixin_47686079的博客
08-20 308
在处理问题的过程中，客户反馈在达梦数据库中导入导出分区表，get 表的DDL，不会出现表的所有分区信息，ORACLE数据库却会出现所有分区表，事实真的如此吗？
分布式事务：基本概念
最新发布
玉汝于成
08-20 266
事务可以看做事一次大的活动，它由不同的小的活动组成，这些活动要么全部成功，要么全部失败。
linux安装达梦数据库
HAN_789的博客
08-19 216
如果无法创建dmdba 文件夹，需要进入root用户下 在管理员用户下，这种安装方式一般只用于验证，开发，测试，生产最好还是安装传统的方式安装。在 home/dmdba/dmdbms/bin 目录下执行。（1）将文件上传到 /home/dmdba/ 目录下。（2）加压：tar -xzvf dmdb.tar.gz。进入到root就可以创建dmdba 文件夹了。1、后台启动，一般建议用后台启动。
网上商品订单转手系统bootpf
weixin_43213064的博客
08-18 543
【代码】springboot网上商品订单转手系统bootpf
ORA-14551: cannot perform a DML operation inside a query
05-24
ORA-14551 is an Oracle error message that occurs when you try to perform a DML (Data Manipulation Language) operation (such as INSERT, UPDATE, or DELETE) within a SELECT statement. In other words, you...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值