opatch utility command example - Oralce 19c
opatch utility command example - Oralce 19c
-- Get Oracle home Patching detail
$ORACLE_HOME/OPatch/opatch version : To get the opatch utility version
$ORACLE_HOME/OPatch/opatch lsinventory
$ORACLE_HOME/OPatch/opatch lsinv : Same as lsinventory
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh /u01/app/19c/grid
$ORACLE_HOME/OPatch/opatch lspatches : Provides a Patch Summary Report
SET LINES 300 pages 30
col comp_id for A15
col comp_name for A45
col version for A20
col status for A15
select comp_id, comp_name, version, status, modified from dba_registry;
SET LINES 300
COL description for A55
col action for A10
COL status FOR A10
COL action_time FOR A30
select patch_id, patch_type, target_version, description, action, status, action_time from dba_registry_sqlpatch;