Correct - it does not If I connect from window (client) to a unix DB the only information is about UNIX and the unix DB version. No mention of windows and version details Thanks Raj Pande http://goto/employeeid/43190252 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of rjamya Sent: Thursday, January 19, 2012 3:06 PM To: William.Blanchard@xxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: SQLPlus version tracking I checked in 11201 and 11202, the client_driver is not populated. I believe this questino hs been discussed before and there was no confirmed solution found. //www.freelists.org/post/oracle-l/check-oracle-client-version-on-server-side,4 Raj On Thu, Jan 19, 2012 at 2:50 PM, Blanchard, William G <William.Blanchard@xxxxxxxxxxxxx> wrote: > Andy, > Thank you. The v$session_connect_info view has a client_driver which may > give me what I'm looking for. It's obvious that Oracle has the information > but how do I get it in a logon trigger? I tried client_driver with > sys_context with no luck. > > > WGB > > > From: andyklock@xxxxxxxxx [mailto:andyklock@xxxxxxxxx] On Behalf Of Andy Klock > Sent: Thursday, January 19, 2012 1:33 PM > To: Blanchard, William G > Cc: oracle-l@xxxxxxxxxxxxx > Subject: Re: SQLPlus version tracking > > There is a view v$session_connect_info that may give you what you are looking > for. > On Thu, Jan 19, 2012 at 2:19 PM, Blanchard, William G > <William.Blanchard@xxxxxxxxxxxxx<mailto:William.Blanchard@xxxxxxxxxxxxx>> > wrote: > Does anyone know if there's a way to track the version of sqlplus that is > connecting to the database? I looked at sys_context and system events but > haven't found anything. > > WGB > > _____________ > The information contained in this message is proprietary and/or confidential. > If you are not the intended recipient, please: (i) delete the message and all > copies; (ii) do not disclose, distribute or use the message in any manner; > and (iii) notify the sender immediately. In addition, please be aware that > any message addressed to our domain is subject to archiving and review by > persons other than the intended recipient. Thank you. > > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l Please visit our website at http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information. -- //www.freelists.org/webpage/oracle-l