重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 19C 开启块改变跟踪导致实例挂掉 [打印本页]

作者: 郑全 时间: 2024-7-16 19:26
标题: oracle 19C 开启块改变跟踪导致实例挂掉

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)

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)