暂无图片
ORA-00600: internal error code, arguments: [3716]
我来答
分享
暂无图片 匿名用户
ORA-00600: internal error code, arguments: [3716]

主机环境2节点linux+11204rac
今天早上节点2日志报如下错误

ARC0: STARTING ARCH PROCESSES COMPLETE
Errors in file /u01/app/oracle/diag/rdbms/zzdb/zzdb2/trace/zzdb2_ora_17214.trc (incident=6109930):
ORA-00600: internal error code, arguments: [3716], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/zzdb/zzdb2/incident/incdir_6109930/zzdb2_ora_17214_i6109930.trc
Mon Aug 21 09:25:24 2023
Dumping diagnostic data in directory=[cdmp_20230821092524], requested by (instance=2, osid=17214), summary=[incident=6109930].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Abort recovery for domain 0
Aborting crash recovery due to error 600
Errors in file /u01/app/oracle/diag/rdbms/zzdb/zzdb2/trace/zzdb2_ora_17214.trc:
ORA-00600: internal error code, arguments: [3716], [], [], [], [], [], [], [], [], [], [], []
Abort recovery for domain 0
Errors in file /u01/app/oracle/diag/rdbms/zzdb/zzdb2/trace/zzdb2_ora_17214.trc:
ORA-00600: internal error code, arguments: [3716], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Mon Aug 21 09:25:26 2023
Sweep [inc][6109930]: completed
Sweep [inc2][6109930]: completed
Mon Aug 21 09:39:02 2023

登录节点1发现该机器死机,进行了重启操作,节点1重启后日志报

ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Errors in file /u01/app/oracle/diag/rdbms/zzdb/zzdb1/trace/zzdb1_ora_25829.trc (incident=8577217):
ORA-00600: internal error code, arguments: [3716], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/zzdb/zzdb1/incident/incdir_8577217/zzdb1_ora_25829_i8577217.trc
Mon Aug 21 09:16:45 2023
Dumping diagnostic data in directory=[cdmp_20230821091645], requested by (instance=1, osid=25829), summary=[incident=8577217].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Abort recovery for domain 0
Aborting crash recovery due to error 600
Errors in file /u01/app/oracle/diag/rdbms/zzdb/zzdb1/trace/zzdb1_ora_25829.trc:
ORA-00600: internal error code, arguments: [3716], [], [], [], [], [], [], [], [], [], [], []
Abort recovery for domain 0
Errors in file /u01/app/oracle/diag/rdbms/zzdb/zzdb1/trace/zzdb1_ora_25829.trc:
ORA-00600: internal error code, arguments: [3716], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Mon Aug 21 09:16:55 2023
Sweep [inc][8577217]: completed
Sweep [inc][8545240]: completed


请帮忙分析下如何解决,谢谢。

我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
圣雪良缘
上传附件:zzdb1_ora_25829.trc
暂无图片 评论
暂无图片 有用 0
打赏 0
圣雪良缘
暂无图片 评论
暂无图片 有用 0
打赏 0
圣雪良缘
上传附件:zzdb2_ora_17214.trc
暂无图片 评论
暂无图片 有用 0
打赏 0
圣雪良缘
暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
[17294] uncategorized SQLException for SQL []; SQL state [99999]; error code
回答 2
已采纳
这个具体是执行了什么语句?
oracle 的flashback闪回功能,开启过后有弊端吗?要注意些啥?
回答 2
已采纳
dgmgrl主备切换跟开不开闪回没关系;dg环境建议主备库都开启闪回,万一出现failover可以更快速的恢复同步;需要注意闪回日志存放空间,默认是存放1天,不会占用太多空间
Oracle19C
回答 1
可以有偿
oracle加列+default DDL是否会有锁?
回答 4
看这个问题争论很大4000W的表测试(12C)SQL>desccreditinfopart;NameNull?TypeCIEMAILNOTNULLNVARCHAR2(100)CITELNVARC
oracle视图突然失效,怎么排查呢?为啥过一段时间后,视图又突然失效了
回答 5
已采纳
从DBADEPENDENCIES检查视图依赖哪些对象,然后查询DBAOBJECTS以检查每个依赖对象的LASTDDLTIME或者 开DDL审计或者 ddl触发器
oracle11g怎么查看dblink的调用情况?
回答 1
http://blog.itpub.net/17203031/viewspace687469/这个链接有查看的方法,写的比较详细,可以通读文章。
oracle 11g搭建dg时,恢复控制文件报错:RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
回答 7
已采纳
aix到linux的字节序不一样,不能直接搭建dg,最好用操作系统的
ORA-00600报错
回答 2
根据视图名称可以确定是物化视图还是普通视图。物化视图的可能性较大,刷新物化视图是字段长度超过物化视图定义的字段长度
删除归档语句不生效
回答 3
CROSSCHECKBACKUP;CROSSCHECKbackupset;脚本里,把这两句放到无效的那两句前面试试
oracle恢复归档文件
回答 5
listbackupofarchivelogall;查看具体归档的SIZE,之后就清楚恢复过程要多久了。