Re: SQLPlus version tracking

From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 20 Jan 2012 12:25:59 -0800 (PST)
Message-ID: <1327091159.31564.YahooMailClassic_at_web181211.mail.ne1.yahoo.com>

Correction to the quoted text below. According to an old note

VERSION NUMBER - Oracle version numbers explained (Doc ID 39691.1)

the five numbers of the version number are:

9.2.0.2.0

| | | | |_ Port Specific Maintenance Release 
| | | |___ Patch Sets and Patch Set CDs
| | |_____ iAS Release
| |_______ Database Maintenance Release
|_________ Major Database Release

The 3rd may be called something else now.

With some experiment, I think the widths of the numbers are 2, 1, 2, 1, 2 bytes, respectively. So we can use the following SQL to check the client version (run as sys):

with x as (select distinct to_char(ksuseclvsn,'xxxxxxxxxxxxxx') v from x$ksusecon where ksusenum = &sid and ksuseclvsn != 0) select
 to_number(substr(v,8,2),'xx') || '.' || --maj_rel

 substr(v,10,1) || '.' || --mnt_rel
 substr(v,11,2) || '.' || --ias_rel
 substr(v,13,1) || '.' || --ptc_set
 substr(v,14,2) client_version -- port_mnt

from x;

The result is like

Enter value for sid: 393 <-- enter the SID you want to check old ...
new ...
CLIENT_VERSION

---

11.1.00.7.00

If it returns no rows, the client must be 10g or lower.

Yong Huang

• On Fri, 1/20/12, Yong Huang <yong321_at_yahoo.com> wrote:

> 186647296 B200300
>
> Take the last for an example. I guess "B" is version 11, "2" is the
> release, "003" is the minor release, and "00" is the patch level

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

Received on Fri Jan 20 2012 - 14:25:59 CST