暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

oracle 19C 开启块改变跟踪导致实例挂掉

不为什么 2024-08-01
62

sql> alter database enable block change tracking;
一执行,系统就挂了,看后端日志:

ORA-04031 heap dump being written to trace file /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/incident/incdir_984442/hisdb_ctwr_1162_i984442.trc
2024-07-16T16:52:48.055343+08:00
Errors in file /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/trace/hisdb_ctwr_1162.trc (incident=984443):
ORA-00600: internal error code, arguments: [krcpasb_initial_alloc_failure], [1048576], [], [], [], [], [], [], [], [], [], []
ORA-04031: unable to allocate 15736696 bytes of shared memory ("large pool","unknown object","large pool","CTWR dba buffer")
Incident details in: /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/incident/incdir_984443/hisdb_ctwr_1162_i984443.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2024-07-16T16:52:48.851588+08:00
Errors in file /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/trace/hisdb_ctwr_1162.trc:
ORA-00600: internal error code, arguments: [krcpasb_initial_alloc_failure], [1048576], [], [], [], [], [], [], [], [], [], []
ORA-04031: unable to allocate 15736696 bytes of shared memory ("large pool","unknown object","large pool","CTWR dba buffer")
2024-07-16T16:52:48.852213+08:00
Stopping background process CTWR
2024-07-16T16:52:48.852970+08:00
Errors in file /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/trace/hisdb_ctwr_1162.trc:
ORA-00600: internal error code, arguments: [krcpasb_initial_alloc_failure], [1048576], [], [], [], [], [], [], [], [], [], []
ORA-04031: unable to allocate 15736696 bytes of shared memory ("large pool","unknown object","large pool","CTWR dba buffer")
Errors in file /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/trace/hisdb_ctwr_1162.trc (incident=984444):
ORA-487 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/incident/incdir_984444/hisdb_ctwr_1162_i984444.trc
2024-07-16T16:52:49.048156+08:00
Dumping diagnostic data in directory=[cdmp_20240716165249], requested by (instance=1, osid=1162 (CTWR)), summary=[incident=984443].
2024-07-16T16:52:49.486247+08:00
USER (ospid: ): terminating the instance due to ORA error
System state dump requested by (instance=1, osid=1162 (CTWR)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/hisdbdg/hisdb/trace/hisdb_diag_22944.trc
2024-07-16T16:52:51.353094+08:00
Dumping diagnostic data in directory=[cdmp_20240716165249], requested by (instance=1, osid=1162 (CTWR)), summary=[abnormal instance termination].
2024-07-16T16:52:52.648870+08:00
Instance terminated by USER, pid = 1162

解决办法:
增加SGA后,再次打开,不再报错。

参考:
Instance terminates When Enabling BCT with ORA-01092 After Reporting ORA-00600: [krcpasb_initial_alloc_failure] /ORA-04031 (Doc ID 2794435.1)

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论