Difference between revisions of "Patching"
From dbawiki
(→From SQL*Plus in version 11) |
|||
| Line 7: | Line 7: | ||
</pre> | </pre> | ||
====From SQL*Plus in version 11==== | ====From SQL*Plus in version 11==== | ||
| + | dba_registry_history is a view on registry$history | ||
<pre> | <pre> | ||
| − | select action, namespace, version, id, comments from dba_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; | ||
</pre> | </pre> | ||
| + | |||
====From SQL*Plus in version 12==== | ====From SQL*Plus in version 12==== | ||
<pre> | <pre> | ||
Revision as of 11:08, 17 October 2018
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..
Contents
What patches are installed?
From command line
$ORACLE_HOME/OPatch/opatch lspatches
From SQL*Plus in version 11
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
select extract(sys.dbms_qpatch.get_opatch_list,'//patchDescription|//appliedDate|//patchID') from dual;
Now things are getting more interesting...
