I have installed the 22.214.171.124 instant client on a developers PC. I have also installed the odbc, sqlplus and the odac libraries into the instant client home. I have set the TNS_ADMIN and PATH variables to point to the correct location. This I can prove by connecting successfully to my database from sqlplus in the instant client home.
My issue is that when the developer tries to connect through the application he receives the ora-012514 error. There are a number of full clients previously installed on this machine. How do I set the instant client to be the default. I'm guessing that this is the issue.
The ora-12154 may be caused by confusion from having multiple homes (Oracle installs), yes. But you said you set PATH and TNS_ADMIN correctly.
The error message could be simply caused by using a connect identifier that is not defined (e.g. in current tnsnames.ora). Maybe the app somehow overrides PATH setting.
Use a tool such as Process Monitor to trace the applications file activities and find out exactly where the app is looking during connection attempt.
Edited by: orafad on Oct 10, 2011 12:31 PM
I took all references to old clients out of my path and this has resolved the issue. I'm sure why this happened as I had the instant client as the first entry in the path. Anyway it's working which is the main thing.
Thanks for your help.