Re: SERVICE_NAME and SID

The SID= was used in pre-8.1 configurations ( and still is used, if you want ):

In my tnsnames.ora we have the following entries ( real info removed)

oneofmydbs =
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclehost1)(PORT=1521)) (CONNECT_DATA=(SID=oneofmydbs)(Server=Dedicated)))  and
anotherdb =
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orahost2)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=anotherdb.world)))

The first is 8.0 and earlier format the other is 8.1 and newer..Both work..

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 Fri Apr 27 2001 - 13:41:37 CDT