[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1793
  • Last Modified:

Oracle internal error

Hi,

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.

Thanks.
0
venomx_
Asked:
venomx_
  • 5
  • 4
1 Solution
 
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.
0
 
venomx_Author Commented:
Hi,

Trace file begining text below. scx.xxx is function.

Thanks

*** 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  scx.xxx('125965','1124','30/07/2012') from dual
0
 
slightwv (䄆 Netminder) Commented:
So can you reproduce the exact error using that exact SQL?

select  scx.xxx('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?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 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)
0
 
slightwv (䄆 Netminder) Commented:
Do you have the answers to my questions?
0
 
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.
0
 
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.
0
 
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.

Thanks.
0
 
slightwv (䄆 Netminder) 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.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now