Oracle internal error


I use oracle 10g R2 om win 2003 64 bit.

While running a report I get an errorORA-00600: internal error code, arguments: [kgmgchd1], [], [], [], [], [], [], [].

I don't have metalink account.

Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>But I always recompile this function system running and I get an error first time.

You likely just hit some obscure race condition the system didn't like.

Verify the system is still operating normally and all the data is where it is supposrsd to be.

To be 'safe', I would find some time to restart the database just so you know everything at least starts up clean.

For the system I'm on:  When strange things only happen once, I tend to call it a glitch.

When it is reproducable at will or happens often that I start worry.
slightwv (䄆 Netminder) Commented:
An ORA-600 is next to impossible to troubleshoot without Support's help.  A core dump can be caused by just about anything.

Best you can do is Google the argument and see if anyone has posted anything you can use:  kgmgchd1

If you can provide reproducible steps, how it started,what changed, etc... we can try to help.
venomx_Author Commented:

Trace file begining text below. is function.


*** SERVICE NAME:(orc1) 2012-08-15 16:35:47.609
*** SESSION ID:(223.1) 2012-08-15 16:35:47.609
*** 2012-08-15 16:35:47.609
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgmgchd1], [], [], [], [], [], [], []
Current SQL statement for this session:
select'125965','1124','30/07/2012') from dual
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

slightwv (䄆 Netminder) Commented:
So can you reproduce the exact error using that exact SQL?

select'125965','1124','30/07/2012') from dual;

If you cannot reprocude the error at will, there really isn'y much we can probably do.

We still need to know the background behind this.  Things like:
New database or old database?
Did this just start happening or has this always happened?
What changed?
venomx_Author Commented:
First of trace file

Dump file d:\oracle2\product\10.2.0\admin\orc1\udump\orc1_ora_4336.trc
Wed Aug 15 16:35:47 2012
ORACLE V10. - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP and Data Mining options
Windows NT Version V5.2 Service Pack 2
CPU                 : 8 - type 8664, 2 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:15601M/20477M, Ph+PgF:16551M/21833M
Instance name: orc1

Redo thread mounted by this instance: 1

Oracle process number: 304

Windows thread id: 4336, image: ORACLE.EXE (SHAD)
slightwv (䄆 Netminder) Commented:
Do you have the answers to my questions?
venomx_Author Commented:
Old database. 2 years old.

I added this funcion. This function runs 2500 or 3000 times ever weekday. Maybe While function executing I added source code.
slightwv (䄆 Netminder) Commented:
>>>>Maybe While function executing I added source code.

Did you recently recompile/recreate the function while the system was running?
Did you get the ORA-600 areound this time?

If so, there should have been a lock to prevent a race condition from being created but anything is possible and if you did this, it could have easily caused the ora-600.
venomx_Author Commented:
Yes I recently recompile the function while the system was running. I get the ORA-600 around five minutes.

But I always recompile this function system running and I get an error first time.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.