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/inci