-
How can I know what is the latest patches applied to our Oracle Server. I query v$version and I saw this :
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
Does it mean there is no patches applied to this machine??
An ounce of prevention is worth a pound of cure
-
This is a good question.
A patch that replaces a library file or two then recompiles the oracle executable doesn't change the v$version number.
I've tried running the executable ... for command line switches that return the current version... but that doesn't work...
oracle -version
oracle /version
oracle -help
oracle /help
I'm stumped...
-
Hello, here's what I got on one of our server:
SVRMGR> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
PL/SQL Release 8.1.7.3.0 - Production
CORE 8.1.7.0.0 Production
TNS for DEC OSF/1 AXP: Version 8.1.7.3.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
5 rows selected.
I've just applied the 8.1.7.3 patch set and nothing else.
Regards,
Noel.
-
Noel, you're right. Sometimes the v$version information is updated. But certainly not always, I've got a number of examples of that.
-
Then the question is if v$version for some reasons doesn't show the last patches, any other way ???
An ounce of prevention is worth a pound of cure
-
Checked MetaLink and found the following:
How to Determine Database Version After Applying Patch
I have recently upgraded/patched my Windows 2000 8.1.7.0.0 installation to 8.1.7.1.1 and then to 8.1.7.1.5. When I query v$version I get:
BANNER
----------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
PL/SQL Release 8.1.7.1.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.1.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
Also, when I run OUI, all I get is a listing for the 81711 patchset, not the 81715.
The patch notes mention that "not all components will display the 81715 version number because of cumulative patch", but I can't find any that have this number.
Is there anything I can do to confirm that a database has been patched to 8.1.7.1.5? The 81715 patch was simply a file copy - I suppose one could check the files in question and see if they match the date/time stamp and size of the ones included in the patch, but is there a better way?
SUPPORT's REPLY:
This is expected and do not know of any other way than the one you already mentioned. There was another customer with exact issue and versions which you refer by using the advanced search,
Doc ID: 262585.999 Subject: Patch not reflected in database version
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
|