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 home [ID 1070880.
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


 


 

目录
相关文章
|
2月前
|
SQL Java
flywa报错Detected resolved migration not applied to database: 20221103.10000
flywa报错Detected resolved migration not applied to database: 20221103.10000
37 2
|
2月前
|
SQL Java Maven
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
32 1
|
6月前
|
Oracle 关系型数据库 数据库
实时计算 Flink版操作报错合集之错误信息"ORA-65040: operation not allowed from within a pluggable database"如何解决
在使用实时计算Flink版过程中,可能会遇到各种错误,了解这些错误的原因及解决方法对于高效排错至关重要。针对具体问题,查看Flink的日志是关键,它们通常会提供更详细的错误信息和堆栈跟踪,有助于定位问题。此外,Flink社区文档和官方论坛也是寻求帮助的好去处。以下是一些常见的操作报错及其可能的原因与解决策略。
285 2
|
SQL 监控 Go
backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized.
昨天在检查YourSQLDba备份时,发现有台数据库做备份时出现了下面错误信息,如下所示:   yMaint.ShrinkLog   Log Shrink   --  ============================================================...
1096 0
|
数据库
Recover standby database after primary resetlogs
一般在主库需要恢复并open resetlogs 方式打开的情况下,备库需要重做来构建主备同步架构,但有些情况其实不必大费周章,只需要备库开启flashback功能,就可以在较短的时间内恢复主备同步进程。
1549 0