One of our Production database we are getting following ORA-00600 error
OS: Windows 2003
DB: 10.2.0.4.0 (Jan-09 CPU Applied)
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []
Solution:
There is no solution yet on metalink...
Kindly submit "Trace Files" & "Alert Log" to Oracle Support
Above Error Fixed In the 11.2 Version
Metalink Note: 756784.1
Temporary Workaround:
If
An ORA-600 can occur while recompiling stored PLSQL if a procedure / function argument name matches to a columnname referred to in that function / procedure .
Then
Change the Function/procedure's argument name so that it does not match to any column name being referred in the function/procedure body.
"Teach Oracle Learn Oracle" -- Taj Contact me for support at askdbataj@gmail.com This blog is dedicated to all ORACLE Professionals and Learning Students.
Search This Blog
Friday, April 10, 2009
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []
Subscribe to:
Post Comments (Atom)
1 comment:
So good.
Well done. This has saved me time! Why couldn't they give a much more meaningful error, like " Hey, you have named your parameters the same name as your table columns..." Or something similar... I guess we have to wait for 11g R2 to fix it.
Thank you!
Post a Comment