Skip to search.

(*) Scheduled Maintenance: We are undertaking some essential, but extensive maintenance to improve Yahoo! Calendar. Your Group Calendar is being migrated to a much improved version of Yahoo! Calendar. During the maintenance period, you may not have access to your Groups Calendar. We sincerely apologize for this inconvenience. Your Groups Calendar is in great shape and we are working to have it available again as quickly as possible - Yahoo! Groups & Yahoo! Calendar Team

toad · Self Help List for TOAD Development Users
  • Members Only
  • Post
  • Files
  • Photos
  • Links
  • Database
  • Polls
  • Calendar
  • Promote
  • Groups Labs (Beta)
  • Chat

Group Information

  • Members: 5117
  • Category: Oracle
  • Founded: Jul 22, 1998
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.
Click here for the latest updates on Groups Message search

Messages

   Messages Help
Message #
Search:
Advanced
Toad 10 - DBA is convinced that Toad 10 is causing db crashes   Message List  
Reply Message #51012 of 57673 |
RE: [toad] Toad 10 - DBA is convinced that Toad 10 is causing db crashes

Have they trapped the SQL Toad executed that caused the 600?  Toad is probably exposing a database issue and is being shot as the messenger…

 

Your message below indicates that you can replicate via SQL*Plus?  If that’s the case, why do they think it’s Toad?

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of ianjacksonca
Sent: Friday, March 05, 2010 9:07 AM
To: toad@yahoogroups.com
Subject: [toad] Toad 10 - DBA is convinced that Toad 10 is causing db crashes

 

 

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

(c) Copyright 2001 Oracle Corporation. All rights reserved.

ERROR:
ORA-00600: internal error code, arguments: [kqrfrpo], [0xFFFFFEF905F71428],
[11], [], [], [], [], []

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
Fri Mar 5, 2010 2:56 pm

Show Message Option
toaddev
Offline Offline
Send Email Send Email

Message #51012 of 57673 |
Expand Messages Author Sort by Date

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... 		ianjacksonca Offline Send Email Mar 5, 2010
2:54 pm

Have they trapped the SQL Toad executed that caused the 600? Toad is probably exposing a database issue and is being shot as the messenger... Your message...
Jeff Smith
toaddev Offline Send Email 		Mar 5, 2010
3:00 pm

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...
Bert Scalzo
bert.scalzo Offline Send Email 		Mar 5, 2010
3:06 pm

I like to think of ORA-600 as the Oracle equivalent of an access violation. From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Bert Scalzo ...
John Dorlon
jdorlon3 Offline Send Email 		Mar 5, 2010
3:16 pm

Ian, ... With all due respect, go around to your DBA and slap him! ;-) ... An ORA-600 is an internal Oracle error that must be reported to Oracle Support. The...
Dunbar, Norman
normandunbar Offline Send Email 		Mar 5, 2010
3:06 pm

... 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. From:...
Bert Scalzo
bert.scalzo Offline Send Email 		Mar 5, 2010
3:15 pm

Hi Bert, ... 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,...
Dunbar, Norman
normandunbar Offline Send Email 		Mar 5, 2010
3:37 pm

... What we're all thinking but too chicken to just come out and say :) From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Dunbar, Norman ...
Jeff Smith
toaddev Offline Send Email 		Mar 5, 2010
3:21 pm

Hi Jeff, ... I *should* be safe enough, I'm (hopefully) in a different Time Zone! ;-) Cheers, Norm. [TeamT] Information in this message may be confidential and...
Dunbar, Norman
normandunbar Offline Send Email 		Mar 5, 2010
3:32 pm

And you're a customer who helps other customers as opposed to us guys who work for all of you (i.e. you pay our bills) :) From: toad@yahoogroups.com...
Bert Scalzo
bert.scalzo Offline Send Email 		Mar 5, 2010
4:16 pm

Message from: Nelson.Petersen_046 So there we have it. The DBA should be slapped, with all due respect, or maybe not so much respect, and TOAD at worst is the...
Nelson.Petersen_046
toadoraclebeta Offline Send Email 		Mar 5, 2010
9:02 pm

Thanks for the replies .. I will pass them on. When we find out what is happening, I will post it. Ian Jackson...
ianjacksonca Offline Send Email Mar 5, 2010
4:01 pm

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...
John Dorlon
jdorlon3 Offline Send Email 		Mar 5, 2010
3:09 pm

Hey Ian, ... [snip] ... The version mismatch between client and server may be worth noting. As others have mentioned, the ORA-600 is a DB server issue, but...
Rich Jesse
r2qti Offline Send Email 		Mar 5, 2010
3:20 pm
< Prev Topic  |  Next Topic >
Message #
Search:
Advanced
Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help