Re: SID or SERVICE_NAME

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 Received on Sat Jun 29 2002 - 00:49:02 CDT