暂无图片
数据库大量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


请输入正文
提交
相关推荐
Windows下使用数据泵导出按照多个表多个条件脚本怎么写exp
回答 1
Windows跟Linux一样啊,写个parfile呗,可以写AND,例如:$catexpdpquery.parQUERYemployees:"WHEREdepartmentid>10
PDB$SEED也可以是READ WRITE状态吗?
回答 4
已采纳
使用这个参数是有风险的,如果可以的话你看下这两篇文章https://www.anbob.com/archives/5149.htmlhttps://mikedietrichde.com/2020/02
oracle迁移DM8后如何确定每个表数据量是否有丢失?
回答 1
已采纳
不会丢数据,但存在字段类型不同的问题
ORACLE 主机sqlplus登录时记录连接终端的IP地址
回答 3
已采纳
1、oracle 用户的.bashprofile写入exportMYIP\'whoami|awk'{print$NF}'|sede's/[()]//g'\'echo"execdbmssess
dg备库节点hang住
回答 4
参看该文章:http://dbtechno.blogspot.com/2015/04/aixlrudprocessonoracledbserver.html
19c rac 节点与DB节点不符合
回答 1
可能性1、创建数据库时,addinstance的时候,节点名称和实例名称反了;可能性2、数据库安装的时候模式选择错误,db安装Oracle支持策略或者池的概念,数据库实例可以在不同的RAC节点,需要铲
AHF orachk是什么
回答 2
AHF打错了
linux安装Oracle执行netca提示报错:提示java.lang.NoClassDefFoundError:oracle/sysman/oii/oiil/OiilNativeException
回答 2
监听图形化安装命令netca
oracle 11g 安装后, 怎么查询安装的过程的 step4 ; select product languages ? 选择了哪几种语言, 可以增加吗?
回答 1
一般默认的en就可以了,也加上简易中文。装完好像是不可以增加的。
如何查看sqlplus文件内容?
回答 6
已采纳
strings$ORACLEHOME/lib/libsqlplus.so