暂无图片
数据库大量ORA-00600报错,业务暂未受影
我来答
分享
徐sir
暂无图片
2019-09-11
数据库大量ORA-00600报错,业务暂未受影

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /u01/app/oracle/diag/rdbms/icdc/icdc1/trace/icdc1_j000_18659.trc  (incident=200243):

ORA-00600: internal error code, arguments: [qccprg:ocistmtprepare2], [1031], [ORA-01031: insufficient privileges

], [], [], [], [], [], [], [], [], []

日志毫无征兆,总是突然报错,实例也未停止, TRACE报错如下

Trace file /u01/app/oracle/diag/rdbms/icdc/icdc1/trace/icdc1_j000_19896.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1

System name: Linux

Node name: xqdb01

Release: 2.6.18-128.7AXS3

Version: #1 SMP Fri Jun 19 13:48:55 EDT 2009

Machine: x86_64

VM name: VMWare Version: 6

Instance name: icdc1

Redo thread mounted by this instance: 1

Oracle process number: 51

Unix process pid: 19896, image: oracle@xqdb01 (J000)



*** 2019-09-09 13:04:45.319

*** SESSION ID:(868.8585) 2019-09-09 13:04:45.319

*** CLIENT ID:() 2019-09-09 13:04:45.319

*** SERVICE NAME:(SYS$USERS) 2019-09-09 13:04:45.319

*** MODULE NAME:(DBMS_SCHEDULER) 2019-09-09 13:04:45.319

*** ACTION NAME:(CDC$_DEFAULT_PURGE_JOB) 2019-09-09 13:04:45.319

 

DDE: Problem Key 'ORA 600 [qccprg:ocistmtprepare2]' was flood controlled (0x4) (incident: 205929)

ORA-00600: internal error code, arguments: [qccprg:ocistmtprepare2], [1031], [ORA-01031: insufficient privileges

], [], [], [], [], [], [], [], [], []

DDE: Problem Key 'ORA 600 [qccprg:ocistmtprepare2]' was flood controlled (0x4) (incident: 205930)

ORA-00600: internal error code, arguments: [qccprg:ocistmtprepare2], [1031], [ORA-01031: insufficient privileges

], [], [], [], [], [], [], [], [], []

DDE: Problem Key 'ORA 600 [qccprg:ocistmtprepare2]' was flood controlled (0x4) (incident: 205931)

ORA-00600: internal error code, arguments: [qccprg:ocistmtprepare2], [1031], [ORA-01031: insufficient privileges

], [], [], [], [], [], [], [], [], []

DDE: Problem Key 'ORA 600 [qccprg:ocistmtprepare2]' was flood controlled (0x4) (incident: 205932)

ORA-00600: internal error code, arguments: [qccprg:ocistmtprepare2], [1031], [ORA-01031: insufficient privileges

], [], [], [], [], [], [], [], [], []


我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
章芋文

请问这个库有做升级操作吗?另外请提供下trace文件中的 Current SQL Statement 方便定位问题,怀疑是bug。

暂无图片 评论
暂无图片 有用 0
打赏 0
乄塟`ㄣ懓.々
2022-12-27
最 后 怎么解决 的影响CDC同步吗
回答交流
Markdown


请输入正文
提交
相关推荐
Oracle 11g的rman 可以单表恢复吗?
回答 1
物理备份不行。你先恢复好这个,再从里面拿吧。
Oracle 11g 同一条sql语句,数据没有改变的情况下,两次语句查询结果不一致
回答 3
加/gatherplanstatistics/的提示后,也执行两次,每次执行后,查看selectfromtable(dbmsxplan.displaycursor('','','allstatslas
DSG占用物理读很高
回答 2
已采纳
dsg不都是原厂服务的吗?直接找原厂哇
oracle数据库系统慢
回答 5
1、重点注意下,出现问题之前,有没有做过特别的操作;2、执行下:selectgroup,statusfromv$log;查看下当然日志组的状态;
Oracle <>这个可不可以一次不等于多个值,是不是没有这种用法?
回答 2
可以的,比如:SQL&gt;selectidfromttaa;ID1245Elapsed:00:00:00.00SQL&gt;selectfromttaawhereid&lt;&gt;all(1,2,
在 postgreSQL 里实现 oracle的定时任务功能,推荐采用什么办法?
回答 2
pgCron插件
Oracle 为什么同一个sql 使用analyze收集后,性能更差,使用dbms_stats.gather_table_stats执行后,性能更好呢?
回答 3
analyze基本上已经被废弃了,在收集统计信息的全面性上和准确性上,analyze不及dbms包,可以看下收集完统计信息的sql的执行计划,看看cost消耗在哪里,可以分析下哪块统计信息不准导致的s
auto space advisor 疑问
回答 3
autospaceadvisor也是性能相关的,段管理、碎片相关,和数据文件的字典管理方式以及本地管理方式不是一个东西
Oracle官网有11g吗?
回答 2
https://edelivery.oracle.com/osdc/faces/SoftwareDelivery;jsessionidNE2ygnV4DpaHX7ToEW0MiAm8qCxr02HTf
Oracle9i数据库无法正常关闭
回答 4
可能是数据库有大量活动会话和dirty&nbsp;data,导致清理过慢。请注意非必要情况不要abort。