SERVICE_NAME and SID

From: <astrodan_at_tiscalinet.it>
Date: Thu, 26 Apr 2001 18:21:46 GMT
Message-ID: <rupget0vcoenem0vv1nm78623h6e1gehem_at_4ax.com>


Hello! This is Danilo from Rome.
[Quoted] 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 - 20:21:46 CEST

Original text of this message