Share |

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

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
Now, add a new 'User variable' for ORACLE_HOME and set its value to the correct location of the Oracle home you want to use.



When you change your system to use a different Oracle home, make sure to also make the necessary changes to your environment variable.

If all of this fails, and you are connected using a remote desktop, or are using Citrix, following steps might help:

Permissions on the folders (give users read and execute) and the "create global objects" security setting are the problem. Instructions to fix:

To resolve this issue, identify the users group that is used to run the program, and then assign the "Create global objects" user right to that users group. To do this, follow these steps:
  1. Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy.
  2. Expand Local Policies, and then click User Rights Assignment.
  3. In the right pane, double-click Create global objects.
  4. In the Local Security Policy Setting dialog box, click Add.
  5. In the Select Users or Group dialog box, click local users group or the user account that you want to add, click Add, and then click OK.
  6. Click OK.
When you perform these steps, make sure you read about the security concerns at the microsoft website.
 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for this Oracle tip Add your own message



At the moment there are no forum messages. You can add your own question.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: pkgtg8b74sbcn5mkc


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.