Re: Difference between SID and SERVICE_NAME

On 9 Jul 2002 05:45:39 -0700, marcel.kraupp_at_gmx.ch (Marcel Kraupp) wrote:

>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

Databases register themselves with the listener. They do that using the service_name parameter of init.ora.
New facilities will be provided using this syntax. I think Transparent Application Failover is one of them.
SID is basically retained for backwards compatibility reasons (OEM still needs it)

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 09 2002 - 12:17:10 CDT