"OCI8: Cannot allocate OCI handle" error message while running SQL Tool

0 votes
asked by about SQLTools
edited by

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

4 Answers

0 votes
No avatar answered by (9.6k points)

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.

0 votes
answered by

Hi All,

Till yesterday am using sql tools suddenly from today morning am getting this Error, Kindly help me out

Thanks in Advance

0 votes
answered by

Paul Malgey:
Your response is not clear enough, what extract are you talking about?

We merely run setup.exe for SQLtools and also Oracle10g

Can you please provide step by step if possible ?

0 votes
answered by

right click on sqltool and select Run as administrator. it will run

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...