SERVICE_NAME and SID

From: <astrodan_at_tiscalinet.it>
Date: Sat, 19 May 2001 17:44:26 GMT
Message-ID: <oppgetcqonnfnq3mrjl17bvskn6n396tov@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 Received on Sat May 19 2001 - 12:44:26 CDT