1. How to verify Oracle database patchset?
$ORACLE_HOME/OPatch/opatch lsinventory
 |
2. How to find more details of patchset?
$ORACLE_HOME/OPatch/opatch lsinventory -details
 |
3. How to check the version of all the components installed in DB?
sqlplus / as sysdba -- be sure to login as sys as dba_registry shows components owned by “current” user.
set linesize 200
set pagesize 200
col comp_name format a50
select comp_name,version,status from dba_registry;
 |
4. How to get information about upgrades, downgrades, and critical patch updates that have been performed on the database?
set linesize 200
set pagesize 200
col action_time format a30
col action format a10
col namespace format a12
col version format a12
col bundle_series format a25
col comments format a20
select * from dba_registry_history;
 |
5. Other helpful Oracle support Document IDs
No.
|
Description
|
Oracle Document ID
|
1
|
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets
|
1454618.1
|
2
|
Introduction to Oracle Recommended Patches
|
756388.1
|
3
|
Oracle Recommended Patches — Oracle Database
|
756671.1
|
4
|
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets
|
1454618.1
|
5
|
Release Schedule of Current Database Releases
|
742060.1
|
No comments:
Post a Comment