Re: SID and Service Name
- From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Thu, 07 Jul 2011 13:10:09 -0500
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:
