当前位置:   article > 正文

ORA-00600 25027错误问题处理_log read is synchronous though disk_asynch_io is e

log read is synchronous though disk_asynch_io is enabled!

用户反映应用软件在保存相关数据时报错,并提供了如下报错截图:
在这里插入图片描述
在这里插入图片描述
通过直接查找alert日志中的错误对应TRACE文件以及通过设置errorstack方式从TRACE文件中分析相应的应用软件报错时对应的数据库对象信息:
ORA-00600 25027错误

[oracle@orcl01 trace]$ more /oracle/app/diag/rdbms/primary/orcl/trace/orcl_ora_166102.trc
Trace file /oracle/app/diag/rdbms/primary/orcl/trace/orcl_ora_166102.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app/product/11.2.0.4
System name:	Linux
Node name:	orcl01
Release:	2.6.32-642.el6.x86_64
Version:	#1 SMP Wed Apr 13 00:51:26 EDT 2016
Machine:	x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 195
Unix process pid: 166102, image: oracle@orcl01


*** 2018-08-15 23:04:45.223
*** SESSION ID:(220.437) 2018-08-15 23:04:45.223
*** CLIENT ID:() 2018-08-15 23:04:45.223
*** SERVICE NAME:(orcl) 2018-08-15 23:04:45.223
*** MODULE NAME:(w3wp.exe) 2018-08-15 23:04:45.223
*** ACTION NAME:() 2018-08-15 23:04:45.223
 
DDE: Problem Key 'ORA 600 [25027]' was flood controlled (0x4) (incident: 145727)
ORA-00600: Ś²¿´´
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/Gausst松鼠会/article/detail/415729?site
推荐阅读
相关标签