Re: check oracle client version on server side??

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 07 Oct 2010 06:57:26 +0200
Message-ID: <4CAD5336.4040307_at_roughsea.com>



I am not sure that even in 11gR2 this column is very useful.

SQL> desc GV$SESSION_CONNECT_INFO

 Name                       Null?    Type
 ----------------------------------------- --------

----------------------------
INST_ID NUMBER SID NUMBER SERIAL# NUMBER AUTHENTICATION_TYPE VARCHAR2(26) OSUSER VARCHAR2(30) NETWORK_SERVICE_BANNER VARCHAR2(4000) CLIENT_CHARSET VARCHAR2(40) CLIENT_CONNECTION VARCHAR2(13) CLIENT_OCI_LIBRARY VARCHAR2(27) CLIENT_VERSION VARCHAR2(40) CLIENT_DRIVER VARCHAR2(9) CLIENT_LOBATTR VARCHAR2(23) CLIENT_REGID NUMBER

SQL> select VIEW_DEFINITION
  2 from v$fixed_view_definition
  3 where VIEW_NAME = 'GV$SESSION_CONNECT_INFO'   4 /

VIEW_DEFINITION



select inst_id, ksusenum, ksuseser, decode(ksuseaty, 0, 'DATABASE', 1, 'OS', 2,
 'NETWORK', 3, 'PROXY', 4, 'SERVER', 5, 'PASSWORD', 6, 'EXTERNAL ADAPTERS', 7,
'INTERNAL', 8, 'GLOBAL', 9, 'EXTERNAL', 10, 'PASSWORD BASED GLOBAL USER', '?'),
  ksuseunm, ksuseban,
decode(ksusecsid,0,'Unknown',nls_charset_name(ksusecsid)) , decode(bitand(ksuseflags,1), 0, 'Heterogeneous', 'Homogeneous'), decode(ksuse
cllib,1,'Home-based',2,'Full Instant Client',            3,'XE Instant Cl
ient',4,'Light Weight Instant Client',              5,'OCI','Unknown'),  S
YS_OP_VERSION(ksuseclvsn), ksusecldrv, decode(bitand(ksusecllbf,1), 1, 'Client
Temp Lob Rfc On',                   'Client Temp Lob Rfc Off'),
 ksuseclregid  from x$ksusecon                               w
here bitand(ksuseflg,1)!=0 and bitand(ksuseflg,16)=0

SQL> select ksuseunm, ksuseclvsn, sys_op_version(ksuseclvsn)   2 from x$ksusecon
  3 where ksuseclvsn <> 0
  4 /

KSUSEUNM KSUSECLVSN
------------------------------ ----------
SYS_OP_VERSION(KSUSECLVSN)


oracle                186646784

11.2.0.1.0
oracle                186646784

11.2.0.1.0
oracle                186646784

11.2.0.1.0

KSUSEUNM KSUSECLVSN
------------------------------ ----------
SYS_OP_VERSION(KSUSECLVSN)


oracle                186646784

11.2.0.1.0

SQL> select sys_op_version(1234) from dual;

SYS_OP_VER



11.2.0.1.0

SQL> Looks like a place-holder to me.

Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>

On 10/06/2010 11:17 PM, Michael Elkin wrote:

> In Oracle 11g new columns were added to the view
> v$session_connect_info , like CLIENT_VERSION but in 10gR2,
> unfortunately,  this column does not exist.
>
> Michael
>
>
> On Wed, Oct 6, 2010 at 7:34 PM, Tyfanie Wineriter
> <tyfaniew_at_uoregon.edu <mailto:tyfaniew_at_uoregon.edu>> wrote:
>
>     I have investigated this thoroughly & concluded that no, it is not
>     possible
>     in Oracle 10gR2 to discover what version of an Oracle client is
>     connecting
>     to your database.  If someone on here discovers otherwise, I would
>     love to
>     hear about it.
>
>     I have heard that in 11g, there is a new parameter in sys_context
>     that does
>     have this, but I am not on 11g & have not tested it.
>
>
>     ~ Tyfanie Wineriter ~
>
>     Database Administrator
>     University of Oregon
>
>
>     -----Original Message-----
>     From: oracle-l-bounce_at_freelists.org
>     <mailto:oracle-l-bounce_at_freelists.org>
>     [mailto:oracle-l-bounce_at_freelists.org
>     <mailto:oracle-l-bounce_at_freelists.org>]
>     On Behalf Of dba1 mcc
>     Sent: Tuesday, October 05, 2010 5:42 AM
>     To: oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
>     Cc: oracle-db-l_at_Groups.ITtoolbox.com
>     <mailto:oracle-db-l_at_Groups.ITtoolbox.com>
>     Subject: check oracle client version on server side??
>
>     we have ORACLE 10GR2 on DELL LINUX serve.  I have questions relate
>     to ORACLE
>     client connection:
>
>     1. does there have ways to check on server side each ORACLE client
>     connection use which version of ORACLE client (e.g. 9ir2, 10gr2, ..)?
>
>     2. any way to check on server side each ORACLE client if connect
>     through
>     ODBC. Which ODBC use (e.g. ORACLE ODBC 9ir2, 10gr2, or MS ODBC)?
>
>     Thanks.
>
>
>
>     --
>     http://www.freelists.org/webpage/oracle-l
>
>
>
>     --
>     http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> -- 
> Best Regards
> Michael Elkin



--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 06 2010 - 23:57:26 CDT

Original text of this message