• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 859
  • Last Modified:

Regarding ORA-00600 error

My process is started to query the database but in the middle of its execution it is killed manually.
After some 15 mins oracle logs ora-00600 error.Since 15 mins before process got killed how is it possible for oracle to log the error message?
0
pigeon7778
Asked:
pigeon7778
  • 2
  • 2
  • 2
  • +1
1 Solution
 
schwertnerCommented:
The killed (snipped) processes wait for the first message from the client to inform him that "Process is killed"
This is "Life after Death"!
0
 
pigeon7778Author Commented:
I am not able to understand.how does the killed process will wait for the message for the oracle client?Will it pass the msg its killed after its death to the oracle client?After that oracle logs the error msg in its log file?
0
 
jrb1Commented:
What was killed?  When you do work on Oracle, a client process is running and a server process is also started to do some work.  For a transaction to be truly complete, both of these processes must complete.  It sounds like you killed one process, but the other continue on and then received an error.  You'll hear these termed, user process and shadow process.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
salilcCommented:
hi,

this is a network protocol error, normally this is ignorable.
this may happen in versions from 8.1.7 to 9i

i think there there should be some internal error code number like [12333],[],[]
can u pls post that one also?
0
 
pigeon7778Author Commented:
Application client process that  initiated the transaction was killed.Your are mentioning some shadow process.Is it the client process you are talking about.

This is error message that i got
ORA-00600: internal error code, arguments: [16365], [106636024], [0], [4], [], [], [], []
0
 
salilcCommented:
hi,

i think you are uisng MTS cofiguration
normally ora-00600 [16365] is known as "Half Duplex Violation" , which can happen when a shared sever was
trying to send a message but the virtual circuit contains buffers dirtied by the dispatcher.Shared servers and dispatchers cannot both be writing to the same virtual curcuit at the same time because they communicate with a half-duplex protocol.

impact will be a process failure.there won't be any underlying data corruption.

client programs to be checked ie: the client sends new data or a new request without waiting for completion of previous request  

rgsd
0
 
jrb1Commented:
No, the shadow process is a process spawned from the Oracle DB process.  (except it is different with MTS which you could be using and as salilc mentions above)
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now