Re: could not resolve service name

"DukeNM" <akshaysalkar_at_joymail.com> wrote in message news:f987cd53.0110272216.2307fb19_at_posting.google.com...
> ERROR: ORA-12154: TNS: could not resolve service name
>
> does any1 know what this means...and how to overcome this problem
>
> username : scott
> passwd: tiger
> host string: myora
>
> i have personal oracle8i in d:\oracle
> and d2k in d:\d2k
>
> it connects with the SQLPlus
> however with d2k when i try to connect it gives the above error message.
> does any 1 know a solution to the problem...

This question has been answered soo many times, that it is amazing it keeps popping up over and over again.
You didn't

- read the net8 troubleshooting manual provided by Oracle
- searched the archives of this newsgroup at http://groups.google.com
- searched the faq hosted by Jonathan Lewis at http://jlcomp.demon.co.uk
- searched http://www.orafaq.com

But anyway for the *last* time
12154 means you don't have the service_name myora in your tnsnames.ora Now d2k uses a different tnsnames.ora than oracle8i. You need to keep those two in sync
or set up the TNS_ADMIN registry var in hklm\software\oracle to point to the correct one.

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Sun Oct 28 2001 - 01:36:59 CDT