Re: check oracle client version on server side??
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'), SYS_OP_VERSION(ksuseclvsn), ksusecldrv, decode(bitand(ksusecllbf,1), 1, 'Client
Temp Lob Rfc On', 'Client Temp Lob Rfc Off'), ksuseclregid from x$ksusecon where 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-lReceived on Wed Oct 06 2010 - 23:57:26 CDT