Toad for oracle error Can't initialize OCI. Error -1. Error means Oracle client command OCIEnvCreate has failed with code -1

268 Views Asked by At

enter image description here

The error looks like this -

Can't initialize OCI. Error -1

Items Checked

1. Toad bitness matches Oracle client bitness (64-bit)
2. ORACLE_HOME environment variable is not set (good).

Possible Solutions
Reinstall the Oracle client.
    • Deinstall the Oracle client.
    • Reboot.
    • Verify that HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE is removed from registry.
    • Verify that HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE is removed from registry.
    • Verify that the Oracle client folder is removed
    • Verify that OCI.DLL does not exist anywhere on your hard drive.
    • Reinstall the Oracle client.  Use a newer version if possible.

Tips
This error means that the Oracle client command "OCIEnvCreate" has failed with the result code of -1.

This error is seen every time I try to connect to any of the DBs on my profile.

Have tried rebooting my machine and reinstalling Toad but that did not work

Run toad with administrator privilege logs into toad but when logged in as a regular user gives same error.

0

There are 0 best solutions below