Home » RDBMS Server » Server Administration » ERROR ORA 00600 HELP PLS
 ERROR ORA 00600 HELP PLS [message #160478] |
Sun, 26 February 2006 21:13  |
chara
Messages: 81
Registered: April 2005
Location: th
|
Member |
|
|
Dear all,
I got the error in log file as the following :
ORA-00600: internal error code, arguments: [kcbgtcr_4], [259591], [259299], [1152], [1], [], [], []
Errors in file /ora8163/home/admin/seven/udump/ora_19985_seven.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_4], [259591], [259299], [1152], [1], [], [], []
and here is the example trc file
Dump file /ora8163/home/admin/seven/udump/ora_19985_seven.trc
Oracle8i Enterprise Edition Release 8.1.6.3.0, 64 bit - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production
ORACLE_HOME = /ora8163/home
System name: HP-UX
Node name: slurpee
Release: B.11.00
Version: U
Machine: 9000/800
Instance name: seven
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 19985, image: oracle@slurpee (TNS V1-V3)
*** SESSION ID:(20.43829) 2006-02-24 23:00:05.909
BH #25019 (0xc000000029bd08c0) file#: 21 rdba: 0x0541a811 (21/108561) class 4 ba: 0xc00000004acf4000
set: 1, dbwrid: 0
hash: [c00000002a7bfd40,c00000002a7bfd40], lru: [c000000029849ea0,c000000029ada500]
LRU flags:
ckptq: [NULL] fileq: [NULL]
st: XCURRENT, md: NULL, rsop: 0x0, tch: 1
flags: gotten_in_current_mode
L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]
buffer tsn: 10 rdba: 0x0541a811 (21/108561)
scn: 0x0000.7dc4d705 seq: 0x02 flg: 0x00 tail: 0xd7051002
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 space2: 0 #extents: 1 #blocks: 255
last map 0x00000000 #maps: 0 offset: 2080
Highwater:: 0x0541a812 ext#: 0 blk#: 0 ext size: 255
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Disk Lock:: Locked by scn: 0x0003.00c.00038409
Map Header:: next 0x00000000 #extents: 1 obj#: 259591 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x0541a812 length: 255
nfl = 1, nfb = 1 typ = 1 nxf = 1
SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
XCT LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000 xid: 0x0000.000.00000000
*** 2006-02-24 23:00:05.936
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcbgtcr_4], [259591], [259299], [1152], [1], [], [], []
Current SQL statement for this session:
SELECT a.tablespace_name as Tablespaces_Name,
to_char(round(NVL(a.bytes / 1048576 , 0),2) ,'999,999' ) as "Total(MB)",
to_char(round(NVL(u.bytes, 0)/ 1048576 ,2) ,'999,999' ) as "Used(MB)" ,
to_char(round((NVL(a.bytes,0) - nvl(u.bytes,0))/ 1048576 ,2) ,'999,999' ) as "Free(MB)",
to_char(round(NVL(NVL(u.bytes, 0) / a.bytes * 100, 0), 2 ),'99.99') || ' %' as "Used %"
FROM (select tablespace_name, sum(decode(AUTOEXTENSIBLE,'NO',bytes,maxbytes)) bytes
from dba_data_files
group by tablespace_name
union
select tablespace_name, sum(decode(AUTOEXTENSIBLE,'NO',bytes,maxbytes)) bytes
from dba_temp_files
group by tablespace_name
) a,
(select tablespace_name,sum(bytes) bytes
from dba_extents
group by tablespace_name
union
select tablespace_name, sum(bytes_cached) bytes
from v$temp_extent_pool group by tablespace_name
) u
WHERE a.tablespace_name = u.tablespace_name(+)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst + 399 ???? skdstinit C0000000003DACD7 ?
800003FFEFFF9A20 ?
8000000100070758 ?
000000027 ?
ksedmp + 247 ???? ksedst 000000000 ?
8000000100060D80 ?
000000000 ? 000000000 ?
ksfdmp + 35 ???? ksedmp 800003FFEFFF8780 ?
800003FFEFFF8CF0 ?
000000000 ? 000400058 ?
kgerinv + 163 ???? ksfdmp 000000000 ? 000400058 ?
800000010005E058 ?
4000000000200168 ?
kgeasnmierr + 91 ???? kgerinv 800003FFEFFF8920 ?
8000000100060D80 ?
000000000 ?
800000010005DE30 ?
Thks for advance
Chara
|
|
|
|
| Re: ERROR ORA 00600 HELP PLS [message #160499 is a reply to message #160478] |
Mon, 27 February 2006 00:15  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
[Excerpt from Metalink Note:138990.1 Refer to this doc for detail.]
This error occurs when we are scanning blocks in the buffer cache
from a dropped object whose blocks are being reused by a different object. We assert an invalid cursor.
There is no underlying data block corruption in this case.
Also for the sake of info... did you truncated any segment in bitmap tablespace as If a table stored in a bitmapped tablespace is truncated whilst a query is running against
dictionary space information (eg: DBA_SEGMENTS)
an ORA-600 [kcbgtcr_4] may occur.
In that case its a fit case for Bug# 2157568 [For details See MEtalink Note 2157568.8]
OERI:KCBGTCR_4 possible from query if segment in BITMAP tablespace is TRUNCATED
Fixed: 8.1.7.4, 9.0.1.4, 9.2.0.1
--Girish
|
|
|
|
Goto Forum:
Current Time: Fri Sep 20 12:51:49 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
