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 ORACLE_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:
- Open up the Control Panel
- Double click on the SYSTEM icon
- Goto the Advanced tab page
- 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:
- Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy.
- Expand Local Policies, and then click User Rights Assignment.
- In the right pane, double-click Create global objects.
- In the Local Security Policy Setting dialog box, click Add.
- 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.
- Click OK.
When you perform these steps, make sure you read about the security concerns at the microsoft website.
Hiç yorum yok:
Yorum Gönder