Re: TNS / Could not resolve service name

On 29 Aug 2003 06:46:24 -0700, thomas_at_stremlow.de (Thomas Stremlow) wrote:

>Hello,
>
>I installed the Oracle 8.1i server on a Windows XP machine. After the
>installation I tested the connection successfully with sqlplus, this
>works fine.
>
>Unfortunately I'm not able to establish a successful connection from
>another machine as well as from the same machine in another oracle
>root directory. In both cases I installed the Oracle Enterprise
>Manager and I tried it with the Enterprise Manager and sqlplus. The
>returned message is ORA 12263 TNS unable to connect to destination /
>ORA 12154 TNS could not resolve service name.
>
>Although the tnsnames.ora in these oracle directories are identical to
>the one in the server directory, it doesn't work. The one and only
>workaround is to use the notation host:port:service, this works.
>
>Do you know the reason of this behaviour?
>
>Thanks & Regards
>Thomas Stremlow

The reason for this is believing Oracle 8i will automatically run on a platform for which it never certified, in conjunction with the belief all Microsux products are always 100 percent downwards compatible.
It also doesn't make any sense to post questions without including the tnsnames.ora, especially as the error is described profusely in the troubleshooting section of the net8 manual, which you also didn't read

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Aug 29 2003 - 09:21:26 CDT