ORA-00600 and ORA 00447 Error on my alert

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

ORA-00600 and ORA 00447 Error on my alert

nauman
Dear Erman,

Hope you are doing well.

I am getting flood of ORA-00600 msgs on my database. Although my application is running fine. Users just have one issue being faced that is

"When they trying to upload a pic they got an error msg i.e ORA 00600 on front end else everything is running fine."

Please help me out how to get rid of this situation. My database version is 12C.

Some relevant details of the msg is as under:-

ORA-00600: Internal Error code arguments: [5464],[340094080],[335895552]
OPIRIP:Uncaught error 447 Error Stack
ORA-00447 Fatal error in background processes

Thanks & Regards
Reply | Threaded
Open this post in threaded view
|

Re: ORA-00600 and ORA 00447 Error on my alert

ErmanArslansOracleBlog
Administrator
1)Normally I must see the call stack as well..
This "may" be due to corruption in the TEMP tablespace..  But I m not sure.. Not Enough information for being sure.. Still, you may check  -> ORA-600[5464] (Doc ID 1942479.1)

2)You got ORA-600 and ORA-447 in the stack.
ORA-600 is already fatal, as you may already know. But 447 is also fatal.
       
ORA-447 means ->   fatal error in background process
-------------------------------------------------------------------------------
One of the background processes completed unexpectedly.

*Check the alert log and trace files for all trace files around
        the time of the error. It is common for one trace to point at another
        process. Follow the list until you get a file with a real
        error in it. If unsure collect ALL trace files.

If on HP see HP-UX: Database Crashed with ORA-447, Nothing Useful in Tracefiles (Doc ID 1011300.102)