"DA Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1109298539.979997_at_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_at_x.washington.edu
> (replace 'x' with 'u' to respond)
Received on Thu Feb 24 2005 - 22:20:58 CST
