ORA-00600,ORA-10173
1.1故障环境介绍
项目 | DB Info |
---|---|
DB类型 | RAC |
Version | 12.1.0.2 |
DB Storage | ASM |
1.2报错信息
ORA-00600: internal error code, arguments: [qerltcUserIterGet_1], [1], [1], [], [], [], [], [], [], [], [], []
ORA-10173: Dynamic Sampling time-out error
1.3 ORA-10173故障分析及解决步骤
1.3.1 查询完整的Alert Log
截取完整的 Alert Log如下
Tue Dec 25 10:28:08 2018
Errors in file /oracle/app/diag/rdbms/fdcondb/FDCONDB1/trace/FDCONDB1_ora_32192.trc (incident=179052):
ORA-00600: internal error code, arguments: [qerltcUserIterGet_1], [1], [1], [], [], [], [], [], [], [], [], []
ORA-10173: Dynamic Sampling time-out error
Incident details in: /oracle/app/diag/rdbms/fdcondb/FDCONDB1/incident/incdir_179052/FDCONDB1_ora_32192_i179052.trc
1.3.2 获取相关Trace文件
通过Alert Log中的信息,可以获取到异常时间点对应的的Trace文件的路径及对应的文件
可以获取到如下信息
*** 2018-12-25 10:28:08.412
*** SESSION ID:(5678.43206) 2018-12-25 10:28:08.412
*** CLIENT ID:() 2018-12-25 10:28:08.412
*** SERVICE NAME:(FDCONDB) 2018-12-25 10:28:08.412
*** MODULE NAME:(DSPHost.exe) 2018-12-25 10:28:08.412
*** CLIENT DRIVER:(ODPM.NET) 2018-12-25 10:28:08.412
*** ACTION NAME:() 2018-12-25 10:28:08.412
[TOC00000]
Jump to table of contents
Dump continued from file: /oracle/app/diag/rdbms/fdcondb/FDCONDB1/trace/FDCONDB1_ora_32192.trc
[TOC00001]
ORA-00600: internal error code, arguments: [qerltcUserIterGet_1], [1], [1], [], [], [], [], [], [], [], [], []
ORA-10173: Dynamic Sampling time-out error
[TOC00001-END]
[TOC00002]
========= Dump for incident 179052 (ORA 600 [qerltcUserIterGet_1]) ========
*** 2018-12-25 10:28:08.412
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=bp1hy3m6y7ujb) -----
可以获取到
- 对应的sql_id为bp1hy3m6y7ujb,并获取到对应的SQL
- 通过Module_Name可以获取到对应的程式名称为DSPHost.exe(相关系统程式)
1.3.3 在MOS上查询对应的ORA报错
ORA-10173: Dynamic Sampling time-out error in alert.log (Doc ID 1491818.1)
可以看出来导致此报错的原因为
Dynamic Sampling timeout is raised when the automatic SQL tuning job runs.
根据MOS的建议
The error is not harmful and will not affect the database. It will however stop the automatic job from completing.
针对上述异常可以采取的措施为
If you do not wish to run the Automatic Tuning Job it can be disabled as follows:
BEGIN
DBMS_AUTO_TASK_ADMIN.disable(
client_name => ‘sql tuning advisor’,
operation => NULL,
window_name => NULL);
END;
1.4针对ORA-00600
上述内容为针对ORA-10173的说明,继续针对ORA-00600进行分析
检查思路基本相似,明日会补上
参考文件路径
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=352059404543740&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=1491818.1&_afrWindowMode=0&_adf.ctrl-state=108squkzjf_604