SQLTools questions & answers

Front-end database manager for Oracle
G
Question by Guest
6K views
May 31, 2012

When I start running SQL Tool, it gives me an error message "OCI8: Cannot allocate OCI handle".


Program: SQLTools 1.4.1 Beta build 66 (for trouble-shooting)
Location: .\SQLTools.cpp(236).
Platform: MS Windows XP Professional, Service Pack 3 (Build 2600)
COMCTL32.DLL: 6.0.2900.5512
OCI.DLL: 9.2.0.1.0


Stuck at the catch point:
0x7c90e4f4 KiFastSystemCallRet() + 0

P
Answer by Paul Malgey

Either you have an incomplete Oracle Client installed ( SQLTools need a fully functional Oracle Client ), or you could try to delete the OCI.DLL from your Windows folder and create a link to the SQLTools.exe that contains the "Start In" property set to the folder where you have extracted the InstantClient to - this way the complete InstantClient will be found.

See more questions & answers

Ask a question about SQLTools

Alternative downloads

PL/SQL Developer
rating

Manage databases, execute SQL scripts, and develop program units for Oracle DBs.

SQL Developer
Free
rating

All new releases of SQL Developer require a full installation

Oracle Maestro
rating

It is an Oracle admin tool for database management.