Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SID or SERVICE_NAME

Re: SID or SERVICE_NAME

From: Pieter <phuiberts-123_at_ivwnet.com>
Date: Sat, 29 Jun 2002 10:50:40 -0400
Message-ID: <3D1DC940.3070209@ivwnet.com>


Thanks a lot!

Sybrand Bakker wrote:
> On Fri, 28 Jun 2002 22:40:46 -0400, Pieter <phuiberts-123_at_ivwnet.com>
> wrote:
>
>

>>Call it a silly question if you will but I would like to know anyway.
>>I have a Linux server running Oracle 8.1.6. and it runs fine. Through 
>>some client I connect to the SID (oralin) and with another I connect to 
>>the SERVICE_NAME (voyager, the computer name).
>>
>>What is better practise to connect to SID or SERVICE_NAME, or is there 
>>no difference nor preference at all?
>>
>>Thanks a bunch,
>>Pieter

>
>
> SID is for backwards compatibility reasons only, and wouldn't allow
> you to use newer features as connection pooling and transparent
> application failover. You basically need it when using pre-8i clients
> and for Oracle Enterprise Manager.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
-- 
Remove '-123' (no quotes) from the e-mail address when you wish to reply

-Happy Trails ;-)
Received on Sat Jun 29 2002 - 09:50:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US