Re: TNS:could not resolve service name

J Gin wrote:
>
> I'm having problems trying to establish an sqlplus session. The error
> message returned is:
>
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
> I'm running Oracle version 8.1.5.0.0 and running the same sqlplus release on
> Solaris 2.6.
>
> I've checked the tnsnames.ora file entry and included below:
>
> isd =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp_corwan.world)
> (PROTOCOL = TCP)
> (Host = 55.55.55.55)
> (PORT = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = ISD)
> (GLOBAL_NAME = ISD.ott.can.world)
> )
> )

ORA 12154 means: The listener was successfully connected, but can't understand the clients wish to connect to an instance. Look into $ORACLE_HOME/network/log/listener.log and ../admin/listener.ora.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!