I have a DBA who is convinced that Toad 10 is causing database crashes. He points to the error messages and that the trace logs show that Toad was causing the problem. We have 30+ Oracle databases and about 25 developers converted to Toad 10. I have posted the error below. Has anyone else had this error. Or can anyone help proving that Toad 10 is not responcible?
thanks
Ian Jackson
SQL*Plus: Release 9.0.1.4.0 - Production on Fri Mar 5 09:01:04 2010
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
ERROR:
ORA-00600: internal error code, arguments: [kqrfrpo], [0xFFFFFEF905F71428],
[11], [], [], [], [], []
Error accessing package DBMS_APPLICATION_INFO
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
ORA-600 errors are always server side problems – yes they can be exposed
by an application. So maybe a new version of an app issues a legit query that
causes the database to die. ORA-600 is a very special Oracle error message
number – as it’s a scenario that’s not yet been defined a
permanent error number and message. So the parameters you see in brackets with
the Ora-600 are usually special code that Oracle second level support can
troubleshoot from. For example there are some dozen or two database bugs in
10.2.0.1 that TOAD can expose and that is fixed by patches such as 10.2.0.4 and
10.2.0.4. That does not make it a toad bug – but rather your database has
a bug that someone has exposed and that the database vendor supplies a fix to.
In ora-600 case – almost universally these are bugs that require oracle
support (often second level) and a patch or patchset. As for the other errors
like product_user_profile – seems to me that your dba needs to set some
privs/grants and maybe run some scripts as SYS to properly setup the database.
This message for example is due to a SQL*Plus admin script that was not run.
That has nothing to do with any app like toad.
Is the product_user_profile table and synonym OK? Have they tried running
pupbld.sql as the error message suggests? What happens if the users try to
connect using just SQL Plus (not when it is called from Toad)? If they have more
than one Oracle home, be sure to use the same one that Toad is using.
I have a DBA who is convinced that Toad 10 is causing
database crashes. He points to the error messages and that
the trace logs show that Toad was causing the problem.
With all due respect,
go around to your DBA and slap him!
have 30+ Oracle databases and about 25 developers converted
to Toad 10. I have posted the error below. Has anyone else
had this error. Or can anyone help proving that Toad 10 is
not responsible?
thanks
An ORA-600 is an internal Oracle error that must be reported to Oracle
Support. The fact that Toad may be causing the appearance of said crash
is coincidental as a quick test in SQL*Plus would most likeley show the
same problem.
Looking up the cause of the above error shows :
Bug# 3835429 See Note:3835429.8
OERI[kqrfrpo] / DB hang after killing a user process
Fixed: 9.2.0.7
And Note 3835429.8 has this to say:
Description
If a user process is killed at an inopportune time then an
ORA-600 [kqrfrpo] may be signalled and the "row cache latch" may
be held indefinitely leading to a database wide hang.
Affects versions
HTH
Cheers,
Norm. [TeamT}
PS. Only kidding about slapping the DBA, however, he should know what
to do with an ORA 600 error.
N.
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
SQL*Plus: Release 9.0.1.4.0 - Production on Fri Mar 5 09:01:04 2010
[snip]
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
The version mismatch between client and server may be worth noting. As
others have mentioned, the ORA-600 is a DB server issue, but you're using a
client version older than the server, which is rarely a good thing.
My $.02,
Rich -- [TeamT]
Disclaimer: I didn't do it! It was the one-armed man!
THANKS for saying the obvious. I as a Quest person have to
try to be a little more PC (just a little). But you're spot
on - this is a no brainer.
I thought, seeing it was Friday, that we could use a little levity! But
it is obvious to any DBA that ORA-600 is "report to support".
As for PC, sorry, no can do. I call a spayed a cat with no b-lls!
Cheers,
Norm. [TeamVeryUnPC]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
What we're all thinking but too chicken to just come out and say J
I should be safe enough, I'm (hopefully) in a different Time Zone!
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
