Received: (qmail 776 invoked from network); 7 Jul 2011 13:11:56 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 7 Jul 2011 13:11:51 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AC4FDE32D83; Thu, 7 Jul 2011 14:11:38 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 2TkJgm9kaU44; Thu, 7 Jul 2011 14:11:38 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3842AE32793; Thu, 7 Jul 2011 14:10:55 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2011 14:10:13 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 511ABE32B38 for ; Thu, 7 Jul 2011 14:10:13 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id QMA2Wdz-BHQS for ; Thu, 7 Jul 2011 14:10:13 -0400 (EDT) Received: from mail-gw0-f51.google.com (mail-gw0-f51.google.com [74.125.83.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 09F72E327CE for ; Thu, 7 Jul 2011 14:10:12 -0400 (EDT) Received: by gwj17 with SMTP id 17so636229gwj.10 for ; Thu, 07 Jul 2011 11:10:12 -0700 (PDT) Received: by 10.150.166.8 with SMTP id o8mr1152522ybe.414.1310062212284; Thu, 07 Jul 2011 11:10:12 -0700 (PDT) Received: from [10.189.127.212] ([192.54.222.27]) by mx.google.com with ESMTPS id x6sm433358ybh.12.2011.07.07.11.10.10 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 07 Jul 2011 11:10:11 -0700 (PDT) Message-ID: <4E15F681.2090000@ardentperf.com> Date: Thu, 07 Jul 2011 13:10:09 -0500 From: Jeremy Schneider User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11 MIME-Version: 1.0 To: niall.litchfield@gmail.com CC: ORACLE-L Subject: Re: SID and Service Name References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------030207040603000209050105" X-archive-position: 37292 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jeremy.schneider@ardentperf.com Precedence: normal Reply-To: jeremy.schneider@ardentperf.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --------------030207040603000209050105 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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://www.ardentperf.com +1 312-725-9249 Jeremy Schneider Chicago --------------030207040603000209050105 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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
----------------------------------------------------------------

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

Jeremy Schneider
Chicago
--------------030207040603000209050105-- -- http://www.freelists.org/webpage/oracle-l