Can’t initialize OCI error occured during the login process using TOAD

Posted on by

You are using TOAD, and you are getting following message when trying to connect to the database:

Can’t initialize OCI Error 1

Connections using sql*plus or sql*developer using the OCI thick driver are succeeding fine.

If you have more than 1 Oracle home installed, make sure TOAD is using the correct Oracle_home.
You can either specify a TOAD_HOME in toad, or you can switch to the correct ORACLE_HOME using our free Oracle Locator Express.

If this does not work for you, one work around can be to create an environment variable ORACLE_HOME and set it to the correct Oracle_home.
Some versions of TOAD still will generate this error, even all parameters are ok.

If you are sure the correct ORACEL_HOME is inside the PATH environment variable and all registry settings are ok, than you will need to manually create the ORACLE_HOME environment variable.

In order to create this environment variable:

1. open up the Control Panel
2. Double click on the SYSTEM icon
3. Goto the Advanced tab page
4. Choose environment variables