Home » RDBMS Server » Server Administration » ORA-00600: internal error code (oracle 11 g R2 using ASM on Solaris 10 platform)
ORA-00600: internal error code [message #555741] Mon, 28 May 2012 02:40 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi,
i am receiving following errors since 24 May 2012
ORA-00600: internal error code, arguments: [25027], [0], [56830], [], [], [], [], [], [], [], [], []
and
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []

the output of alert log is as follow: it s long list so i am pasting of 28 may 20122
Mon May 28 08:47:00 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_29734.trc  (incident=312371):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:47:04 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_27899.trc  (incident=300944):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:47:09 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_29848.trc  (incident=312920):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:47:19 2012
Sweep [inc][312920]: completed
Sweep [inc][312907]: completed
Sweep [inc][312371]: completed
Sweep [inc][300944]: completed
Mon May 28 08:47:20 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_646.trc  (incident=312942):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:47:32 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_29818.trc  (incident=312382):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:47:33 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_675.trc  (incident=312854):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:48:19 2012
Sweep [inc][312942]: completed
Sweep [inc][312854]: completed
Sweep [inc][312382]: completed
Mon May 28 08:48:46 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_1566.trc  (incident=312324):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:48:46 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_2469.trc  (incident=312211):
ORA-00600: internal error code, arguments: [25027], [0], [56830], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/db6/db61/incident/incdir_312211/db61_ora_2469_i312211.trc
Mon May 28 08:48:49 2012
Trace dumping is performing id=[cdmp_20120528084849]
Mon May 28 08:49:00 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_3347.trc  (incident=312591):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:49:19 2012
Sweep [inc][312591]: completed
Sweep [inc][312324]: completed
Sweep [inc][312211]: completed
Sweep [inc2][312211]: completed
Mon May 28 08:50:29 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_4184.trc  (incident=312477):
ORA-00600: internal error code, arguments: [qesmaGetIndSeg_INT: NonNullDba], [], [], [], [], [], [], [], [], [], [], []
Mon May 28 08:50:30 2012
Sweep [inc][312477]: completed
Mon May 28 08:52:31 2012
Errors in file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_1531.trc  (incident=300800):
ORA-00600: internal error code, arguments: [kcbgtcr_1], [0], [256], [1], [1050], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/db6/db61/incident/incdir_300800/db61_ora_1531_i300800.trc
Mon May 28 08:52:34 2012
Trace dumping is performing id=[cdmp_20120528085234]
Mon May 28 08:52:35 2012
Sweep [inc][300800]: completed
Sweep [inc2][300800]: completed



and the contents of trace files are
Trace file /u01/app/oracle/diag/rdbms/db6/db61/trace/db61_ora_5156.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome
System name:    SunOS
Node name:      db61.domain.ra
Release:        5.10
Version:        Generic_141444-09
Machine:        sun4u
Instance name: db61
Redo thread mounted by this instance: 1
Oracle process number: 110
Unix process pid: 5156, image: oracle@db61.domain.ra


*** 2012-05-17 10:36:39.378
*** SESSION ID:(1664.41716) 2012-05-17 10:36:39.378
*** CLIENT ID:() 2012-05-17 10:36:39.378
*** SERVICE NAME:(srv.domain.ra) 2012-05-17 10:36:39.378
*** MODULE NAME:(JDBC Thin Client) 2012-05-17 10:36:39.378
*** ACTION NAME:() 2012-05-17 10:36:39.378

--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:36:49.646
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :


*** 2012-05-17 10:37:10.450
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:37:24.369
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:38:04.421
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:38:05.519
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:38:06.519
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:38:06.943
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:38:07.965
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
Trigger Name : DOCUMENT_GB
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:38:55.142
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:39:23.499
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:39:24.614
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :
*** 2012-05-17 10:40:12.304
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:40:29.366
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:40:30.705
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :

*** 2012-05-17 10:40:36.509
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :
Trigger Owner : user1
Trigger Name : DOCUMENT_TR
 trigger sublist 2 :
 trigger sublist 3 :
 trigger sublist 4 :
--------Dumping Sorted Master Trigger List --------
Trigger Owner : user1
Trigger Name : DOCUMENT_GB
--------Dumping Trigger Sublists --------
 trigger sublist 0 :
 trigger sublist 1 :

*** 2012-05-17:05:27.046
DDE: Problem Key 'ORA 600 [25027]' was flood controlled (0x6) (incident: 312963)
ORA-00600: internal error code, arguments: [25027], [0], [56830], [], [], [], [], [], [], [], [], []



kindly help regarding this errors and about trigger name DOCUMENT_GB and DOCUMENT_TR??


please guide


Regards
Re: ORA-00600: internal error code [message #555743 is a reply to message #555741] Mon, 28 May 2012 02:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle

ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

Cause: This is the generic internal error number for Oracle program exceptions. This indicated that a process encountered an exceptional condition.

Action: Report as a bug - the first argument is the internal error number.

So - see whether My Oracle Support already contains answer to your problem. If not, contact Oracle.
Re: ORA-00600: internal error code [message #555746 is a reply to message #555741] Mon, 28 May 2012 04:09 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regardds
Michel
Previous Topic: Regarding Default Profile
Next Topic: Oracle database migration from oracle 11gR2 32 bit to oracle oracle 11gR2
Goto Forum:
  


Current Time: Fri Mar 29 05:55:22 CDT 2024