Unable to get TOAD to work on Windows Terminal Services (WTS) on an IBM Blade server over an Oracle 10g RAC 10.2.0.3 database.
The error: 'Can't initialise OCI' appears when trying to connect.
First check:
1. What roles/privileges do the non-Admin-users have?
2. Is Windows Group Policy Manager being used?
3. Is Toad Group Policy Manager being used?
If this is a privilege issue (File-system-rights), please look through the following steps:
1. Give Read/Write privileges on the oracle home directory. E.g. C:\Oracle\product\10.2.0\client_1.
2. Power users will additionally require Read access to the Oracle client folder. E.g. C:\Oracle\product\10.2.0\client_1\bin (specifically the OCI.DLL File)
3. Please make sure that power users have access to the following registry keys:
a. HKEY_LOCAL_MACHINE>SOFTWARE>ORACLE
b. HKEY_LOCAL_MACHINE>SOFTWARE>ORACLE>KEY_OraClient10g_home1
4. Under Toad.exe Properties | Compatibility tab | User Account Privileges, make sure the "Allow non-administrators to run this programme" box is checked.
(you can check the Compatibility option on the server where Toad is installed. The Compatibility tab is available only for programs that are installed on your hard disk.)
5. Assign "Poweruser" privileges to the user and re-test the issue again.
Also check the following:
The administrator OS should give the following permission: Start -> Administrative Tools ->Local Security Policy -> User Rights Assignment -> Create global objects
