I have investigated this thoroughly & concluded that no, it is not possible in Oracle 10gR2 to discover what version of an Oracle client is connecting to your database. If someone on here discovers otherwise, I would love to hear about it. I have heard that in 11g, there is a new parameter in sys_context that does have this, but I am not on 11g & have not tested it. ~ Tyfanie Wineriter ~ Database Administrator University of Oregon -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Tuesday, October 05, 2010 5:42 AM To: oracle-l@xxxxxxxxxxxxx Cc: oracle-db-l@xxxxxxxxxxxxxxxxxxxx Subject: check oracle client version on server side?? we have ORACLE 10GR2 on DELL LINUX serve. I have questions relate to ORACLE client connection: 1. does there have ways to check on server side each ORACLE client connection use which version of ORACLE client (e.g. 9ir2, 10gr2, ..)? 2. any way to check on server side each ORACLE client if connect through ODBC. Which ODBC use (e.g. ORACLE ODBC 9ir2, 10gr2, or MS ODBC)? Thanks. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l