Re: SERVICE_NAME and SID

From: Sergey Keberle <prog_at_unisoft.dp.ua>
Date: Thu, 31 May 2001 15:21:36 +0400
Message-ID: <25957875@unisoft.com>

<astrodan_at_tiscalinet.it> wrote in message news:oppgetcqonnfnq3mrjl17bvskn6n396tov_at_4ax.com...
> 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

They are different if you use domain not equal as ' ' For example,
I have sid - orcl
and service_name - orcl.oracle.com

You must use in tnsname both connection strings and keep in mind what you use!
Look at the example files
You can see how do you write it.

Sergey Received on Thu May 31 2001 - 06:21:36 CDT