DBASK问答集萃第二期

引言

近期我们对DBASK小程序进行了升级，UI交互做了重大优化调整，对注册用户开放知识库全文检索功能，引入数据和云公众号文章，提问时自动关联知识库已知问题，专栏可生成图片分享给好友，欢迎大家通过微信搜索DBASK体验。

问答集萃

接下来，我们分享本期整理出的问题和诊断总结，供大家参考学习，详细的诊断分析过程可以通过标题链接跳转到小程序中查看。

listener不能访问，重启lsrnctl restart 无效，最后操作系统重启后正常，请帮忙分析下原因。

2019.01.30 02:41接到电话，反映不能使用，erp有画面报警；我发现db不能连接，lsnr 不能服务了。

查询日志发现：

Wed Jan 30
01:02:02 China Standard Time 2019
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 4688'
waited for 'direct path read', seq_num: 10340
for 'rdbms ipc message' count=1 wait_time=3.009785 sec

DB: direct path read 这个值超时。2019-01-30 00:50:24时，有锁出现：

sql::DELETE FROM XXX WHERE XXX<=TO_CHAR(SYSDATE-30,'YYYYMMDD')||' 0000000' AND ROWNUM<1001

有大量锁表：XXX，接着有XXXX表，用户FTRPT/sqlplus.exe_程序，XXXXX，XXXXX,一些job等进程锁，越来越多！造成连锁反映！

详细日志如下：

Wed Jan 30 01:02:02 China Standard Time 2019
Errors in file d:oracleproduct10.2.0admin\bdump\_mmon_4704.trc:
ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 4688'
Wed Jan 30 01:02:02 China Standard Time 2019
System State dumped to trace file d:oracleproduct10.2.0admin\bdump\_mmon_4704.trc
Killing enqueue blocker (pid=4688) on resource CF-00000000-00000000
by killing session 162.1
Killing enqueue blocker (pid=4688) on resource CF-00000000-00000000
by terminating the process
MMON: terminating instance due to error 2103
Wed Jan 30 01:12:05 China Standard Time 2019
USER: terminating instance due to error 1092
Wed Jan 30 01:12:05 China Standard Time 2019
...省略

今天通过工具查询表的数据突然报错，详细如下：

早上7点左右，系统突然出现CPU警报，后连接失败，直接连接操作系统可以登录但操作特别卡顿，后现象消失，后排查，发现告警日志其中有两个可疑告警一个是VKTM另外一个是01555，目前还不清楚具体是什么原因造成？

open数据库报错ORA -0600，详细日志如下：

Fri Feb 15 18:44:11 2019
Restarting dead background process CJQ0
Fri Feb 15 18:44:11 2019
CJQ0 started with pid=33, OS id=3992
Errors in file f:appadministratordiag dbmsorclorcl raceorcl_cjq0_3992.trc (incident=210531):
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Errors in file f:appadministratordiag dbmsorclorcl raceorcl_cjq0_3992.trc (incident=210532):
ORA-00600: internal error code, arguments: [600], [ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
], [], [], [], [], [], [], [], [], [], []