Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00600,kcbnew_3 raised when vars are being bind

626479Apr 29 2009 — edited Apr 30 2009
Hi,

My DB 9.2.0.8 has encounter some ORA600 this week ..

the argument given are kcbnew_3 while inserting some new rows into database

tables are patitioned ,and datafile has not not yet reached the point to auto extend

there're many similiar case reported but got fixed like resize a file

Could you hints me where to look to find out the reason

thanks...

[22300065] Error in database insertion probably due to bind values: ORA-00600: internal error code, arguments: [kcbnew_3], [0], [1]
, [2117960], [0], [], [], []

Time: Thu Apr 30 00:50:58 2009
Host: wz1cre1
Process: 9206
Location: wbpMeasBase_c::ExceptionHandler(2): mType 14



200630 Sat Apr 25 00:51:26 2009
200631 Errors in file /d/db/app/oracle/admin/oss/udump/oss_ora_14020.trc:
200632 ORA-00600: internal error code, arguments: [kcbnew_3], [0], [1], [2062465], [0], [], [], []
200633 Sat Apr 25 00:51:51 2009
200634 Thread 1 advanced to log sequence 63129


Dump file shows
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcbnew_3], [0], [1], [2094210], [0], [], [], []
Current SQL statement for this session:
insert into P_TRAFFIC



DBVERIFY - Verification complete

Total Pages Examined : 3269120
Total Pages Processed (Data) : 3268969
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 144
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 7
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 8560612231793 (1993.742410865)


br/ricky

Edited by: zs_hzh on Apr 29, 2009 8:41 PM
This post has been answered by Satish Kandi on Apr 30 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2009
Added on Apr 29 2009
10 comments
3,731 views