Re: which difference inside file tnsnames.ora

Ale wrote:

> Hi,
> I have installed Oracle Server since few time, so I think I'll make an
> obvious question.
>
> I would like to know the difference between this two services declared into
> my tnsnames.ora file:
>
> FIRST =
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = test1)(PORT = 1526))
>
> )
>
> (CONNECT_DATA =
>
> (SERVER = DEDICATED)
>
> (SERVICE_NAME = SMSTEST)
>
> )
>
> )
>
> SECOND =
>
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>
> )
>
> (CONNECT_DATA =
>
> (SID = mitico)
>
> (SERVER = DEDICATED)
>
> )
>
> )
>
>
>
> The second one is the classic service with a SID, i.e. a DB, but I don't
> understand the first one, it's a DB too but without SID and with a
> service_name ? That's the same ?
>
>
>
> thanx all
>
> Ale

A change Oracle instituted somewhere between 8 and 9i.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)