Toad World® Forums

Can't initialize OCI. Error -1

I installed Oracle 11.2.0 client(32 bit) and installed TOAD 12.7 32 bit. Witin TOAD, I can see the correct values in SQLNET Editor and TNSNames Editor.But when ever I try to connect to any DB, I see the below error.

Can’t initialize OCI. Error -1

Both my CLASSPATH and PATH have the below value configured.

C:\ProgramData\Oracle;C:\ProgramData\Oracle;C:\Oracle\product\11.2.0\client_1\bin;

The support bundle is as below:-

************************************************************************

** APPLICATION INFORMATION - FULL VERSION (32-bit)

************************************************************************

Support Bundle for Toad for Oracle 12.7.0.121

This copy of Toad for Oracle registered to SYMANTEC CORPORATION

Bundle: Add-Ons: Toad for Oracle Xpert (32-bit)DB Admin Module

Edition: Toad for Oracle Xpert

Toad for Oracle Executable Location : C:\Toad\Toad for Oracle 12.7\Toad.exe

User Profile Directory : C:\Users\anindya_jena\AppData\Roaming\Dell\Toad for Oracle\12.7\

Knowledge Xpert DLL (RevBase.dll) could not be found!

QSEServer DLL Location : C:\Toad\Toad for Oracle 12.7\qse.dll

QSEServer DLL Version : 12.7.0.121

QP5 DLL Location : C:\Toad\Toad for Oracle 12.7\QP5.dll

QP5 DLL Version : 5.277.15068.26972

QP5CA DLL Location : C:\Toad\Toad for Oracle 12.7\QP5CA.dll

QP5CA DLL Version : 5.277.15068.28290

SciLexer DLL Location : C:\Toad\Toad for Oracle 12.7\SciLexer.dll

SciLexer DLL Version : 3.5.4.3

TOAD Policy Location : C:\Toad\Toad for Oracle 12.7\Toad.pdl

************************************************************************

** TEAM CODING

************************************************************************

************************************************************************

** MANAGED ITEMS

************************************************************************

Not a managed environment.

************************************************************************

** ORACLE CLIENT INFORMATION

************************************************************************

Oracle Client Version : 11.2.0.1

Oracle Client DLL : C:\Oracle\product\11.2.0\client_1\BIN\oci.dll

TNSNAMES.ora Location : C:\Oracle\product\11.2.0\client_1\network\admin\tnsnames.ora

NLS_LANG : AMERICAN_AMERICA.WE8MSWIN1252

SQLPATH : C:\Oracle\product\11.2.0\client_1\dbs

LOCAL :

************************************************************************

** ORACLE SERVER INFORMATION

************************************************************************

NOT CONNECTED

************************************************************************

** SYSTEM INFORMATION

************************************************************************

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

Is Terminal Server: No

Using XP Theme: Yes

Physical Memory Load : 11.72 %

Physical Memory (Total) : 32393 MB

Physical Memory (Free) : 28597 MB

Virtual Memory (Total) : 2047 MB

Virtual Memory (Free) : 1374 MB

Swap Space (Total) : 65084 MB

Swap Space (Free) : 61108 MB

Toad Page File Usage (Virtual Memory) : 193 MB

Toad Working Set Usage (RAM) : 239 MB

Environment Variable (PATH) :

 C:\ProgramData\Oracle

 C:\Oracle\product\11.2.0\client_1\bin

 C:\Program Files\Internet Explorer



 C:\windows\system32

 C:\windows

 C:\windows\System32\Wbem

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

Environment Variable (TNS_ADMIN) : C:\Oracle\product\11.2.0\client_1\network\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:\Oracle\product\11.2.0\client_1

 ORACLE_HOME_NAME = OraClient11g_home1

 ORACLE_GROUP_NAME = Oracle - OraClient11g_home1

 ORACLE_BUNDLE_NAME = Enterprise

 NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

 MSHELP_TOOLS = C:\Oracle\product\11.2.0\client_1\MSHELP

 SQLPATH = C:\Oracle\product\11.2.0\client_1\dbs

OraClient11g_home1

 C:\Oracle\product\11.2.0\client_1\bin exists

 C:\Oracle\product\11.2.0\client_1\bin is in PATH

 Home is valid

************************************************************************

** FORMATTER OPTIONS: C:\Users\anindya_jena\AppData\Roaming\Dell\Toad for Oracle\12.7\User Files\FmtPlus.opt

************************************************************************

************************************************************************

** Most Recent Error Detail

************************************************************************

EurekaLog 7.0.7.1

Application:


1.1 Start Date : Wed, 1 Jul 2015 14:58:04 -0700

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

1.3 Version Number : 12.7.0.121

1.4 Parameters :

1.6 Up Time : 3 minute(s), 52 second(s)

Exception:


2.1 Date : Wed, 1 Jul 2015 15:01:56 -0700

2.2 Address : 0000000008C632AA

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

2.5 Type : EAccessViolation

2.6 Message : Access violation at address 0000000008C632AA in module ‘Toad.exe’. Read of address 0000000000000090

2.7 ID : 96760000

2.8 Count : 1

2.11 Sent : 0

User:


3.2 Name : Windows User

3.3 Email:

Active Controls:


4.1 Form Class : TfrmLogin

4.2 Form Text : Toad for Oracle Database Login Version 12.7.0.121

4.3 Control Class: TButton

4.4 Control Text : TNSNames Editor

Computer:


5.2 Total Memory : 33966743552 (31.63 Gb)

5.3 Free Memory : 28661805056 (26.69 Gb)

5.4 Total Disk : 240054693888 (223.57 Gb)

5.5 Free Disk : 104529571840 (97.35 Gb)

5.6 System Up Time : 11 minute(s), 55 second(s)

5.7 Processor : Intel® Core™ i7-4800MQ CPU @ 2.70GHz

5.12 Virtual Machine:

Operating System:


6.1 Type : Microsoft Windows 7 (64 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=3396; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

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

|7FFFFFFE|03 |0000000000000000|0000000008C632AA|Toad.exe |0000000004AD32AA|tdDBGlobals | |OraFilePath | |

|00000040|03 |000000000042DE98|0000000008C638C2|Toad.exe |0000000004AD38C2|tdDBGlobals | |OracleUtilityPath | |

|00000040|03 |000000000042DF08|00000000075A28B7|Toad.exe |00000000034128B7|frmTNSNamesEditor| |InitializeValues | |

|00000040|03 |000000000042DF48|00000000075A3128|Toad.exe |0000000003413128|frmTNSNamesEditor|TTNSNamesEditorForm|FormCreate | |

|00000040|04 |000000000042DF88|00000000045D6EA3|Toad.exe |0000000000446EA3|Vcl.Forms |TCustomForm |DoCreate |3693[3] |

|00000040|04 |000000000042DFD8|00000000045D6898|Toad.exe |0000000000446898|Vcl.Forms |TCustomForm |AfterConstruction |3577[1] |

|00000040|04 |000000000042E018|000000000419D19D|Toad.exe |000000000000D19D|System | |_AfterConstruction |14213[2] |

|00000040|04 |000000000042E078|00000000045D675B|Toad.exe |000000000044675B|Vcl.Forms |TCustomForm |Create |3572[35] |

|00000040|03 |000000000042E108|000000000857AFD9|Toad.exe |00000000043EAFD9|Login |TfrmLogin |TNSNamesEditorClick | |

|00000040|04 |000000000042E178|0000000004460354|Toad.exe |00000000002D0354|Vcl.Controls |TControl |Click |7320[9] |

|00000040|04 |000000000042E1B8|0000000004497F06|Toad.exe |0000000000307F06|Vcl.StdCtrls |TCustomButton |Click |5160[3] |

|00000040|04 |000000000042E1E8|0000000004498E82|Toad.exe |0000000000308E82|Vcl.StdCtrls |TCustomButton |CNCommand |5621[1] |

|00000040|04 |000000000042E228|000000000419CE2E|Toad.exe |000000000000CE2E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042E278|000000000445FA93|Toad.exe |00000000002CFA93|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042E3E8|0000000004466E73|Toad.exe |00000000002D6E73|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|04 |000000000042E4B8|0000000004497990|Toad.exe |0000000000307990|Vcl.StdCtrls |TButtonControl |WndProc |5002[13] |

|00000040|04 |000000000042E4F8|000000000445F56D|Toad.exe |00000000002CF56D|Vcl.Controls |TControl |Perform |6982[10] |

|00000040|04 |000000000042E558|0000000004467059|Toad.exe |00000000002D7059|Vcl.Controls | |DoControlMsg |10045[12] |

|00000040|04 |000000000042E598|00000000044683C3|Toad.exe |00000000002D83C3|Vcl.Controls |TWinControl |WMCommand |10320[1] |

|00000040|04 |000000000042E5D8|000000000419CE2E|Toad.exe |000000000000CE2E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042E628|000000000445FA93|Toad.exe |00000000002CFA93|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042E798|0000000004466E73|Toad.exe |00000000002D6E73|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|04 |000000000042E868|00000000044660E7|Toad.exe |00000000002D60E7|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |000000000042E8B8|0000000004267C14|Toad.exe |00000000000D7C14|System.Classes | |StdWndProc |13895[8] |

|00000040|03 |000000000042E908|0000000076D39BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666)| |

|00000040|03 |000000000042E9C8|0000000076D372C6|user32.dll |00000000000172C6|USER32 | | (possible SetWindowTextW+626) | |

|00000040|03 |000000000042EA28|0000000076D36826|user32.dll |0000000000016826|USER32 | | (possible IsDialogMessageW+358) | |

|00000040|03 |000000000042EA88|0000000076F8DAE2|ntdll.dll |000000000004DAE2|ntdll | |KiUserCallbackDispatcher | |

|00000040|03 |000000000042EB10|0000000076D3685A|user32.dll |000000000001685A|USER32 | | (possible IsDialogMessageW+410) | |

|00000040|03 |000000000042EB18|0000000076D33831|user32.dll |0000000000013831|USER32 | | (possible GetWindowLongPtrA+113) | |

|00000040|03 |000000000042EBA8|0000000076D36BA8|user32.dll |0000000000016BA8|USER32 | |SendMessageW | |

|00000040|03 |000000000042EBF8|000007FEFB320C5A|comctl32.dll |00000000000A0C5A|comctl32 | |CreateMRUListW | |

|00000040|03 |000000000042EC38|000007FEFB324899|comctl32.dll |00000000000A4899|comctl32 | |CreateMRUListW | |

|00000040|03 |000000000042ECF8|0000000076D39BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666)| |

|00

Issue got resolved after including the below path in CLASSPATH.

C:\Oracle\product\11.2.0\client_1\oci\include