暂无图片
数据库大量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
乄塟`ㄣ懓.々
2022-12-27
最 后 怎么解决 的影响CDC同步吗
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏