Difference between revisions of "Patching"
From dbawiki
(Created page with "On bog standard iron, this was a fairly simple procedure. Download the patch, stop the databases and listeners and opatch the ORACLE_HOME.<br /> Now things are getting more in...") |
|||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | On bog standard iron, this | + | On bog standard iron, this is a fairly simple procedure. Download the patch, stop the databases and listeners and opatch the ORACLE_HOME. See general procedure [[Applying patches]]<br /> |
| + | [https://saruamit4.wordpress.com/2016/01/10/confusion-about-oracle-patches/ a word about the different patching terminology;overlay, merge, bundle etc..]<br /> | ||
| + | * [http://logic.edchen.org/how-to-apply-patch-in-oracle/ how to apply patch in oracle] | ||
| + | ===What patches are installed?=== | ||
| + | ====Display the Patch inventory==== | ||
| + | <pre> | ||
| + | $ORACLE_HOME/OPatch/opatch lsinventory | ||
| + | </pre> | ||
| + | ====Display just the patches==== | ||
| + | <pre> | ||
| + | $ORACLE_HOME/OPatch/opatch lspatches | ||
| + | </pre> | ||
| + | ====From SQL*Plus in version 11==== | ||
| + | dba_registry_history is a view on registry$history | ||
| + | <pre> | ||
| + | col action_time for a21 | ||
| + | col action for a15 | ||
| + | col namespace for a15 | ||
| + | col version for a15 | ||
| + | col comments for a80 wrap | ||
| + | select action_time, action, namespace, version, id, comments from dba_registry_history order by 1; | ||
| + | </pre> | ||
| + | |||
| + | ====From SQL*Plus in version 12==== | ||
| + | <pre> | ||
| + | select extract(sys.dbms_qpatch.get_opatch_list,'//patchDescription|//appliedDate|//patchID') from dual; | ||
| + | </pre> | ||
| + | |||
Now things are getting more interesting...<br /> | Now things are getting more interesting...<br /> | ||
| − | [[Patching Oracle Database Appliance (ODA)]] | + | |
| − | [[Patching Exadata]] | + | ===Patching ODA & Exadata=== |
| + | * [[Patching Oracle Database Appliance (ODA)]] | ||
| + | * [[Patching Exadata]] | ||
Latest revision as of 17:32, 1 November 2018
On bog standard iron, this is a fairly simple procedure. Download the patch, stop the databases and listeners and opatch the ORACLE_HOME. See general procedure Applying patches
a word about the different patching terminology;overlay, merge, bundle etc..
Contents
What patches are installed?[edit]
Display the Patch inventory[edit]
$ORACLE_HOME/OPatch/opatch lsinventory
Display just the patches[edit]
$ORACLE_HOME/OPatch/opatch lspatches
From SQL*Plus in version 11[edit]
dba_registry_history is a view on registry$history
col action_time for a21 col action for a15 col namespace for a15 col version for a15 col comments for a80 wrap select action_time, action, namespace, version, id, comments from dba_registry_history order by 1;
From SQL*Plus in version 12[edit]
select extract(sys.dbms_qpatch.get_opatch_list,'//patchDescription|//appliedDate|//patchID') from dual;
Now things are getting more interesting...
