RE: SQLPlus version tracking
- From: <rajendra.pande@xxxxxxx>
- To: <rjamya@xxxxxxxxx>, <William.Blanchard@xxxxxxxxxxxxx>
- Date: Thu, 19 Jan 2012 15:17:44 -0500
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.
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@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.
>
> --
> 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
Other related posts: