Re: SERVICE_NAME and SID ???

Hi Danilo,

A service name is an alias for a connect descriptor .....like this,

In tnsnames.ora you assign service names to connect descriptors in this format:

SERVICENAME = (DESCRIPTION =
(ADDRESS =
    (PROTOCOL = TCP)
    (HOST = YOURSERVER)
   (PORT = 1521)
(CONNECT DATA =
SID = SID_NAME) The service name is the alias to refer to all the mapping information below it.
The sid refers to your oracle instance.

astrodan_at_tiscalinet.it wrote:

> Hello! This is Danilo from Rome.
> I've the following error message:
>
> TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
> (Oracle 8.1.6 on Solaris)
>
> In listener.ora and tnsnames.ora there are no entry like
> SERVICE_NAME=.....
>
> Which are the differences between SERVICE_NAME and SID?
> I know the SID from $ORACLE_SID, but how may I know SERVICE_NAME?
>
> And, which entries have I put in listener.ora and tnsnames.ora ??
>
> Please help me !!!
>
> Danilo
Received on Thu Apr 26 2001 - 13:58:13 CDT