Re: SID and Service Name

This is the documented behavior, and I would expect this behavior with
any version.  (Docs have always defined "SYS$USERS" as the service for
connections that don't use a service, i.e. they use SID.)

For example, here:
http://download.oracle.com/docs/cd/E11882_01/rac.112/e16795/hafeats.htm#RACAD7123

-Jeremy


On 7/7/2011 9:22 AM, Niall Litchfield wrote:
> Someone, somewhere asked me if users connecting to a database using
> SID in the tnsnames file actually got connected to the SYS$USERS
> service. I have lost my note of where I was asked this, but oracle-l
> seems likely. The answer is (at least in 11.2 on Windows) yes. I
> apologize if this is meaningless to everyone. In the output below SID
> is my sql prom tnsalias with SID specified in connect descriptor -
> niall is the service_name variant. I've only edited the output for
> domain name. 
>
> SQL >conn niall/niall@sid
>
> NIALL @ sid >select service_name from v$session where sid = (select
> sid from v$mystat where rownum = 1);
>
> SERVICE_NAME
> ----------------------------------------------------------------
> SYS$USERS
>
> NIALL @ sid >conn niall/niall@niall
> Connected.
> NIALL @ niall >select service_name from v$session where sid = (select
> sid from v$mystat where rownum = 1);
>
> SERVICE_NAME
> ----------------------------------------------------------------
> niall.domain.name <http://niall.domain.name> 
>

-- 
http://www.ardentperf.com
+1 312-725-9249

Jeremy Schneider
Chicago

Other related posts: