Toad 12 for Oracle hanging and crashing

Toad for Oracle & DevOps Toolkit
1

new install on Win7, Dell M3800 with SSD drive

Toad spinning icon, hanging during exec of a procedure, also compiling PLSQL. Ram memory seems to just keep going up, not uncommon to see it 400-800m or above

Version : 7.0.3.0
Date : Tue, 25 Feb 2014 12:38:34 +0500
OS : Microsoft Windows 7 (64 bit)
RAD : BDS 9.0
Dump : $8B $00 $C3 $90 $55 $8B $EC $83 $C4 $F8 $53 $56 $8B $D8 $C6 $45 $FF $00 $33 $C0 $89 $45 $F8 $8B $C3 $E8 $96 $68 $F0 $FF $8B $F0
Section : ExceptionHandlerHook
Descr :

Address : $042A2D24 - [04190000] Toad.exe - ESpecificDelphi - - DelphiClassByObjectFast - 926[0]
Module : Toad.exe
Exception : EAccessViolation
Message : Access violation at address 042A2D24 in module ‘Toad.exe’. Read of address 9E960F5A
Call Stack : 00 $042A2D24 - [04190000] Toad.exe - ESpecificDelphi - - DelphiClassByObjectFast - 926[0]
01 $04462007 - [04190000] Toad.exe - ExceptionLog7 - - FullInternalErrorReport - 704[1559]
02 $0427B63E - [04190000] Toad.exe - EBase - - InternalErrorSet - 688[306]
03 $0445CC26 - [04190000] Toad.exe - EInject - - ExceptionHandlerHook - 444[154]
04 $7766329D - [775F0000] ntdll.dll
05 $776489AD - [775F0000] ntdll.dll
06 $7764866F - [775F0000] ntdll.dll
07 $7760010A - [775F0000] ntdll.dll
08 $13E6FBCD - [13420000] orageneric12.dll
09 $139AC140 - [13420000] orageneric12.dll
0A $13E6FF99 - [13420000] orageneric12.dll
0B $753B9D55 - [75380000] kernel32.dll
0C $04198B33 - [04190000] Toad.exe
0D $77648786 - [775F0000] ntdll.dll
0E $7760010A - [775F0000] ntdll.dll
0F $0445C726 - [04190000] Toad.exe - EInject - - RaiseExceptionProcHook - 319[98]
10 $042118B6 - [04190000] Toad.exe
11 $042118ED - [04190000] Toad.exe
12 $0421125D - [04190000] Toad.exe
13 $04199178 - [04190000] Toad.exe
14 $75393675 - [75380000] kernel32.dll

LastAddr : $042A2D24 - [04190000] Toad.exe - ESpecificDelphi - - DelphiClassByObjectFast - 926[0]
LastModule : Toad.exe
LastException : EAccessViolation
LastMessage : Access violation at address 042A2D24 in module ‘Toad.exe’. Read of address 9E960F5A
Call Stack : 00 $28B5D680 - [28A90000]
01 $04461B67 - [04190000] Toad.exe - ExceptionLog7 - - FullInternalErrorReport - 570[375]
02 $0427B63E - [04190000] Toad.exe - EBase - - InternalErrorSet - 688[306]
03 $0445CC26 - [04190000] Toad.exe - EInject - - ExceptionHandlerHook - 444[154]
04 $7766329D - [775F0000] ntdll.dll
05 $776489AD - [775F0000] ntdll.dll
06 $7764866F - [775F0000] ntdll.dll
07 $7760010A - [775F0000] ntdll.dll
08 $13E6FBCD - [13420000] orageneric12.dll
09 $139AC140 - [13420000] orageneric12.dll
0A $13E6FF99 - [13420000] orageneric12.dll
0B $753B9D55 - [75380000] kernel32.dll
0C $04198B33 - [04190000] Toad.exe
0D $77648786 - [775F0000] ntdll.dll
0E $7760010A - [775F0000] ntdll.dll
0F $0445C726 - [04190000] Toad.exe - EInject - - RaiseExceptionProcHook - 319[98]
10 $042118B6 - [04190000] Toad.exe
11 $042118ED - [04190000] Toad.exe
12 $0421125D - [04190000] Toad.exe
13 $04199178 - [04190000] Toad.exe
14 $75393675 - [75380000] kernel32.dll

ActiveObj : (Non-Delphi exception) External exception 0EEDFADE
ActiveAddr : $13E6FE5A - [13420000] orageneric12.dll - orageneric12 - - (possible skgesigOSCrash+760) - 0[760]

2

Toad version : 7.0.3.0-hm pretty old if I do understand that.
Your Oracle client is 12?
Windows is x64?

I hardly think that this could work together.

Bert has shown some picture about Toad/Oracle compatibility … but this combination is certainly not there nor is supported. And all that on 64 bit windows … uf.
Try to catch (see something) with What’s hang utility (http://www.nirsoft.net/utils/what_is_hang.html). Maybe that tells you more

Brg
Damir

P.S.

I do not too much, but check that neither Oracle or Toad are not installed under (x86) directory. Try to put them on short DOS based part … just to be avoid this part of problems.

3

oracle 12c-32bit client

Toad 12.0,0,61, not sure why the log shows that 7.0.3, maybe MS number

4

yes x64

5

Oracle 12c is certified with Windows 7 x64 (only 64 bit versions of Oracle!).

So I’d suggest:

  1. Upgrade to 64 bit client (www.oracle.com/…/database12c-win64-download-1968077.html)

  2. Could you upgrade to latest stable Toad 12.1.0.22

Frankly have no other ideas … and this is why I do not like to be a pioneer in newest version testing in mine env.

Good luck

Damir

6

One more thing.

I have Windows 7 x64 SP1, Oracle Client 11.2.0.4 PS 14 x64 and Toad 12.1.0.22 x64, and all works like a charm and can connect to any database (10-12 tested)

7

What about this simple PL/SQL? Does it hang as well?

begin

dbms_output.put_line(‘hello world’);

end;

From: gil.scholl [mailto:bounce-gilscholl@toadworld.com]

Sent: Tuesday, February 25, 2014 1:18 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Toad 12 for Oracle hanging and crashing

Toad 12 for Oracle hanging and crashing

Thread created by gil.scholl

new install on Win7, Dell M3800 with SSD drive

Toad spinning icon, hanging during exec of a procedure, also compiling PLSQL. Ram memory seems to just keep going up, not uncommon to see it 400-800m or above

Version : 7.0.3.0

Date : Tue, 25 Feb 2014 12:38:34 +0500

OS : Microsoft Windows 7 (64 bit)

RAD : BDS 9.0

Dump : $8B $00 $C3 $90 $55 $8B $EC $83 $C4 $F8 $53 $56 $8B $D8 $C6 $45 $FF $00 $33 $C0 $89 $45 $F8 $8B $C3 $E8 $96 $68 $F0 $FF $8B $F0

Section : ExceptionHandlerHook

Descr :

Address : $042A2D24 - [04190000] Toad.exe - ESpecificDelphi - - DelphiClassByObjectFast - 926[0]

Module : Toad.exe

Exception : EAccessViolation

Message : Access violation at address 042A2D24 in module ‘Toad.exe’. Read of address 9E960F5A

Call Stack : 00 $042A2D24 - [04190000] Toad.exe - ESpecificDelphi - - DelphiClassByObjectFast - 926[0]

01 $04462007 - [04190000] Toad.exe - ExceptionLog7 - - FullInternalErrorReport - 704[1559]

02 $0427B63E - [04190000] Toad.exe - EBase - - InternalErrorSet - 688[306]

03 $0445CC26 - [04190000] Toad.exe - EInject - - ExceptionHandlerHook - 444[154]

04 $7766329D - [775F0000] ntdll.dll

05 $776489AD - [775F0000] ntdll.dll

06 $7764866F - [775F0000] ntdll.dll

07 $7760010A - [775F0000] ntdll.dll

08 $13E6FBCD - [13420000] orageneric12.dll

09 $139AC140 - [13420000] orageneric12.dll

0A $13E6FF99 - [13420000] orageneric12.dll

0B $753B9D55 - [75380000] kernel32.dll

0C $04198B33 - [04190000] Toad.exe

0D $77648786 - [775F0000] ntdll.dll

0E $7760010A - [775F0000] ntdll.dll

0F $0445C726 - [04190000] Toad.exe - EInject - - RaiseExceptionProcHook - 319[98]

10 $042118B6 - [04190000] Toad.exe

11 $042118ED - [04190000] Toad.exe

12 $0421125D - [04190000] Toad.exe

13 $04199178 - [04190000] Toad.exe

14 $75393675 - [75380000] kernel32.dll

LastAddr : $042A2D24 - [04190000] Toad.exe - ESpecificDelphi - - DelphiClassByObjectFast - 926[0]

LastModule : Toad.exe

LastException : EAccessViolation

LastMessage : Access violation at address 042A2D24 in module ‘Toad.exe’. Read of address 9E960F5A

Call Stack : 00 $28B5D680 - [28A90000]

01 $04461B67 - [04190000] Toad.exe - ExceptionLog7 - - FullInternalErrorReport - 570[375]

02 $0427B63E - [04190000] Toad.exe - EBase - - InternalErrorSet - 688[306]

03 $0445CC26 - [04190000] Toad.exe - EInject - - ExceptionHandlerHook - 444[154]

04 $7766329D - [775F0000] ntdll.dll

05 $776489AD - [775F0000] ntdll.dll

06 $7764866F - [775F0000] ntdll.dll

07 $7760010A - [775F0000] ntdll.dll

08 $13E6FBCD - [13420000] orageneric12.dll

09 $139AC140 - [13420000] orageneric12.dll

0A $13E6FF99 - [13420000] orageneric12.dll

0B $753B9D55 - [75380000] kernel32.dll

0C $04198B33 - [04190000] Toad.exe

0D $77648786 - [775F0000] ntdll.dll

0E $7760010A - [775F0000] ntdll.dll

0F $0445C726 - [04190000] Toad.exe - EInject - - RaiseExceptionProcHook - 319[98]

10 $042118B6 - [04190000] Toad.exe

11 $042118ED - [04190000] Toad.exe

12 $0421125D - [04190000] Toad.exe

13 $04199178 - [04190000] Toad.exe

14 $75393675 - [75380000] kernel32.dll

ActiveObj : (Non-Delphi exception) External exception 0EEDFADE

ActiveAddr : $13E6FE5A - [13420000] orageneric12.dll - orageneric12 - - (possible skgesigOSCrash+760) - 0[760]

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

8

yep, simple PL/SQL runs fine, will add 64bit Ora client, had to have other one for testing, which TOAD would recognize the 64bit Ora db software at least for testing

Thanks,’ consider this solved

9

please let us know the result … I’d like to hear that really because have no chance to have top of the pops tech Oracle software in one place with Toad.

P.S.
Of course you may have several ORA_HOMES in your OS.

To be certain to have proper one when calling toad I suggest cmd script like:
set ORACLE_HOME=…
call “…\Quest Software\Toad for Oracle 12.1\Toad.exe”

Brg
Damir

10

If you press the three periods button next to Oracle home on connection screen then you get an Oracle home browser, selector and editor. Just note that if you already have any sessions connected then you’ll have to disconnect them because toad can only work with one oracle home at any given time.

11

Damir,

It has not crashed since that one where I posted on the forum.

Am waiting to see what makes it happen again, sorry traveling and at a totally different Client, so the paradigm of what I am working on is not the same.

Thanks,

Gil

Gil Scholl, Oracle Certified Professional (OCP)

Senior System Designer - Geospatial Services-Federal DoD

Woolpert, Inc.

4454 Idea Center Blvd | Dayton, OH 45430-1500

Office: 937.531.1474 | Fax: 937.461.0743 | Cell: 937.371.4321

gil.scholl@woolpert.com
|
www.woolpert.com

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Tuesday, February 25, 2014 4:02 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Toad 12 for Oracle hanging and crashing

RE: Toad 12 for Oracle hanging and crashing

Reply by damir.vadas_531

please let us know the result … I’d like to hear that really because have no chance to have top of the pops tech Oracle software in one place with Toad.

P.S.

Of course you may have several ORA_HOMES in your OS.

To be certain to have proper one when calling toad I suggest cmd script like:

set ORACLE_HOME=…

call “…\Quest Software\Toad for Oracle 12.1\Toad.exe”

Brg

Damir

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

12

It has not crashed since that one where I posted on the forum.

This means you haven't did anything since that moment (one incident presented) and all works OK? And the only thing you did was write an post to forum?

Hm...

Br

Damir

P.S.

Sorry if I misunderstand you ...

13

Did other things. But not as intense

Sent from my iPhone

On Feb 26, 2014, at 11:10 PM, "damir.vadas_531" bounce-damirvadas_531@toadworld.com wrote:

RE: Toad 12 for Oracle hanging and crashing

Reply by damir.vadas_531

It has not crashed since that one where I posted on the forum.

This means you haven't did anything since that moment (one incident presented) and all works OK? And the only thing you did was write an post to forum?

Hm...

Br

Damir

P.S.

Sorry if I misunderstand you ...

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

14

THX for your answer.

Could you tell o public what you did to preserve time to other people who can fall in similar problem in the future?

Brg

Damir

15

I had no end of problems including crashes (trapped, which was nice) and the inability to edit data in grids (WITH rowid). If I tried to edit, it would just spin the cursor then go back. I presume that was also a crash of sorts.

My solution was to quit the app, trash my preferences for 12, MOVE the 11 preferences out of the same folder so it didn’t reimport, and recreate them. It’s been very unpleasant. This version feels extremely half-baked.

16

Did you report these exceptions to support? If they were trapped there should be an option to see the error report which you can then send to us. That error report helps us fix bugs.

On 03/12/2014 02:04 PM, bill.graefe wrote:

RE: Toad 12 for Oracle hanging and crashing

Reply by bill.graefe
I had no end of problems including crashes (trapped, which was nice) and the inability to edit data in grids (WITH rowid). If I tried to edit, it would just spin the cursor then go back. I presume that was also a crash of sorts.

My solution was to quit the app, trash my preferences for 12, MOVE the 11 preferences out of the same folder so it didn't reimport, and recreate them. It's been very unpleasant. This version feels extremely half-baked.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

17

I spent enough time on doing that I didn’t want to figure out how to report issues too

18

Simply copy the call stack from the error report and paste it into a message to this forum.

On 03/12/2014 02:13 PM, bill.graefe wrote:

RE: Toad 12 for Oracle hanging and crashing

Reply by bill.graefe
I spent enough time on doing that I didn't want to figure out how to report issues too

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

19

I spoke too soon. It crashed yesterday. The crash dialog makes it look like it was sent so I don’t understand why I need to paste it. I’ll do that with the next one. At least in-grid editing works.

20

The error report is not automatically sent. If the dialog you see has "To see what data this error report contains, click here" then click it. On the dialog that opens, check "Copy to Clipboard" on the lower right and click OK. Paste the clipboard contents
into a message to this list. If the dialog doesn't allow you to access the report then send a screenshot of the dialog.

On 03/13/2014 12:50 PM, bill.graefe wrote:

RE: Toad 12 for Oracle hanging and crashing

Reply by bill.graefe
I spoke too soon. It crashed yesterday. The dialog makes it look like it was sent but I can't be sure. At least in-grid editing works.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.