While removing and reinstalling a Management agent. I ran into the problem where after a successful uninstall using The Oracle Universal Installer. I was not able to remove the almost empty directory saying the file oci.dll is still in use, so an Access Denied error is displayed.
Cannot Find Oci Dll
- Unable to find the dll: 'OCI.dll' Within Alteryx this error will be prompted due to a mismatch between 32/64 bit drivers and the Alteryx bit version. This error may also appear if you do not have the drivers installed. One way to troubleshoot this is to find out what drivers you have installed!
- I was able to find out the reason why it couldn't load the OCI DLL. Apparently no matter what version of TOAD you have, it is incompatible with 64 bit installations of oracle. TOAD looks for oracle installations under HKEYLOCALMACHINE/SOFTWARE/WOW6432NODE/ORACLE which is where because that is where 32 bit installations are registered.
After a restart the same problem presented itself over and over again.
Find the location of OCI.dll (Windows+F on XP/7/Vista) Copy that OCI.dll and paste it in your set up folder of SQL NAvigator, most probably 'C:Program FilesQuest SoftwareSQL Navigator 5.5' You may still get some error like 'Can't initialise OCI.dll-Error 1'.
Cannot Find Oci Dll Toad Oracle Vm
After some research i found that stopping the “Distributed Transaction Coordinator” service before deleting the old directory ( with oci.dll in it ) will help. After that the service can be started again offcourse.
Toad Cannot Find Oci Dll
Background information on the service:
Cannot Find Oci Dll Toad Oracle Query
The Distributed Transaction Coordinator (MSDTC) service is a component of modern versions of Microsoft Windows that is responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems. MSDTC is included in Windows 2000 and later operating systems, and is also available for Windows NT 4.0.
MSDTC performs the transaction coordination role for components, usually with COM and .NET architectures. In MSDTC terminology, the director is called the transaction manager.