ASM disk reads fail with changed asm_diskstring parameter - ORA-15080: synchronous I/O operation to

最新推荐文章于 2026-07-02 10:43:35 发布
原创 最新推荐文章于 2026-07-02 10:43:35 发布 · 1.1k 阅读 · 11 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
GEO检测

SYMPTOMS

In the alert_+ASM.log:
...
Tue Jul 09 18:52:48 2013
NOTE: ASM client <database>:<database> disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Trace records dumped in trace file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_ora_20307.trc
...
Tue Jul 09 18:52:50 2013
WARNING: Read Failed. group:2 disk:3 AU:3 offset:0 size:4096
WARNING: cache failed reading from group=2(<DISKGROUP1>) fn=6 blk=0 count=1 from disk= 3(<DISK04>) kfkist=0x20 status=0x02 file=kfc.c line=11555
ERROR: cache failed to read group=2(<DISKGROUP1>) fn=6 blk=0 from disk(s): 3(<DISK04>)
ORA-15080: synchronous I/O operation to a disk failed  ---------------->  HERE
NOTE: cache initiating offline of disk 3 group <DISKGROUP1>  ---------------->  HERE
NOTE: process _<user>_+asm (27925) initiating offline of disk 3.3971639839 (<DISK04>) with mask 0x7e in group 2  ---------------->  HERE
WARNING: Disk 3 (<DISK04>) in group 2 in mode 0x7f is now being taken offline on ASM inst 1
NOTE: initiating PST update: grp = 2, dsk = 3/0xecba6a1f, mask = 0x6a, op = clear
Tue Jul 09 18:52:51 2013
GMON updating disk modes for group 2 at 13 for pid 25, osid 27925
ERROR: Disk 3 cannot be offlined, since diskgroup has external redundancy.
ERROR: too many offline disks in PST (grp 2)
Tue Jul 09 18:52:51 2013
NOTE: cache dismounting (not clean) group 2/0xBC3A9AFC (<DISKGROUP1>)
NOTE: messaging CKPT to quiesce pins Unix process pid: 27946, image: <image> (B000)
Tue Jul 09 18:52:52 2013
NOTE: halting all I/Os to diskgroup 2 (<DISKGROUP1>)           ---------------->  HERE
Tue Jul 09 18:52:52 2013
...
SQL> alter diskgroup <DISKGROUP1> dismount force /* ASM SERVER */                   ---------------->  HERE
WARNING: Offline of disk 3 (<DISK04>) in group 2 and mode 0x7f failed on ASM inst 1  ---------------->  HERE
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_ora_27915.trc:
ORA-17503: ksfdopn:2 Failed to open file +<DISKGROUP1>/<database>/spfile<database>.ora
ORA-15130: diskgroup "<DISKGROUP1>" is being dismounted                              ---------------->  HERE
ORA-15066: offlining disk "<DISK04>" in group "<DISKGROUP1>" may result in a data loss  ---------------->  HERE
ORA-15080: synchronous I/O operation to a disk failed                   ---------------->  HERE
Tue Jul 09 18:52:52 2013
...
SUCCESS: diskgroup <DISKGROUP1> was dismounted
SUCCESS: alter diskgroup <DISKGROUP1> dismount force /* ASM SERVER */  ---------------->  HERE
Tue Jul 09 18:52:52 2013
NOTE: diskgroup resource ora.<DISKGROUP1>.dg is offline
ERROR: PST-initiated MANDATORY DISMOUNT of group <DISKGROUP1>
Tue Jul 09 18:52:53 2013
SQL> ALTER DISKGROUP <DISKGROUP1> MOUNT  /* asm agent *//* {0:4:26} */  ---------------->  HERE
...
WARNING: Read Failed. group:0 disk:10 AU:0 offset:0 size:4096
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_ora_20178.trc:
ORA-27061: waiting for async I/Os failed  ---------------->  HERE
Linux-x86_64 Error: 5: Input/output error  ---------------->  HERE
Additional information: -1    ---------------->  HERE
Additional information: 4096  ---------------->  HERE
WARNING: Read Failed. group:0 disk:0 AU:0 offset:0 size:4096
NOTE: Assigning number (2,0) to disk (<ORCL:LG01>)
NOTE: Assigning number (2,1) to disk (<ORCL:MED02>)
NOTE: Assigning number (2,2) to disk (<ORCL:SM01>)
...
NOTE: Assigning number (2,3) to disk ()
...
NOTE: cache dismounted group 2/0x117A9B02 (<DISKGROUP1>)
NOTE: cache ending mount (fail) of group <DISKGROUP1> number=2 incarn=0x117a9b02
NOTE: cache deleting context for group <DISKGROUP1> 2/0x117a9b02
GMON dismounting group 2 at 19 for pid 19, osid 20178
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
ERROR: diskgroup <DISKGROUP1> was not mounted
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "3" is missing from group number "2"   ---------------->  HERE
ORA-15080: synchronous I/O operation to a disk failed
ORA-15080: synchronous I/O operation to a disk failed
ERROR: ALTER DISKGROUP <DISKGROUP1> MOUNT  /* asm agent *//* {0:4:26} */  ---------------->  HERE
Tue Jul 09 18:53:00 2013
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_ora_28346.trc:
ORA-27061: waiting for async I/Os failed   ---------------->  HERE
Linux-x86_64 Error: 5: Input/output error  ---------------->  HERE
Additional information: -1
Additional information: 4096
WARNING: Read Failed. group:0 disk:0 AU:0 offset:0 size:4096
WARNING: Read Failed. group:0 disk:10 AU:0 offset:0 size:4096
Tue Jul 09 18:53:00 2013
ASM Health Checker found 1 new failures
Tue Jul 09 18:58:04 2013
NOTE: ASMB process exiting due to lack of ASM file activity for 305 seconds
Wed Jul 10 09:14:37 2013
Shutting down instance (immediate)  ---------------->  HERE
...
Wed Jul 10 09:14:45 2013
Instance shutdown complete
Wed Jul 10 09:14:52 2013
...
Wed Jul 10 09:14:56 2013
SQL> ALTER DISKGROUP ALL MOUNT
NOTE: Diskgroups listed in ASM_DISKGROUPS are
<ARCH>
<DATA>
<TEMP>
...
NOTE: cache opening disk 0 of grp 1: ARCH01 label:<MED01>
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 1/0xE022BD39 (ARCH)
...
NOTE: cache opening disk 0 of grp 2: <DISK01> label:<LG01>
NOTE: F1X0 found on disk 0 au 2 fcn 0.166360
NOTE: cache opening disk 1 of grp 2: <DISK02> label:<MED02>
NOTE: cache opening disk 2 of grp 2: <DISK03> label:<SM01>
NOTE: cache opening disk 3 of grp 2: <DISK04> label:<LG02>
NOTE: cache mounting (first) external redundancy group 2/0xE042BD3A (<DISKGROUP1>)
...
NOTE: cache opening disk 0 of grp 3: <DISKP01> label:<MED03>
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 3/0xE042BD3B (TEMP)
...
SUCCESS: diskgroup <ARCH> was mounted               --------------->  <ARCH> was successfully mounted
GMON querying group 2 at 11 for pid 13, osid 25613
NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 2
SUCCESS: diskgroup <DISKGROUP1> was mounted                            ---------------> DATA was successfully mounted
GMON querying group 3 at 12 for pid 13, osid 25613
NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 3
SUCCESS: diskgroup <TEMP> was mounted                --------------->  TEMP was successfully mounted
SUCCESS: ALTER DISKGROUP ALL MOUNT              --------------->  All diskgroups successfully mounted.
...
Wed Jul 10 16:04:41 2013
WARNING: Read Failed. group:2 disk:3 AU:3 offset:0 size:4096
WARNING: cache failed reading from group=2(<DISKGROUP1>) fn=6 blk=0 count=1 from disk= 3(<DISK04>) kfkist=0x20 status=0x02 file=kfc.c line=11555
ERROR: cache failed to read group=2(<DISKGROUP1>) fn=6 blk=0 from disk(s): 3(<DISK04>)
ORA-15080: synchronous I/O operation to a disk failed  ---------------->  HERE
NOTE: cache initiating offline of disk 3 group <DISKGROUP1>  ---------------->  HERE
NOTE: process _<user>_+asm (28115) initiating offline of disk 3.3981594077 (<DISK04>) with mask 0x7e in group 2
WARNING: Disk 3 (<DISK04>) in group 2 in mode 0x7f is now being taken offline on ASM inst 1
NOTE: initiating PST update: grp = 2, dsk = 3/0xed524ddd, mask = 0x6a, op = clear
Wed Jul 10 16:04:41 2013
GMON updating disk modes for group 2 at 13 for pid 22, osid 28115
ERROR: Disk 3 cannot be offlined, since diskgroup has external redundancy.
...
Wed Jul 10 16:04:41 2013
NOTE: halting all I/Os to diskgroup 2 (<DISKGROUP1>)  ---------------->  HERE
...
SQL> alter diskgroup <DISKGROUP1> dismount force /* ASM SERVER */  ---------------->  HERE
Wed Jul 10 16:04:41 2013
NOTE: ASM client <database>:<database> disconnected unexpectedly.
NOTE: check client alert log.
NOTE: Trace records dumped in trace file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_ora_26025.trc
WARNING: Read Failed. group:2 disk:3 AU:1 offset:4096 size:4096
WARNING: Read Failed. group:2 disk:3 AU:1 offset:0 size:4096
Wed Jul 10 16:04:42 2013
ERROR: ORA-15130 in COD recovery for diskgroup 2/0xe042bd3a (<DISKGROUP1>)
NOTE: cache deleting context for group <DISKGROUP1> 2/0xe042bd3a
ERROR: ORA-15130 thrown in RBAL for group number 2
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_25613.trc:
ORA-15130: diskgroup "<DISKGROUP1>" is being dismounted      ---------------->  HERE
ERROR: ORA-15130 in COD recovery for diskgroup 2/0xe042bd3a (<DISKGROUP1>)
ERROR: ORA-15130 thrown in RBAL for group number 2
Errors in file /u01/app/oracle/diag/asm/+asm/+ASM/trace/+ASM_rbal_25613.trc:
ORA-15130: diskgroup "" is being dismounted
...
SUCCESS: diskgroup <DISKGROUP1> was dismounted
SUCCESS: alter diskgroup <DISKGROUP1> dismount force /* ASM SERVER */
ERROR: PST-initiated MANDATORY DISMOUNT of group <DISKGROUP1>
...
Wed Jul 10 16:04:49 2013
SQL> ALTER DISKGROUP <DISKGROUP1> MOUNT  /* asm agent *//* {0:4:35} */
...
Wed Jul 10 16:04:55 2013
...
NOTE: cache opening disk 0 of grp 2: <DISK01> label:<LG01>
NOTE: F1X0 found on disk 0 au 2 fcn 0.166360
NOTE: cache opening disk 1 of grp 2: <DISK02> label:<MED02>
NOTE: cache opening disk 2 of grp 2: <DISK03> label:<SM01>
NOTE: cache opening disk 3 of grp 2: <DISK04> label:<LG02>
NOTE: cache mounting (first) external redundancy group 2/0x4CC2BD3D (<DISKGROUP1>)
...
Wed Jul 10 16:04:55 2013
NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 2
SUCCESS: diskgroup <DISKGROUP1> was mounted
SUCCESS: ALTER DISKGROUP <DISKGROUP1> MOUNT  /* asm agent *//* {0:4:35} */  ---------------->  HERE
Thu Jul 11 13:36:22 2013
...
********************************************************************************

In the ASM HTML:

GRP NAME STATE    TYPE   TOTAL_MB FREE_MB

1   <ARCH> MOUNTED EXTERN 20000     7328
2   <DATA> MOUNTED EXTERN 302816     167872
3   <TEMP> MOUNTED EXTERN 20000     13120

GRP DISK MOUNT HEADER         MODE STATE TOTAL_MB FREE_MB NAME FAILGROUP LABEL PATH

0 0 IGNORED MEMBER ONLINE NORMAL 0 0                                                          /dev/oracleasm/disks/<LG02> ------->  HERE
0 1 IGNORED MEMBER ONLINE NORMAL 0 0                                                          /dev/oracleasm/disks/<LG01>  ------->  HERE
0 2 IGNORED MEMBER ONLINE NORMAL 0 0                                                         /dev/oracleasm/disks/<MED01>  ------->  HERE
0 3 IGNORED MEMBER ONLINE NORMAL 0 0                                                         /dev/oracleasm/disks/<MED02>  ------->  HERE
0 4 IGNORED MEMBER ONLINE NORMAL 0 0                                                         /dev/oracleasm/disks/<MED03>  ------->  HERE
0 5 IGNORED MEMBER ONLINE NORMAL 0 0                                                         /dev/oracleasm/disks/<SM01>  ------->  HERE
0 6 CLOSED PROVISIONED ONLINE NORMAL 0 0                                                         /dev/oracleasm/disks/<SM02>
0 7 CLOSED PROVISIONED ONLINE NORMAL 0 0                                                         /dev/oracleasm/disks/<SM03>
0 8 CLOSED PROVISIONED ONLINE NORMAL 0 0                                                        /dev/oracleasm/disks/<SM04>
0 15 CLOSED PROVISIONED ONLINE NORMAL 0 0                                                   <SM02 ORCL:SM02>
0 16 CLOSED PROVISIONED ONLINE NORMAL 0 0                                                     <SM03 ORCL:SM03>
0 17 CLOSED PROVISIONED ONLINE NORMAL 0 0                                                   <SM04 ORCL:SM04>
1 0 CACHED MEMBER     ONLINE NORMAL 20000 7328 <ARCH01> <ARCH01> <MED01> <ORCL:MED01>   ------->  HERE
2 0 CACHED MEMBER   ONLINE NORMAL 99984 54592 <DATA01> <DATA01> <LG01> <ORCL:LG01>  ------->  HERE
2 1 CACHED MEMBER       ONLINE NORMAL 20000 10848 <DATA02> <DATA02> <MED02> <ORCL:MED02>  ------->  HERE
2 2 CACHED MEMBER       ONLINE NORMAL 10000 5408 <DATA03> <DATA03> <SM01> <ORCL:SM01>  ------->  HERE
2 3 CACHED MEMBER     ONLINE NORMAL 172832 97024 <DATA04> <DATA04> <LG02> <ORCL:LG02>  ------->  HERE
3 0 CACHED MEMBER        ONLINE NORMAL 20000 13120 <TEMP01> <TEMP01> <MED03> <ORCL:MED03>  ------->  HERE

current asm_diskstring= /dev/oracleasm/disks/*

****************************************************************************************************************************************************

In the OS_COMMANDS.txt (kfod):
...
================================================================================
 1:      99999 Mb /dev/oracleasm/disks/<LG01>                oracle   dba
 2:     172832 Mb /dev/oracleasm/disks/<LG02>                oracle   dba
 3:      20000 Mb /dev/oracleasm/disks/<MED01>               oracle   dba
 4:      20000 Mb /dev/oracleasm/disks/<MED02>               oracle   dba
 5:      20000 Mb /dev/oracleasm/disks/<MED03>               oracle   dba
 6:      10000 Mb /dev/oracleasm/disks/<SM01>                oracle   dba
 7:      10000 Mb /dev/oracleasm/disks/<SM02>                oracle   dba
 8:      10000 Mb /dev/oracleasm/disks/<SM03>                oracle   dba
 9:       9679 Mb /dev/oracleasm/disks/<SM04>                oracle   dba
10:      99999 Mb <ORCL:LG01>                                <unknown> <unknown>
11:     172832 Mb <ORCL:LG02>                                <unknown> <unknown>
12:      20000 Mb <ORCL:MED01>                               <unknown> <unknown>
13:      20000 Mb <ORCL:MED02>                               <unknown> <unknown>
14:      20000 Mb <ORCL:MED03>                               <unknown> <unknown>
15:      10000 Mb <ORCL:SM01>                                <unknown> <unknown>
16:      10000 Mb <ORCL:SM02>                                <unknown> <unknown>
17:      10000 Mb <ORCL:SM03>                                <unknown> <unknown>
18:       9679 Mb <ORCL:SM04>                                <unknown> <unknown>
------------------------------------------------------------------------------------
 

CHANGES

ASM disk reads fail
ASM disks didn't get dismounted since Customer changed asm_diskstring parameter.

CAUSE

The asm_diskstring is set to '/dev/oracleasm/disks/*', which is incorrect.   This value for the asm_diskstring disables the ASMLib API.

There is a discovery phase when starting up the ASM instance based on the ASM_DISKSTRING parameter.  
ASM will scan the disks based on the parameter asm_diskstring, so by setting the asm_diskstring to 'ORCL:*', then you are ensuring that ASM is using the ASMLib API.

PLEASE ALSO NOTE:  Important:  Disabling ASMLIB API may additionally impact the IO performance on any Linux OS:

For example: In one specific env, where the RAC or Standalone System installed ASMLIB (For RHEL6.4), and when set asm_diskstring='/dev/oracleasm/disks/*', IO write became very slow.  This disabling of the ASMLIB API, in any Version of Linux OS, especially with several ASM disk members and/or diskgroups, can potentially affect IO Performance.


So, your issue is most likely related to your current value for the asm_diskstring, according to your ASM HTML output.
----------------------------------------

 Script#1 from 470211.1 can be run to collect the HTML report as below

In the ASM HTML output, for example:                                        
----------------------------------------                                        
GRP DISK MOUNT HEADER   MODE STATE TOTAL_MB FREE_MB NAME FAILGROUP LABEL PATH     PATH                                    
                                        
0      0 IGNORED MEMBER ONLINE NORMAL  0 0    /dev/oracleasm/disks/<LG02> ------>    HERE     ------->    IGNORED    --->    same    ASM    ASM     same disk as    <ORCL:LG02>
0      1 IGNORED MEMBER ONLINE NORMAL 0 0    /dev/oracleasm/disks/<LG01>  ------->    HERE    --------->    IGNORED    --->    same    ASM    disk    same disk as    <ORCL:LG01>
0      2 IGNORED MEMBER ONLINE NORMAL 0 0    /dev/oracleasm/disks/<MED01>  ------->    HERE    --------->    IGNORED    --->    same    ASM    disk    same disk as    <ORCL:MED01>
0      3 IGNORED MEMBER ONLINE NORMAL 0 0    /dev/oracleasm/disks/<MED02>  ------->    HERE    --------->    IGNORED    --->    same    ASM    disk    same disk as    <ORCL:MED02>
0      4 IGNORED MEMBER ONLINE NORMAL 0 0    /dev/oracleasm/disks/<MED03>  ------->    HERE    --------->    IGNORED    --->    same    ASM    disk    same disk as    <ORCL:MED03>
0     5 IGNORED MEMBER ONLINE NORMAL 0 0    /dev/oracleasm/disks/<SM01>  ------->    HERE    --------->    IGNORED    --->    same    ASM    disk    same disk as    <ORCL:SM01>
0     6 CLOSED PROVISIONED ONLINE NORMAL 0 0    /dev/oracleasm/disks/<SM02>                                   
0     7 CLOSED PROVISIONED ONLINE NORMAL 0 0    /dev/oracleasm/disks/<SM03>                                   
0     8 CLOSED PROVISIONED ONLINE NORMAL 0 0    /dev/oracleasm/disks/<SM04>                                   
0   15 CLOSED PROVISIONED ONLINE NORMAL 0 0    <SM02 ORCL:SM02>                                   
0   16 CLOSED PROVISIONED ONLINE NORMAL 0 0    <SM03 ORCL:SM03>                                   
0   17 CLOSED PROVISIONED ONLINE NORMAL 0 0    <SM04 ORCL:SM04>                                   
1     0 CACHED MEMBER     ONLINE  NORMAL 20000 7328 <ARCH01> <ARCH01> <MED01> <ORCL:MED01>     <MED01 ORCL:MED01>                                   
2    0 CACHED MEMBER      ONLINE  NORMAL 99984 54592 <DATA01> <DATA01> <LG01> <ORCL:LG01>       <LG01 ORCL:LG01>                                    
2    1 CACHED MEMBER       ONLINE  NORMAL 20000 10848 <DATA02> <DATA02> <MED02> <ORCL:MED02>      <MED02 ORCL:MED02>                                   
2    2 CACHED MEMBER       ONLINE  NORMAL 10000 5408 <DATA03> <DATA03> <SM01> <ORCL:SM01>    <SM01 ORCL:SM01>                                   
2    3 CACHED MEMBER       ONLINE  NORMAL 172832 97024 <DATA04> <DATA04> <LG02> <ORCL:LG02>      <LG02 ORCL:LG02>                                   
3    0 CACHED MEMBER        ONLINE  NORMAL 20000 13120 <TEMP01> <TEMP01> <MED03> <ORCL:MED03> <MED03 ORCL:MED03>     <MED03 ORCL:MED03>   

The above ASM disks with the IGNORED mount_status indicates ASM finding a duplicate disk (with asm_diskstring=/dev/oracelasm/disks and also to ORCL:*.
This means the disk paths are pointing to the same physical devices being used by an existing diskgroup.

ASM would ignore all duplicate disk paths.
----------------------------------------------------------------------------------

SOLUTION

[Please set your asm_diskstring='ORCL:*'.

1)  Log into ASM:

SQL> ALTER SYSTEM SET asm_diskstring='ORCL:*';

This init parameter can be dynamically changed.

2)  Then, check the change was applied:
======================================================
SQL> show parameter ASM_DISKSTRING

SQL> select path from v$asm_disk;
======================================================

3)  Please note:  If using RAC, then restart the CRS (Bounce the Cluster on both nodes), after modifying the asm_diskstring.

标签
#数据库
jnrjian
关注
一次asm dg 迁移后的坑
Lixora's DB Home
12-21 1786
ASM  alert： WARNING: Read Failed. group:0 disk:3 AU:0 offset:0 size:4096 Errors in file /oracle/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_27525184.trc: ORA-27063: number of bytes read/written is inc
ORA-15080: synchronous I/O operation to a disk faile
鲨鱼胃的博客
09-23 3249
1 问题概述 生产环境中，有一套Oracle RAC，突然反映说IO 错误: The Network Adapter could not establish the connection，并且节点掉了一个。同时备库、单实例库均无法访问。 于是查看trace log进行分析，发现以下报错且不断循环： Errors in file /u01/app/oracle/diag/rdbms/racdb_st...
asm磁盘组无法写入问题-处理中
kevinyu998的博客
04-07 1550
有个11204的rac环境，没应用补丁，5号突然报归档满，登录环境后发现奇怪，一个1T的数据磁盘建成的DATA磁盘组使用了近800G，读写正常，一个1.5T的数据磁盘建成的FRA磁盘组，目前还剩余729551M，无法写入归档。因业务紧急，将部分归档拷贝到节点一的/home/grid/目录下，在rman中crosscheck archivelog all;
记一次存储block corrupt 导致数据库大恢复
老A的自留地，欢迎加微信交流，微信号zhoul777
04-04 613
前几天在vmware装了一次Oracle 10g +rac +asm，详见http://itspace.iteye.com/blog/631585。 停止mcrac1节点vip，注意红色字体标示，也将mcrac1节点的asm实例停止了。 [quote][oracle@mcrac1 dbs]$ crs_stop ora.mcrac1.vip -f Attempting to stop `ora...
oracle表无法写入,Oracle不能对部分表进行读写Error:ORA-15080/ORA-15025/ORA-27041
weixin_34646919的博客
04-04 1324
有一套Oracle RAC，突然反映说不能对部分表格进行读写操作了，但是数据库正常，大部分数据读写也正常，先将服务切至另一台Server使Oracle对外正常服务，然后开始troubleshooting。HP-UX系统层面没有问题，存储3par没有预警，确认链路正常，以上步骤是为了确认不是个别共享存储出问题导致的数据无法访问。然后查看trace log进行分析(/oracle/app/diag/r...
执行root.sh时提示ORA-15018、ORA-15031、ORA-15072、ORA-15080、ORA-15020等错误解决
鲨鱼胃的博客
05-23 3049
这些错误均与磁盘相关。 可能性1： step 1：确认两节点必须是访问同一块共享存储 step 2：确认两节点的磁盘路径完全一样 step 3：确认两节点对磁盘具有rw访问权限 尤其是“3”点 可能性2： vi /etc/sysconfig/oracleasm ORACLEASM_ENABLED=true ORACLEASM_UID=grid ORACLEASM_GID=asmadmin ORA...
exadata上安装GI时root.sh在第一个节点上运行失败(计算节点和存储节点的子网掩码不一致导致的)
wgz7747147820的博客
12-31 763
在root.sh的log里发现了如下错误 /u01/log/main1217_bak/crsdata/slcz01db03/crsconfig/rootcrs_slcz01db03_2019-12-25_00-58-17AM.log 2019-12-25 01:01:55: ASM configuration failed with error 1, check asmca logs at /...
11.2 RAC自动启动报错诊断（二）
ckawt40802的专栏
06-02 778
一个客户的11.2 RAC for Linux X86-64环境停电后出现了故障，RAC环境无法自动启动。 这一篇描述新的问题。 11.2 RAC自动启动报错诊断：http://yan...
关于 12c GI 安装过程中，如果使用 NFS 方式提供 ASM 磁盘， 出现 ORA-15018 ORA-15072 ORA-15080 错误 (文档 ID 1945862.1)
xxjj2003的专栏
03-04 2252
关于 12c GI 安装过程中，如果使用 NFS 方式提供 ASM 磁盘， 出现 ORA-15018 ORA-15072 ORA-15080 错误 (文档 ID 1945862.1) 转到底部 文档内容 症状   更改   原因
ORA-15196 while allocation reaches 2Tb even compatible.asm is set to 12.1 (Doc ID 1933068.1)
oraly的博客
06-13 564
Oracle ASM不支持大于2T的磁盘，此为bug，在12.1版本上修复了APPLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterInformation in this document applies to any platform.SYMPTOMS New diskgroup was create...
ORA-15040: diskgroup is incomplete 报错分析
mhmds的专栏
12-02 7862
本文只是简单介绍了下自己遇到的问题，以及发现问题的过程，其实还是自己处理问题不够细心导致。 在客户现场帮助客户添加ASM磁盘组，之前客户已经将存储都挂载到主机上 客户环境： OS：AIX6.1 机器：p770 数据库： oracle 11.2.0.4+psu4 双节点Rac   由于之前的空间不足，所以客户想新建个ASM DG，来存放新的数据，于是乎，开干！
<BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: Au
zhanglujie2008的专栏
10-23 8015
报错信息： Critical> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: Authentication denied: Boot identity not valid; The user name and/or password from the boot i
Oracle不能对部分表进行读写Error:ORA-15080/ORA-15025/ORA-27041
weixin_34128534的博客
04-13 451
有一套Oracle RAC，突然反映说不能对部分表格进行读写操作了，但是数据库正常，大部分数据读写也正常，先将服务切至另一台Server使Oracle对外正常服务，然后开始troubleshooting。 HP-UX系统层面没有问题，存储3par没有预警，确认链路正常，以上步骤是为了确认不是个别共享存储出问题导致的数据无法访问。然后查看trace log进行分析...
oracle asm 存储故障,守得云开见月明:一次ASM存储高可用故障解决过程分析
weixin_42534103的博客
04-03 666
2018-08-16T14:56:04.957199+08:00 -->差不多和DB同时检测到IO错误WARNING: Write Failed. group:1 disk:1 AU:1 offset:4190208 size:4096path:/dev/rdisk/MES1_p4_moddb_ocrvoteincarnation:0xf0996d00 asynchronous resul...
ORA-15018: diskgroup cannot be created
cuizhi4718的博客
02-19 421
1、近日在redhat 5.8上安装Oracle 11.2.0.4 RAC时，在第二点节执行root.sh时遇到如下报错： ORA-15018: diskgroup cannot be created ORA-15072: ...
守得云开见月明:一次ASM存储高可用故障解决过程分析
Enmotech的博客
09-05 3847
关注我们获得更多内容作者 | 姜劲松，云和恩墨专家支持部Oracle技术专家，Oracle OCP，MySQL OCP，RHCE等认证专家。长期服务移动运营商行业客户，精...
WARNING: Read Failed. group:5 disk:3 AU:14009 offset:630784 size:8192
csdn198008的博客
01-06 895
系统平台：AIX 6100-05-05-1112数据库版本：11.2.0.2.0实例的 alert 报错：Errors in file /oracle/app/oracle/diag/rdbms/csh...
ASM Diskgroup on NFS: ORA-15080 ORA-17500: ODM err: (Doc ID 2203220.1)
sqlora的专栏
01-20 991
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and lat
Claude Code Skills实战：Andrej Karpathy 149K Stars项目深度解析
最新发布
小二丶的博客
07-02 130
《Andrej Karpathy开源Claude Code Skills项目解析》 摘要： 前Tesla AI总监Andrej Karpathy开源的Claude Code Skills项目在GitHub单月斩获149K Stars，成为历史增长最快项目之一。该项目通过CLAUDE.md文件定义了AI编码的核心规范，解决了LLM编程中的四大陷阱：错误假设、过度复杂化、跳过测试和随意修改。
电商系统不是技术堆叠：LikeShop如何用分层Hold住复杂业务？
Zmq83906955的博客
06-29 524
Java开发语音👩‍💻、一键部署、文档清晰📄、小程序、代码规范
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值