Re: SID and Service Name
Date: Thu, 07 Jul 2011 13:10:09 -0500
Message-ID: <4E15F681.2090000_at_ardentperf.com>
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_at_sid
>
> NIALL _at_ sid >select service_name from v$session where sid = (select
> sid from v$mystat where rownum = 1);
>
> SERVICE_NAME
> ----------------------------------------------------------------
> SYS$USERS
>
> NIALL _at_ sid >conn niall/niall_at_niall
> Connected.
> NIALL _at_ 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 07 2011 - 13:10:09 CDT