Okay, I found this in the forums:
oci.dll not found when installing 11g client and using PL/SQL
I don't know if it is apply in my case because I right click on "C:\app" but there is nothing called "authenticated users" in the users names!
so should I add it?
Guys, I installed Oracle 11g client because of the reported fix of System.Transactions issue known in 10g. I use PL/SQL developer, and it told me "Initialization error: Could not locate OCI dll", though the registry entry and ORAHOME folder it showed were Ok. It seems like PL/SQL developer was looking for OCI.dll not in the reported ORAHOME folder but in ORAHOME\bin folder. After copying all files (luckily, they are quite few) from ORAHOME root to bin PL/SQL developer began to work correctly.
982134 wrote:Did you notice that you are hijacking a thread that is almost FIVE YEARS old?!?!?!
after a follow what you did, and copy all dlls to \bin directory,error is changed to "could not resolve the connect identifier specified"
i have oracle client 10g and ODP.net 11g, i dont know about solution , help plz
For a problem that has nothing to do with the subject of the five year old thread??
You should have started your own thread for your own issue, but since we are here, I strongly suspect that your "could not resolve the connect identifier specified" was also accompanied by the actual error code of ora-12154. You can read my description of the cause and resolution of that [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] here
I found one of the replies in another thread useful.
1. PL/SQL Developer -> Tools Menu -> Oracle -> Connection entry : Set Oracle Home and OCI Library paths.
Set the OCI path tp C:\oracle\product\11.2.0\client_2\oci.dll
2. Copy oci.dll into C:\oracle\product\11.2.0\client_2\bin
It looks like the tool looks for oci.dll in the home dir when it logs in and needs it in the bin dir while running querybuilder.