暂无图片
分享
秋语落
2021-12-01
ORA600-[kjbmpscn:rscn]错误

数据库是Oracle 11.2.0.4 Rac两节点的集群,在运行过程中数据库节点1实例异常关闭后自启动,查看日志报错如下:

【alter日志】

Wed Dec 01 14:42:29 2021
Archived Log entry 373903 added for thread 1 sequence 173586 ID 0x90d4d634 dest 1:

Wed Dec 01 14:42:29 2021
Archived Log entry 373903 added for thread 1 sequence 173586 ID 0x90d4d634 dest 1:
Wed Dec 01 14:44:07 2021
Errors in file /opt/oracle/diag/rdbms/sduapdb/erpdb/trace/erpdb_lms5_97084.trc (incident=848664):
ORA-00600: internal error code, arguments: [kjbmpscn:rscn], [3772], [2494480413], [3772], [2494480415], [3772], [2494480413], [1], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/sduapdb/erpdb/incident/incdir_848664/erpdb_lms5_97084_i848664.trc
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 /opt/oracle/diag/rdbms/sduapdb/erpdb/trace/erpdb_lms5_97084.trc:
ORA-00600: internal error code, arguments: [kjbmpscn:rscn], [3772], [2494480413], [3772], [2494480415], [3772], [2494480413], [1], [], [], [], []
Wed Dec 01 14:44:08 2021
Dumping diagnostic data in directory=[cdmp_20211201144408], requested by (instance=1, osid=97084 (LMS5)), summary=[incident=848664].
LMS5 (ospid: 97084): terminating the instance due to error 484
Wed Dec 01 14:44:08 2021
opiodr aborting process unknown ospid (91393) as a result of ORA-1092
Wed Dec 01 14:44:08 2021
opiodr aborting process unknown ospid (137743) as a result of ORA-1092
Wed Dec 01 14:44:08 2021
opiodr aborting process unknown ospid (106971) as a result of ORA-1092
Instance terminated by LMS5, pid = 97084
Wed Dec 01 14:44:19 2021
Adjusting the default value of parameter parallel_max_servers
from 3600 to 1970 due to the value of parameter processes (2000)

Wed Dec 01 14:44:08 2021
Dumping diagnostic data in directory=[cdmp_20211201144408], requested by (instance=1, osid=97084 (LMS5)), summary=[incident=848664].
LMS5 (ospid: 97084): terminating the instance due to error 484
Wed Dec 01 14:44:08 2021
opiodr aborting process unknown ospid (91393) as a result of ORA-1092
Wed Dec 01 14:44:08 2021
opiodr aborting process unknown ospid (137743) as a result of ORA-1092
Wed Dec 01 14:44:08 2021
opiodr aborting process unknown ospid (106971) as a result of ORA-1092
Instance terminated by LMS5, pid = 97084
Wed Dec 01 14:44:19 2021
Adjusting the default value of parameter parallel_max_servers
from 3600 to 1970 due to the value of parameter processes (2000)

【trace日志】

收藏
分享
2条回答
默认
最新
秋语落
暂无图片 评论
暂无图片 有用 0
打赏 0
暂无图片
秋语落
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
rac开机后其中一个节点无法自动正常启动,请高手帮忙解答一下。
回答 7
问题未解决有没有人看一下。
oracle rac环境单节点宕机
回答 2
升级问题到:紧急故障
Orace 11g RAC 打31718723 补丁报错
回答 3
[ohasd(3941)]CRS2807:Resource'ora.asm'failedtostartautomatically.2021121714:34:35.352:[ohasd(3941)]C
Tomcat应用连接Oracle11g Rac
回答 3
在ORACLE的RAC中,经常会在多个节点的内存数据同步时发生gc等待,但这更多的是由于程序编写问题导致的,存在太多大内存长时间的事务或者极频繁的查询,想通过tomcat配置来解决这个问题基本上是不太
Oracle rac 10g更换votedisk
回答 1
👍🏻
Oracle RAC集群下的自动收集统计任务auto optimizer stats collection执行问题
回答 4
运行过的就会有。
安装grid的时候,节点一执行root.sh报错(rhel 7.6 11.2.0.4 rac)
回答 3
好像Linux7安装oracle11grac需要手动配置ohas.service的,可以在墨天轮翻翻案例;
Oracle RAC故障
回答 11
只是单纯的更换交换机了是吗?光纤卡什么的有没有替换,我们的环境以前也是异常节点重启,后来发布光纤卡的型号号2个节点用的不一样,后来替换成一样后,就再没有出现这种情况了。你这次切网后发生的问题,建你还是
grid执行asmcmd报错。
回答 2
试试sqlplus能不能进去。看看异常节点的root、grid环境变量和正常节点的环境变量。
Oracle11g rac集群scanip分发连接到节点1的IP过于缓慢
回答 4
之前也碰到过类似的问题,在节点2没问题,在节点1上就很慢。楼主可以看看awr报错,具体的等待事件是什么。我之前是碰到了logfilesync,后来查系统日志/var/log/message发现主机日志