From: "Tyfanie Wineriter" <tyfaniew@uoregon.edu>
To: "'oracle-l digest users'" <oracle-l@freelists.org>
References: <4B8DA563.7060104@tpg.com.au>
In-Reply-To: <4B8DA563.7060104@tpg.com.au>
Subject: Find Oracle Client Version - from the Database side
Date: Wed, 3 Mar 2010 08:32:36 -0800
Message-ID: <01a301cabaef$22095ef0$661c1cd0$@edu>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Language: en-us
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: tyfaniew@uoregon.edu

Hello Oracle-L,

I was wondering if anyone knew where to find a view of client
versions/releases connected to the database.

I know you can find out a lot from USERENV and gv$session, as well as
"string $ORACLE_HOME/lib/libclntsh.so | grep ^Version" if I'm on their
machine.  Unfortunately, I have not been able to find a place that says
"This person is logged in using the Oracle 11g client" or "Oracle 10g
client" from the database side.

I know that must be available somewhere, or the database wouldn't be able to
be configured for a ORA-28040 error (sqlnet.allowed_logon_version).

We are running on a 10gR2 database, and are looking for a way to find users
that have not updated their client, or are accidentally using the wrong
client.

Thanks In Advance.

~ Tyfanie Wineriter ~

Database Administrator
University of Oregon

--
http://www.freelists.org/webpage/oracle-l