Email: service@parnassusdata.com 7 x 24 online support!
ORA-00600: 内部错误代码, 参数: [ktspgfb-1] 的解决
ORA-00600: 内部错误代码, 参数: [ktspgfb-1] 的解决
解决ORA-00600[ktspgfb-1]一例,该案例的trace信息如下:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], [] Current SQL statement for this session: INSERT INTO XX ---- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp+0148 bl ksedst 102973B94 ? ksfdmp+0018 bl 01FD34D8 kgerinv+00e8 bl _ptrgl kgeasnmierr+004c bl kgerinv 042888888 ? 022488888 ? 102A8F8D0 ? 000000000 ? 000000000 ? ktspgfblk+0240 bl kgeasnmierr 110006728 ? 1103FCB28 ? 102A8F9B0 ? 000000000 ? 000000180 ? 7000008730AC6E8 ? 000000307 ? 7000008230AD080 ? ktspgfbs+01b0 bl ktspgfblk 000000058 ? 000001FE8 ? 022046489 ? 7000008829255B4 ? FFFFFFFFFFF7030 ? 000000002 ? FFFFFFFFFFF6DF0 ? 4448224200000000 ? ktspfsrch+00a4 bl ktspgfbs 700000018BD8014 ? 000000000 ? 1101D65E0 ? FFFFFFFFFFF6FF8 ? 000000000 ? 000000000 ? 000000000 ? ktspscan_bmb+01e4 bl ktspfsrch 100EC61D0 ? 000000000 ? ktspgsp_cbk1+049c bl ktspscan_bmb 1009BA2C4 ? ktspgsp_cbk+0098 bl ktspgsp_cbk1 00000000F ? 1101FB1D0 ? 700000877E9C140 ? 000000000 ? 0000000F0 ? 000000000 ? 000000000 ? 0000000C0 ? kdtgsp+04d4 bl ktspgsp_cbk FFFFFFFFFFF7470 ? 110216600 ? FFFFFFFFFFF7440 ? 110061460 ? 000000008 ? 1103DB9F0 ? 000000000 ? 110405C30 ? kdtgsph+01ec bl kdtgsp 000000001 ? 1103D04D0 ? kdtFlushBuf+03f8 bl kdtgsph FFFFFFFFFFF7600 ? 110006728 ? insflush+01e8 bl kdtFlushBuf 70000088292C480 ? insrow+01ec bl insflush 1103CEDF8 ? 000000000 ? 10009E1D4 ? FFFFFFFFFFF86F0 ?
ktspgfbs的含义为Get first level bitmap block for search
ktspgfblk的含义为KTSP Get first level bitmap block
发生该ORA-00600: internal error code, arguments: [ktspgfb-1]错误,基本可以认为是数据对象的基本信息一级位图块可能存在逻辑损坏/讹误。
针对该错误需要根据不同的数据对象类型制定不同的修复策略。
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com
该ORA-00600[ktspgfb-1]错误的bug信息如下:
Bug# 7260057 See Note:7260057.8
Instance crash after failed RESIZE on NFS
Fixed: 10.2.0.5, 11.2
Bug# 2424226 See Note:2424226.8
OERI:[ktspgfb-1] possible after direct load of bitmap managed segment
Fixed: 9.0.1.4, 9.2.0.1
Bug# 2253389 See Note:2253389.8
ORA-00600:[KTSPGFB-1] possible after direct load of bitmap managed table
Fixed: 9.0.1.4, 9.2.0.1