Re: Difference between SID and SERVICE

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 9 Jul 2002 14:27:39 +0100
Message-ID: <fxBW8.826$zX3.824@news.indigo.ie>

      Net8 Administrator's Guide
      Release 8.1.5
      A67440-01

Understanding Release 8.1 Installation and Net8 Products Has all the information you need.

"Marcel Kraupp" <marcel.kraupp_at_gmx.ch> wrote in message news:332bb004.0207090445.4380593_at_posting.google.com...
> Hello Everybody
>
> Today, we had an issue where we'd regularly would get
> an "ORA-03123 operation would block" error. This
> could be solved by changing the entry in tnsnames.ora
> using SERVICE_NAME=xyz instead of SID=xyz
>
> Now, while this seems perfect to live with, it still makes
> me wonder what the difference between SID and SERVICE_NAME
> is. I was led to believe that SID is used up to and including
> 8i, while SERVICE_NAME is used 8i onwards, but basically mean
> the same thing. Obviously, they don't. Who can enlighten me?
>
> TIA
> MK
Received on Tue Jul 09 2002 - 08:27:39 CDT

Re: Difference between SID and SERVICE_NAME