You can use DBA_REGISTRY_HISTORY to display information about upgrades, downgrades, and critical patch updates that have been performed on the database. As of Oracle Release 10g and up to 12c generally: $ORACLE_HOME\OPatch\opatch lsinventory (Windows)ģ. $ORACLE_HOME/OPatch/opatch lsinventory (UNIX) Methods from OS levelĮxecute the following command under ora \ adm \ oracle user: On this session you will refer to methods on how to identify the list of Oracle patches (SBP, DBBP) or Bundle patches that are installed from R3 level and OS level. $WLS_HOME/server/bin/setWLSEnv.The purpose of this page is to clarify how to identify oracle patches or bundle patches (SBP) in SAP system. Grid Infrastructure: $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'GIPSU'Ĭluster Ready Services: $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'TRACKING BUG' | grep -i 'PSU'Įnterprise Manager Agent: $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'ENTERPRISE MANAGER AGENT' | grep -i 'PSU'Įnterprise Manager OMS: $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'ENTERPRISE MANAGER OMS' | grep -i 'PSU' The above views are populated when catbundle.sql is executed. …and for pre-12c database versions: COL comments FOR A30 SELECT description, version, action, TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time SELECT comments, version, action, TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time To check the registered database version (12c upwards): COL comments FOR A70
(The first command above being for Linux)
$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep -i 'DATABASE PSU|DATABASE PATCH SET UPDATE' To check the Oracle Home version: $ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i -E 'DATABASE PSU|DATABASE PATCH SET UPDATE' Unfortunately they do not change version numbers in the Oracle binaries, product banners and such though (see MOS 861152.1), so here’s how to identify which PSU your ORACLE_HOME is at… Oracle PSUs (Patch Set Updates) are referenced by their 5-place version number. How to check which PSU is installed…if any
0 kommentar(er)
