-
Hi,
How do i determine the version and release number of oracle installed on Windows 2000 and Solaris 8 platfom.
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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
-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|