Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: which difference inside file tnsnames.ora
"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)Received on Thu Feb 24 2005 - 22:20:58 CST
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)