Cannot load OCI DLL error after upgrade and/or copy user settings

Toad for Oracle & DevOps Toolkit
1

I currently have Toad for Oracle 12.1 installed on my laptop. When I install 12.6, my user settings are getting automatically imported into the new version. The problem is when I try to connect to a database, I get this error:

Cannot load OCI DLL: C:\app\mgtessier\product\11.2.0\client_1\BIN\oci.dll

The oci.dll doesn’t currently reside in the \BIN folder, nor did it with the 12.1 version. I’m using Windows 7 32-bit, and I’ve installed 32-bit Oracle InstantClient and every version of Toad that I’ve installed has been 32-bit.

I’ve also reproduced this error with a clean install where I used the Copy User Settings utility to copy my 12.1 settings from my network share to the new install. Before importing my settings, I tried to connect to a database and it was successful. Only after I import my user settings does database connections fail.

I read that copying user settings from version to version is only supported within 2 release versions, so I’ve tried to install 12.5 and 12.5.1. 12.5 would hang when I tried to run it, and 12.5.1 has the same issue that I’m experiencing now with 12.6.

I have a lot of custom settings in my installation of Toad (code formatting, layout, etc.) that I’d really like to preserve going forward rather than have to figure out how I set them up out all over again.

Any ideas what I did wrong? How do I fix it?

Thanks in advance,

Mike

2

Do you only have that one client installed? Does Toad identify all installed clients properly? From the login window click the button to the right of the client dropdown. Does everything look correct in that window? Close Toad and open Toad.ini in a text editor.
Delete the line starting with "ToadOracleHome" if it exists and try again.

On 10/15/2014 03:16 PM, michael.tessier wrote:

Cannot load OCI DLL error after upgrade and/or copy user settings

Thread created by michael.tessier
I currently have Toad for Oracle 12.1 installed on my laptop. When I install 12.6, my user settings are getting automatically imported into the new version. The problem is when I try to connect to a database, I get this error:

Cannot load OCI DLL: C:\app\mgtessier\product\11.2.0\client_1\BIN\oci.dll

The oci.dll doesn't currently reside in the \BIN folder, nor did it with the 12.1 version. I'm using Windows 7 32-bit, and I've installed 32-bit Oracle InstantClient and every version of Toad that I've installed has been 32-bit.

I've also reproduced this error with a clean install where I used the Copy User Settings utility to copy my 12.1 settings from my network share to the new install. Before importing my settings, I tried to connect to a database and it was successful. Only
after I import my user settings does database connections fail.

I read that copying user settings from version to version is only supported within 2 release versions, so I've tried to install 12.5 and 12.5.1. 12.5 would hang when I tried to run it, and 12.5.1 has the same issue that I'm experiencing now with 12.6.

I have a lot of custom settings in my installation of Toad (code formatting, layout, etc.) that I'd really like to preserve going forward rather than have to figure out how I set them up out all over again.

Any ideas what I did wrong? How do I fix it?

Thanks in advance,

Mike

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.

3

Thanks for the reply Michael.

Yes, I only have 1 client installed. When I click the ellipsis to the right of the client dropdown, everything looks correct in the window. I followed your instructions and deleted the “ToadOracleHome” from Toad.ini. Same error message when I start Toad again after the change and try to connect to a database.

4

Nothing is jumping out at me at the moment. I'd try to figure out which file is the culprit. The likely files would be Toad.ini and the saved connection files. Close Toad and rename Toad.ini. Start Toad and try. If the error persists close Toad, restore your
backed up Toad.ini and rename ConnectionActions.ini, ConnectionPwds.ini, and Connections.ini. Does the error persist? If so, close Toad and restore your Connection*.ini files. Open Connections.ini in a text editor and clear the OracleHome= value for each of
your saved connections. In fact, clearing the OracleHome= setting might be a good first step. If you have only one home installed that setting does nothing useful for you.

On 10/15/2014 04:02 PM, michael.tessier wrote:

RE: Cannot load OCI DLL error after upgrade and/or copy user settings

Reply by michael.tessier
Thanks for the reply Michael.

Yes, I only have 1 client installed. When I click the ellipsis to the right of the client dropdown, everything looks correct in the window. I followed your instructions and deleted the "ToadOracleHome" from Toad.ini. Same error message when I start Toad
again after the change and try to connect to a database.

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.

5

I followed all of those steps. Same error for each step.

6

Please post your support bundle text. It’s available from the Help menu.

7

APPLICATION INFORMATION - FULL VERSION (32-bit)

Support Bundle for Toad for Oracle 12.6.0.53

This copy of Toad for Oracle registered to CAMBRIAN COLLEGE

Bundle: Add-Ons: Toad for Oracle Base (32-bit)

Toad for Oracle Executable Location : C:\Program Files\Dell\Toad for Oracle 12.6\Toad.exe

User Profile Directory : C:\Users\mgtessier\AppData\Roaming\Dell\Toad for Oracle\12.6\

Knowledge Xpert DLL Location : C:\Program Files\Dell\Toad for Oracle 12.6\Revbase.dll

Knowledge Xpert Version : 5.6.0.6

QSEServer DLL Location : C:\Program Files\Dell\Toad for Oracle 12.6\qse.dll

QSEServer DLL Version : 12.6.0.53

QP5 DLL Location : C:\Program Files\Dell\Toad for Oracle 12.6\QP5.dll

QP5 DLL Version : 5.269.14213.34746

QP5CA DLL Location : C:\Program Files\Dell\Toad for Oracle 12.6\QP5CA.dll

QP5CA DLL Version : 5.269.14213.35870

TOAD Policy Location : C:\Program Files\Dell\Toad for Oracle 12.6\Toad.pdl

TEAM CODING

MANAGED ITEMS

Not a managed environment.

ORACLE CLIENT INFORMATION

NOT CONNECTED

ORACLE SERVER INFORMATION

NOT CONNECTED

SYSTEM INFORMATION

Operating System: Windows 7 (Build 7601)Service Pack 1

Is Terminal Server: No

Using XP Theme: Yes

Physical Memory Load : 52.04 %

Physical Memory (Total) : 3259 MB

Physical Memory (Free) : 1563 MB

Virtual Memory (Total) : 2047 MB

Virtual Memory (Free) : 1614 MB

Swap Space (Total) : 6516 MB

Swap Space (Free) : 4621 MB

Toad Page File Usage (Virtual Memory) : 152 MB

Toad Working Set Usage (RAM) : 176 MB

Environment Variable (PATH) :

C:\Program Files\Java\jdk1.6.0_45\bin

C:\groovy-1.8.8\bin

C:\grails-1.3.9\bin

C:\app\mgtessier\product\11.2.0\client_1\bin

C:\app\mgtessier\product\11.2.0\client_1

C:\Program Files\Common Files\Microsoft Shared\Windows Live

C:\WINDOWS\system32

C:\WINDOWS

C:\WINDOWS\System32\Wbem

C:\WINDOWS\System32\WindowsPowerShell\v1.0\

C:\Program Files\QuickTime\QTSystem\

C:\Program Files\Windows Live\Shared

C:\PROGRAM FILES\OPENOFFICE.ORG 3\URE\BIN

C:\PROGRAM FILES (X86)\OPENOFFICE.ORG 3\URE\BIN

Environment Variable (TNS_ADMIN) : \entora1\TNS_ADMIN

ORACLE HOMES DATA

(Oracle Root)

inst_loc = C:\Program Files\Oracle\Inventory

KEY_OraClient11g_home1 ***** This is the home currently used by Toad *****

ORACLE_HOME = C:\app\mgtessier\product\11.2.0\client_1

ORACLE_HOME_NAME = OraClient11g_home1

ORACLE_GROUP_NAME = Oracle - OraClient11g_home1

NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

ORACLE_BUNDLE_NAME = Enterprise

MSHELP_TOOLS = C:\app\mgtessier\product\11.2.0\client_1\MSHELP

OraClient11g_home1

C:\app\mgtessier\product\11.2.0\client_1 exists

C:\app\mgtessier\product\11.2.0\client_1 is in PATH

Home is valid

FORMATTER OPTIONS: C:\Users\mgtessier\AppData\Roaming\Dell\Toad for Oracle\12.6\User Files\FmtPlus.opt

[PlfOptionsOracle]

CodeReviewFilter=Default

[Qp5FormatterOptions]

Version=145

Tagline=0

Most Recent Error Detail

EurekaLog 7.0.3.0

Application:

1.1 Start Date : Tue, 14 Oct 2014 08:38:31 +0400

1.2 Name/Description: Toad.exe - (Toad for Oracle)

1.3 Version Number : 12.1.0.22

1.4 Parameters :

1.6 Up Time : 6 hour(s), 16 minute(s), 19 second(s)

Exception:

2.1 Date : Tue, 14 Oct 2014 14:54:50 +0400

2.2 Address : 049FDD3A

2.3 Module Name: Toad.exe - (Toad for Oracle)

2.5 Type : EAccessViolation

2.6 Message : Access violation at address 049FDD3A in module ‘Toad.exe’. Read of address 3E6C2A0E

2.7 ID : A53C0000

2.8 Count : 2

2.11 Sent : 0

User:

3.2 Name : Information Technology

3.3 Email:

Active Controls:

4.1 Form Class : TfrmMain

4.2 Form Text : Toad for Oracle - [CAMBRIAN@BANPROD - Editor (New 1 *)]

4.3 Control Class: TToadCXGridSite

4.4 Control Text :

Computer:

5.2 Total Memory : 3417542656

5.3 Free Memory : 937881600

5.4 Total Disk : 319703478272

5.5 Free Disk : 274912514048

5.6 System Up Time: 6 hour(s), 25 minute(s), 19 second(s)

5.7 Processor : Intel® Core™ i5-3210M CPU @ 2.50GHz

Operating System:

6.1 Type : Microsoft Windows 7 (32 bit)

6.2 Build #: 7601

Steps to reproduce:

8.1 Text:

Call Stack Information:

|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line|

|*Exception Thread: ID=3308; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

|----------------------------------------------------------------------------------------------------------------------|

|7FFFFFFE|03 |00000000|049FDD3A|Toad.exe |0086DD3A|MemData |TMemData |OmitRecord | |

|00000040|03 |0042F2CC|049FEBAF|Toad.exe |0086EBAF|MemData |TMemData |BookmarkValid | |

|00000040|03 |0042F2E8|0495DBAA|Toad.exe |007CDBAA|MemDS |TMemDataSet |BookmarkValid | |

|00000040|03 |0042F308|04B7F615|Toad.exe |009EF615|cxDBData |TcxDBDataProvider |BookmarkValid | |

|00000040|03 |0042F33C|04B7E5B5|Toad.exe |009EE5B5|cxDBData |TcxDBDataLink |DataSetChanged | |

|00000040|03 |0042F364|047CD13D|Toad.exe |0063D13D|Data.DB |TDataLink |DataEvent | |

|----------------------------------------------------------------------------------------------------------------------|

| |

|Running Thread: ID=7020; Parent=0; Priority=-1 |

|Class=; Name= |

|DeadLock=0; Wait Chain=thread: [ 1B6C / 7020 ] is blocked |

|Comment= |

|----------------------------------------------------------------------------------------------------------------------|

|00000040|03 |2ABCFEDC|76F4C3CE|kernel32.dll|0004C3CE|kernel32 | |WaitForSingleObjectEx| |

|00000040|03 |2ABCFEF4|76F4C37D|kernel32.dll|0004C37D|kernel32 | |WaitForSingleObject | |

|00000040|03 |2ABCFF08|04C9397B|Toad.exe |00B0397B|MPThreadManager|TCommonEventThread|Execute | |

|00000040|03 |2ABCFF5C|04C93542|Toad.exe |00B03542|MPThreadManager|TCommonThread |ExecuteStub | |

|00000040|03 |2ABCFF88|76F4EE1A|kernel32.dll|0004EE1A|kernel32 | |BaseThreadInitThunk | |

Modules Information:

|Handle |Name |Description |Version |Size |Modified |Path |

|01410000|privman32.dll |BeyondTrust PowerBroker for Windows DLL |5.5.1.42 |136920 |2013-01-16 15:52:52|C:\Windows\System32\ |

|04190000|Toad.exe |Toad for Oracle |12.1.0.22 |19606328 |2013-08-29 12:29:54|C:\Program Files\Quest Software\Toad for Oracle 12.1\ |

|0B660000|qwave.dll |Windows NT |6.1.7600.16385 |210944 |2009-07-13 21:16:12|C:\Windows\System32\ |

|10000000|btpload32.dll |BeyondTrust Profiler Loader |5.5.1.10 |82288 |2013-01-16 15:52:32|C:\Windows\System32\ |

|105B0000|oci.dll |Oracle Call Interface |11.2.0.1 |987136 |2010-04-02 07:42:34|C:\app\mgtessier\product\11.2.0\client_1\ |

|126A0000|shdocvw.dll |Shell Doc Object and Control Library |6.1.7601.18222 |180224 |2013-07-25 21:55:59|C:\Windows\System32\ |

|12870000|wintrust.dll |Microsoft Trust Verification APIs |6.1.7601.18205 |175104 |2013-07-09 00:52:10|C:\Windows\System32\ |

|12EF0000|audiodev.dll |Portable Media Devices Shell Extension |6.1.7601.17514 |243712 |2010-11-20 08:18:04|C:\Windows\System32\ |

|12FA0000|PortableDeviceApi.dll |Windows Portable Device API Components |6.1.7601.17514 |547840 |2010-11-20 08:20:55|C:\Windows\System32\ |

|13030000|WMASF.DLL |Windows Media ASF DLL |12.0.7600.16385 |237568 |2009-07-13 21:16:19|C:\Windows\System32\ |

|13530000|EhStorAPI.dll |Windows Enhanced Storage API |6.1.7601.17514 |128512 |2010-11-20 08:18:38|C:\Windows\System32\ |

|13560000|linkinfo.dll |Windows Volume Tracking |6.1.7600.16385 |22016 |2009-07-13 21:15:36|C:\Windows\System32\ |

|13A70000|QSE.dll |QSE DLL |12.1.0.22 |2124088 |2013-08-29 13:16:50|C:\Program Files\Quest Software\Toad for Oracle 12.1\ |

|14260000|hhctrl.ocx |Microsoft® HTML Help Control |6.1.7600.16385 |523776 |2009-07-13 21:14:10|C:\Windows\System32\ |

|19110000|mxdwdrv.dll |Microsoft XPS Document Writer |0.3.7601.17514 |781824 |2010-11-20 08:20:27|C:\Windows\System32\spool\drivers\w32x86\3\ |

|191E0000|OraOCIEI11.dll |Oracle Call Interface Instant Client |11.2.0.1 |126205952|2010-04-02 07:49:34|C:\app\mgtessier\product\11.2.0\client_1\ |

|22560000|QP5.dll | |5.256.13226.35510 |17351504 |2013-08-14 20:06:26|C:\Program Files\Quest Software\Toad for Oracle 12.1\ |

|25150000|NetworkExplorer.dll |Network Explorer |6.1.7601.17514 |1661440 |2010-11-20 08:20:29|C:\Windows\System32\ |

|372D0000|wpdshext.dll |Portable Devices Shell Extension |6.1.7601.17514 |2311168 |2010-11-20 08:21:38|C:\Windows\System32\ |

|37FD0000|WMVCORE.DLL |Windows Media Playback/Authoring DLL |12.0.7601.17514 |2504192 |2010-11-20 08:20:57|C:\Windows\System32\ |

|3FEC0000|MSOXMLMF.DLL |Microsoft Office XML MIME Filter |14.0.7005.1000 |49776 |2012-10-31 13:21:48|C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ |

|5A1C0000|msftedit.dll |Rich Text Edit Control, v4.1 |5.41.21.2510 |592384 |2010-11-20 08:19:47|C:\Windows\System32\ |

|5C940000|GrooveIntlResource.dll | |14.0.6009.1000 |8801120 |2010-10-20 16:45:26|C:\Program Files\Microsoft Office\Office14\1033\ |

|5D600000|fontsub.dll |Font Subsetting DLL |6.1.7601.18177 |70656 |2013-06-06 00:51:29|C:\Windows\System32\ |

|5D620000|SendToOneNoteUI.DLL |Microsoft OneNote Print Driver UI |14.0.4763.1000 |54656 |2010-03-29 21:26:00|C:\Windows\System32\spool\drivers\w32x86\3\ |

|5D7E0000|OFFICE.ODF | &nbs