RE: SQLPlus version tracking

From: <rajendra.pande_at_ubs.com>
Date: Thu, 19 Jan 2012 15:17:44 -0500
Message-ID: <D4C8B99EB96F2C42B4E19A3B87664F5E02E81E5C_at_NSTMC612PEX.ubsamericas.net>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Thursday, January 19, 2012 3:06 PM To: William.Blanchard_at_fisglobal.com
Cc: oracle-l_at_freelists.org
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.

http://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_at_fisglobal.com> 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_at_gmail.com [mailto:andyklock_at_gmail.com] On Behalf Of Andy Klock
> Sent: Thursday, January 19, 2012 1:33 PM
> To: Blanchard, William G
> Cc: oracle-l_at_freelists.org
> 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_at_fisglobal.com<mailto:William.Blanchard_at_fisglobal.com>> 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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://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.
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 19 2012 - 14:17:44 CST