This discussion is archived
3 Replies Latest reply: Feb 22, 2012 6:58 PM by 899601 RSS

ORA-012514

User317378 Newbie
Currently Being Moderated
Hi,

I have installed the 11.2.0.2 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.

Cheers,
Keith
  • 1. Re: ORA-012514
    orafad Oracle ACE
    Currently Being Moderated
    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
  • 2. Re: ORA-012514
    User317378 Newbie
    Currently Being Moderated
    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.
    Keith
  • 3. Re: ORA-012514
    899601 Newbie
    Currently Being Moderated
    Restarting the system helped me.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points