Wrong Value For CLIENT_VERSION in V$SESSION_CONNECT_INFO (Doc ID 1419025.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The value of client_version from v$session_connect_info might be wrong under some circumstances:



C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN>sqlplus system/manager@prod_xp

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Feb 20 20:01:39 2012

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

SQL> select SID, client_version from v$session_connect_info where SID=15;

SID CLIENT_VERSION
---------- ----------------------------------------
15 0.0.0.0.0
15 0.0.0.0.0
15 0.0.0.0.0




The expected results are:

SQL> select SID, client_version from v$session_connect_info where SID=15;

SID CLIENT_VERSION
---------- ----------------------------------------
15 10.2.0.5.0
15 10.2.0.5.0
15 10.2.0.5.0

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms