CODEWITHSUNDEEP
oracle-databasetriggersoracle11gora-00600
Bishan
Bishan

Reputation: 15710

ORACLE server session terminated by fatal error

I have edited a Trigger and try to save. then i got below error.

Error: ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

i can't save my trigger with modifications. how can i solve this ?

Upvotes: 0

Views: 9822

Answers (2)

The Camster
The Camster

Reputation: 1929

I repeatedly got this error list creating a Trigger:

ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], 
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
00603. 00000 -  "ORACLE server session terminated by fatal error"

In SQLDeveloper, edit the PLSCOPE_SETTINGS:

Tools->Preferences ->Database->PL/SQL Compiler

Set "PLScope identifiers:" to "None" This fixed the problem and I had no issues after this.

Upvotes: 8

APC
APC

Reputation: 146239

ORA-00600 is a generic Oracle message indicating an unhandled side-effect of your action i.e. an Oracle bug. The precise reason for the bug may be dependent on the database version, patch level and platform (OS flavour and version).

The proper way of dealing with these things is to contact Oracle Support. If you don't have a Support contract you're probably out of luck. The nature of ORA-00600 means that some of them hit very specific sites, so maybe nobody else has had this before. But try Google, you never know...

And lo! Google serves up this gem by Marc Tempel. Perhaps it will help you.

Upvotes: 6

Related Questions