How to determine which version and release of oracle is installed

[ronnie]

Hi,

How do i determine the version and release number of oracle installed on Windows 2000 and Solaris 8 platfom.

[Shestakov]

select * from v$version;

[ronnie]

Originally posted by Shestakov
select * from v$version;

Thanks
but it does not show me the release i.e whether it is Release 2 or 3

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

[Shestakov]

Release is logical (may be market) term. This is not real version.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for Linux: Version 8.1.7.0.0 - Development
NLSRTL Version 3.4.1.0.0 - Production

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for Linux: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production

[ronnie]

The reason I was asking this is because they fix bugs in the various releases of the product.

Like there are a total of 3 releases of 8.1.7 version,Releases 1,2 and 3.

I wanted to determine which release is our database on and if not the latest then upgrade to the latest (Actually this also is a possible question from me which i will ask later once I get the answer for the previous quetsion).

Thanks

[sambavan]

You seems to be confusing the release with the complete patch:

Release 1: 8.1.5.0.0
Release 2: 8.1.6.0.0
Release 3: 8.1.7.0.0

The Last digit will tell you the minor patch applications, the one before the last digit will tell you the major patchset applied.

You your case, it looks like that you have not applied any patches, and its on base of release 3.

Sam

[sambavan]

One other thing I forgot to mention was the patchset is a cummulative one. (i.e. you can apply patchset 3, which would comprise of the bugfixes on patchset 1 and 2), when you apply the patch for a perticular bug, then its not cummulative., In your case, you can directly apply the patchset 3 on top of the base release.

Sam

[ronnie]

Thanks a lot Sam,

Now my next question related to the previous one.

Where do I find the latest Patch for 8.1.7 windows.

I was searching for Patches on metalink under the Patches sections. Its a little confusing.

They have patches based on different products i.e Context/Import Export/Data Mining etc etc

Dont they have a simple and complete patch set which I can install which will take care of everything.

Thanks again

[sambavan]

In the metalink when you specify the database version, specify your current db version that would be 8.1.7 and not the 8.1.7.3

Choose: Oracle server
RDBMS server
Version
OS
List all the updates

Sam

[ronnie]

I did the search and it said no patches found.

The search was for

Product Family : Oracle Server
Product: RDBMS Server
Release 8.1.7.0
Platform Windows NT/2000 Server
Linit Search to : All product Patches

But I thought that Release 8.1.7.0 has 3 patches to it.

Am I doing anything wrong here