ORA:12154 TNS Could Not Resolve Service Name

26 Feb 2006 7:25 PM

Ram

Hey,
I'm using ODP.Net on my server.
Until recently I had ODP version 9.2.0.2102 and now I've upgraded to
9.2.0.700.
All my applications that upgraded to 9.2.0.700 work perfectly,
But all the old applications still compiled with the 2102 version
receive:
ORA:12154 TNS Could Not Resolve Service Name
NOTE: both the applications work on the same server,
And on that server there is only ONE ORACLE_HOME...
Is there anything I'm forgetting?
Thanks ahead

--sternr

27 Feb 2006 5:03 AM

Sahil Malik [MVP C#]

You need to edit your tnsnames.ora file.

- SM

Show quote

"Ram" <Ste***@gmail.com> wrote in message
news:1140981921.824181.325320@v46g2000cwv.googlegroups.com...
> Hey,
> I'm using ODP.Net on my server.
> Until recently I had ODP version 9.2.0.2102 and now I've upgraded to
> 9.2.0.700.
> All my applications that upgraded to 9.2.0.700 work perfectly,
> But all the old applications still compiled with the 2102 version
> receive:
> ORA:12154 TNS Could Not Resolve Service Name
> NOTE: both the applications work on the same server,
> And on that server there is only ONE ORACLE_HOME...
> Is there anything I'm forgetting?
> Thanks ahead
>
> --sternr
>

27 Feb 2006 2:33 PM

Ram

Hey Sahil thanks for your reply!
As I mentioned before - there is not problem with my TNSNAMES.ora file
- since
TNSPing does work...
Anyway - I found the problem!
It turns out the ODP.Net cant handle files with ")" in their names
(DONT ASK WHY!)
But the second I renamed my file, all went well!
Thanks again!

--sternr