Re: SQLPlus version tracking
Date: Thu, 19 Jan 2012 16:38:31 -0500
Message-ID: <CADo_RaOKpJaz0F07Kyh8NEcV9jWK=Kpqqrr7-We7ubnKn6Vrzw_at_mail.gmail.com>
I don't know, my luck with that view has been sort of hit and miss. As the others have noted the information is just not there or a place holder of some sort. It's really up to the client software that you are using to pass that information on to the server. For instance if I access 11.2 from a 9i client the client_verson is populated with 0.0.0.0. However, if I access 11.2.0.3 from a 11.2.0.1 (windows) client I get the following:
$ sqlplus andy/andy_at_oimt1
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 19 16:13:27 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL> select * from v$version;
BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production
SQL> select client_driver, client_version from v$session_connect_info where sid = sys_context('USERENV','SID');
CLIENT_DR CLIENT_VERSION
--------- ---------------------------------------- SQL*PLUS 11.2.0.1.0
SQL*PLUS 11.2.0.1.0
SQL*PLUS 11.2.0.1.0 SQL> create table logger (tstamp date, msg varchar2(100));
Table created.
SQL> CREATE OR REPLACE TRIGGER andy.after_logon_trg
2 AFTER LOGON ON andy.SCHEMA
3 BEGIN
4 for rec in (select client_driver, client_version from
v$session_connect_info where sid = sys_context('USERENV','SID') and rownum
= 1)
5 loop
6 -- dbms_application_info.set_action('using '|| rec.client_driver ||
' ' || rec.client_version);
7 insert into logger values (sysdate, 'using '|| rec.client_driver ||
' ' || rec.client_version);
8 end loop;
9 END;
10 /
Trigger created.
SQL> conn andy/andy_at_oim1t
Connected.
SQL> select * from logger;
TSTAMP
MSG
19-JAN-12
using SQL*PLUS 11.2.0.1.0
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-lReceived on Thu Jan 19 2012 - 15:38:31 CST