【Oracle】ORA-00600: 内部错误代码, 参数: [25027], [7], [0]

最新推荐文章于 2024-08-29 10:19:21 发布

戒掉贪嗔痴(薛双奇)

最新推荐文章于 2024-08-29 10:19:21 发布

阅读量887

点赞数 5

分类专栏：数据库运维-Oracle-常规故障文章标签： oracle 数据库

本文链接：https://blog.csdn.net/weixin_43346403/article/details/136368786

版权

数据库运维-Oracle-常规故障专栏收录该内容

90 篇文章 4 订阅

订阅专栏

文章讲述了在Oracle数据库中遇到的内部错误ORA-00600，涉及LOB段插入问题。通过逻辑导出导入表和调整表空间存储方式，作者成功解决了这个问题。

摘要由CSDN通过智能技术生成

1.前台提交有问题

tail -1000 alert_oadb.log 
Errors in file /chac/app/oracle/product/11.2.0/diag/rdbms/oadb/oadb/trace/oadb_ora_68918.trc  (incident=48561):
ORA-00600: 内部错误代码, 参数: [25027], [7], [0], [], [], [], [], [], [], [], [], []
Incident details in: /chac/app/oracle/product/11.2.0/diag/rdbms/oadb/oadb/incident/incdir_48561/oadb_ora_68918_i48561.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Feb 29 11:14:08 2024
Dumping diagnostic data in directory=[cdmp_20240229111408], requested by (instance=1, osid=68918), summary=[incident=48561].
Thu Feb 29 11:14:08 2024
Sweep [inc][48561]: completed
Sweep [inc2][48561]: completed
Thu Feb 29 11:14:56 2024


more /chac/app/oracle/product/11.2.0/diag/rdbms/oadb/oadb/trace/oadb_ora_68918.trc 
Dump continued from file: /chac/app/oracle/product/11.2.0/diag/rdbms/oadb/oadb/trace/oadb_ora_68947.trc
ORA-00600: 内部错误代码, 参数: [25027], [7], [0], [], [], [], [], [], [], [], [], []

========= Dump for incident 48673 (ORA 600 [25027]) ========

*** 2024-02-29 11:17:29.930
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=38rx7j2xcz942) -----
insert into wf_process_running (processobject, createdate, state, id) values (:1 , :2 , :3 , :4 )

2.原因分析

LOB段插入问题，属于BUG; 
Doc ID 1608861.1
processobject字段是LOB段有问题。

3.修复方案

(1)逻辑导出导入表。
expdp table; 
impdp table;


--创建表空间，移动BLOB 到新的表空间。
(2)创建新的表空间,BLOB字段一定到新的表空间。
create tablespace V3XSPACE_BLOB datafile '/chac/app/oracle/oradata/v3xspace_blob.01.dbf' 
size 10G autoextend on next 200M;
Alter table V3XUSER.WF_PROCESS_RUNNING move lob(processobject) store as (tablespace V3XSPACE_BLOB);

我使用第二种方法,完美修复。