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

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@x.washington.edu
(replace 'x' with 'u' to respond)

DA Morgan wrote:
> Ale wrote:
>
[...]
>> I would like to know the difference between this two services declared
>> into my tnsnames.ora file:
>>
>> FIRST =
>>
>> (ADDRESS = (PROTOCOL = TCP)(HOST = test1)(PORT = 1526))
[...]
>> (SERVICE_NAME = SMSTEST)
[...]
>> SECOND =
>>
[...]
>>
>> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[...]
>> (SID = mitico)
>>
[...]
>>
>> 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.

http://download-west.oracle.com/docs...dstpr.htm#7853

The other differences are the non-standard port number in the first
example, which requires LOCAL_LISTENER parameter to be set in the
database for auto-registration to work, and the use of "localhost" in
the second, which is unusual.

-Mark Bole

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1109298539.979997@yasure...
> 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.


The OP didn't specify a version. As I recall, 8 required the use of SID in
tnsnames.ora. In 8i, use of SERVICE_NAME was the default, but SID would
still work just fine. The two, of course, aren't necessarily the same. When
the entry was created with the Net8 Configuration Assistant, the choice was
offered - 8 or 8i, that was the difference.

--
Randy Harris
(tech at promail dot com)



> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace 'x' with 'u' to respond)