Re: check oracle client version on server side??

From: Michael Elkin <melkin4u_at_gmail.com>
Date: Wed, 6 Oct 2010 23:17:13 +0200
Message-ID: <AANLkTi=is6fi2pOQ+j-mV-uW8EG2LTK+buzf4kW1kGdC_at_mail.gmail.com>



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>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]
> On Behalf Of dba1 mcc
> Sent: Tuesday, October 05, 2010 5:42 AM
> To: oracle-l_at_freelists.org
> Cc: 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 - 16:17:13 CDT

Original text of this message