Difference between revisions of "Patching"
From dbawiki
| Line 1: | Line 1: | ||
On bog standard iron, this was a fairly simple procedure. Download the patch, stop the databases and listeners and opatch the ORACLE_HOME.<br /> | On bog standard iron, this was a fairly simple procedure. Download the patch, stop the databases and listeners and opatch the ORACLE_HOME.<br /> | ||
[https://saruamit4.wordpress.com/2016/01/10/confusion-about-oracle-patches/ a word about the different patching terminology;overlay, merge, bundle etc..]<br /> | [https://saruamit4.wordpress.com/2016/01/10/confusion-about-oracle-patches/ a word about the different patching terminology;overlay, merge, bundle etc..]<br /> | ||
| + | ===What patches are installed?=== | ||
| + | From command line | ||
| + | <pre> | ||
| + | $ORACLE_HOME/OPatch/opatch lspatches | ||
| + | </pre> | ||
| + | ====Version 11==== | ||
| + | <pre> | ||
| + | select action, namespace, version, id, comments from dba_registry_history; | ||
| + | </pre> | ||
| + | ====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 Oracle Database Appliance (ODA)]] | ||
* [[Patching Exadata]] | * [[Patching Exadata]] | ||
Revision as of 10:11, 15 May 2017
On bog standard iron, this was a fairly simple procedure. Download the patch, stop the databases and listeners and opatch the ORACLE_HOME.
a word about the different patching terminology;overlay, merge, bundle etc..
What patches are installed?
From command line
$ORACLE_HOME/OPatch/opatch lspatches
Version 11
select action, namespace, version, id, comments from dba_registry_history;
Version 12
select extract(sys.dbms_qpatch.get_opatch_list,'//patchDescription|//appliedDate|//patchID') from dual;
Now things are getting more interesting...
