Stack Overflow
Stack Overflow

Questions tagged [ora-00600]

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

ORA-00600 is an internal error generated by the generic kernel code of the Oracle RDBMS software. It is different from other Oracle errors in many ways. The following is a list of these differences:

  • An ORA-00600 error may or may not be displayed on the screen. Therefore, screen output should not be relied on for capturing information on this error. Information on ORA-00600 errors are found in the database alert and trace files.

  • Each ORA-00600 error comes with a list of arguments. They are usually enclosed in square brackets and follow the error on the same line for example:

ORA-00600 [14000][51202][1][51200][][]

  • Each argument has a specific meaning which can only be interpreted by an Oracle support analyst. The arguments may also change meaning from version to version therefore customers are not advised to memorize them.

  • Every occurrence of an ORA-00600 should be reported to Oracle Support. Unlike other errors, you can not find help text for these errors. Only Oracle technical support should diagnose and take actions to prevent or resolve damage to the database.

  • Each ORA-00600 error generates a database trace file.

32 questions
7
votes
1 answer

Compiling a PL/SQL function in Oracle 11g2 XE sometimes leads to a ORA-00600: internal error

I have a PL/SQL function that I'm working with that sometimes compiles ok but sometime give me this error. ORA-00600: internal error code, arguments: [17285], [0x318FDE2C], [1], [0x273F1C60], [], [], [], [], [], [], [], [] 00600. 00000 - "internal…
Lallen
  • 518
  • 7
  • 13
6
votes
3 answers

Intentionally Cause ORA-00600 exception in Oracle

For testing purposes I need a couple of SQL scripts that will cause an ORA-00600 error in Oracle, version 11.1.0.7. The database is not empty, it is filled with the data of a fresh install of Vision Demo E-Business Suite. This system is a training…
LXandR
  • 69
  • 1
  • 1
  • 4
4
votes
1 answer

PreparedStatement and Oracle 10g bug

I have a big but INTERMITTENT problem with a bug in Oracle 10g when we call some SQL within a Java web application. We can't quickly patch or upgrade to 11g - which seems to be the first 'stupid' oracle support response. There is a work around, but…
iaindownie
  • 1,046
  • 12
  • 28
4
votes
9 answers

Oracle ORA-00600

I have SQL SELECT statement that returns: Error: ORA-00600: internal error code, arguments: [qerpfAllocateR], [], [], [], [], [], [], [] If I narrow my results by adding one more condition in WHERE clause everything is ok. Anyone knows what is…
Chobicus
  • 2,024
  • 2
  • 17
  • 26
3
votes
1 answer

Custom aggregate function inside a package

I'm trying to write a custom aggregate function in Oracle and group that function inside a package together with some other functions that I have. As an example (to simulate the problem I have) suppose my custom aggregation to do a summation of…
wcmatthysen
  • 445
  • 4
  • 19
2
votes
1 answer

Oracle 12c using onDelete Trigger on Table with foreign key and onDelete cascade setNull throws ORA-00600: Internal Errorcode, Arguments: [13001]

. Hello swarm intelligence, here's the problem, I can't seem to solve without a little help from the StackOverflow crowd :) Given this Oracle Database Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production PL/SQL Release…
Marius Schmidt
  • 633
  • 6
  • 18
2
votes
2 answers

ORA-00600 , Arguments: [KGL-heap-size-exceeded]

My oracle 12c (12.1.0.1) database stop working last night (actually It worked but very very slow) , and started throwing the following exception: java.sql.SQLException: ORA-00600: internal error code, arguments:: [KGL-heap-size-exceeded],…
mmezi
  • 63
  • 1
  • 2
  • 6
2
votes
1 answer

Oracle error ORA-00600

I use Oracle 11g. A few days ago I encountered an ORA-12514 error. I tried to solve it by following this website suggestions: C:\>set oracle_sid=SID Create a new environment variable called TNS_ADMIN: in the ‘value’ field, add the new folder:…
Amir
  • 1,919
  • 8
  • 53
  • 105
1
vote
0 answers

Oracle database error (ORA-12505, ORA-01078, ORA-00600)

I am a beginner who has just begun to study Spring. And I'm using Boot Camp on a MacBook. I am having a problem linking SQL Developer to my database. I downloaded Oracle 11g Express Edition and SQL Developer to link Oracle database to use STS. But…
Angel Choi
  • 107
  • 5
1
vote
2 answers

ORA-00600: internal error code, arguments: [13013], [5001], [1675658], [773963968], [10], [773963968], [17], []

While executing the below query, I am getting the error: ORA-00600: internal error code, arguments: [13013], [5001], [1675658], [773963968], [10], [773963968], [17], [] MERGE INTO nbfc_address_m t1 USING (SELECT a.col2, b.lesseeid FROM…
AAMIR KHAN
  • 23
  • 1
  • 6
1
vote
1 answer

oracle drop table cascade constraints statement hanging

I'm issuing a simple drop table cascade constraints table , but it is hanging forever. After waiting for hours, if I press the cancel button in the SQL Developer, it says "User cancelled operation" like I'm the culprit. Please advice, before I shoot…
Walking Corpse
  • 107
  • 7
  • 31
  • 49
1
vote
2 answers

Oracle SQL IN-Clause throws Error with Subselect

so here's my Problem: I got this SQL-Statement SELECT a.ID,a.CONTENTOF FROM MLMDATA.PV_STORAGE a WHERE 1=1 AND ID IN (113312,114583,114581,113472,114585,114580,113314) AND a.SEQ = (SELECT MAX(b.SEQ) FROM MLMDATA.PV_STORAGE b where a.ID = b.ID)…
Sunrunner
  • 15
  • 9
1
vote
0 answers

ORACLE ORA-00600: internal error code [24106], [24125], [], [], [], [], [], [], [], [], []

ORA-00600 appears while executing scheduled SAS job with code: BEGIN MERGE INTO MA_CDM.CI_CONTACT_HISTORY ch USING ( SELECT VC.CONTACT_ID, CASE CNTRL_GRP_FLG WHEN 1 THEN '_20' WHEN 0 THEN '_03' …
Igor Khalin
  • 31
  • 1
  • 3
1
vote
0 answers

java.sql.SQLException: ORA-00600: internal error code, arguments: [12811], [93233]

I got this while trying to execute File f = new File("file location"); FileInputStream fis = new FileInputStream(f); PreparedStatement ps = db.prepareStatement("INSERT INTO table (title,file,id)…
Nogi
  • 134
  • 9
1
vote
4 answers

ORA-00600: internal error code, arguments: [4194], [65], [51]

I have issue on Oracle. When I execute startup to open database there is error in alert log that ORA-00600: internal error code. Oracle was working without issue and suddenly this issue is arose. Oracle version is 10g express. I just wonder if this…
이상봉
  • 89
  • 2
  • 2
  • 8
1
2 3