Oracle patch info
oracle@apt-amd-02:/opt/app/oracle/product/11.2/OPatch> ./opatch lsinventory -bugs_fixed
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /opt/app/oracle/product/11.2
Central Inventory : /opt/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /opt/app/oracle/product/11.2/oui
Log file location : /opt/app/oracle/product/11.2/cfgtoollogs/opatch/opatch2011-06-20_14-51-20PM.log
Patch history file: /opt/app/oracle/product/11.2/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/app/oracle/product/11.2/cfgtoollogs/opatch/lsinv/lsinventory2011-06-20_14-51-20PM.txt
------------------------------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
------------------------------------------------------------------------------------------------------
OPatch succeeded.
opatch lsinventory -bugs_fixed | grep -i 'GI PSU'
opatch lsinventory -bugs_fixed | grep -i 'ENTERPRISE MANAGER AGENT' | grep -i 'PSU'
to download opatch utility go to
metalink >> patch and update
then search for 6880880 patch and OS
-bash-3.00$ opatch lsinventory -detail
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/product/10.2
Central Inventory : /opt/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /opt/oracle/product/10.2/oui
Log file location : /opt/oracle/product/10.2/cfgtoollogs/opatch/opatch2011-07-22_11-14-02AM.log
Lsinventory Output file location : /opt/oracle/product/10.2/cfgtoollogs/opatch/lsinv/lsinventory2011-07-22_11-14-02AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (3):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 3 products installed in this Oracle Home.
Installed Products (188):
Agent Required Support Files 10.2.0.1.0
Agent Required Support Files Patch 10.2.0.4.0
Assistant Common Files 10.2.0.1.0
=======================
opatch lsinventory
select * from dba_registry_history;
select substr(comp_id,1,15) comp_id, substr(comp_name,1,30) comp_name, substr(version,1,10) version, status from dba_registry order by modified;
select * from sys.registry$history;
col COMP_NAME for a50
set lines 200
col action_time for a30
col comments for a30
col ACTION for a15
select action_time, action,namespace, version, id, bundle_series, comments from registry$history;
select action_time, action, version, id, comments from dba_registry_history order by action_time;
select COMMENTS, ACTION_TIME from sys.registry$history;
select COMP_NAME, VERSION, STATUS from dba_registry;
How to Use MOS Patch Planner to Check and Request the Conflict Patches? (Doc ID 1317012.1)
google it and find patch info
Map of Public Vulnerability to Advisory/Alert
like
http://www.oracle.com/technetwork/topics/security/public-vuln-to-advisory-mapping-093627.html
===========
to download
https://updates.oracle.com/download/6880880.html
unzip p6880880_210000_Linux-x86-64.zip -d $ORACLE_HOME/
set serveroutput on;
execute dbms_optim_bundle.getBugsforBundle;
12.2.0.1.190416DBRU:
Bug: 25405100, fix_controls: 25405100
execute dbms_optim_bundle.listBundlesWithFCFixes; ----<<<<
bundleId: 180116, bundleName: 12.2.0.1.180116DBRU
bundleId: 181017, bundleName: 12.2.0.1.181017DBRU
bundleId: 190115, bundleName: 12.2.0.1.190115DBRU
bundleId: 190416, bundleName: 12.2.0.1.190416DBRU
PL/SQL procedure successfully completed.
====
with a as
(select dbms_qopatch.get_opatch_lsinventory patch_output from dual)
select x.*
from a,
xmltable('InventoryInstance/patches/*' passing a.patch_output
columns patch_id number path 'patchID',
patch_uid number path 'uniquePatchID',
description varchar2(80) path 'patchDescription',
applied_date varchar2(30) path 'appliedDate',
sql_patch varchar2(8) path 'sqlPatch',
rollbackable varchar2(8) path 'rollbackable') x
/
Oracle Database 19c Release Update & Release Update Revision October 2022 Known Issues (Doc ID 19202210.9)
RDBMS Online Patching Aka Hot Patching (Doc ID 761111.1)https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=6880880
cd $ORACLE_HOME
mv OPatch OPatch.`date +"%Y"-"%m"-"%d"`
ls -ld OPatch*
drwxr-x---. 14 oracle oinstall 4096 Apr 22 2020 OPatch.2024-04-19
===
cd $ORACLE_HOME
unzip -oq /home/oracle/Downloads/p6880880_210000_Linux-x86-64.zip
ls -ld OPatch*
drwxr-x---. 15 oracle oinstall 4096 Apr 15 14:41 OPatch
drwxr-x---. 14 oracle oinstall 4096 Apr 22 2020 OPatch.2024-04-19
db_1]$
===
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch version
OPatch Version: 12.2.0.1.42
OPatch succeeded.
or
./opatch version
OPatch Version: 12.2.0.1.42
OPatch succeeded.***********
export OPATCH_DEBUG=TRUE <<<< if requited
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch lsinventory | grep -E "(^Patch.*applied)|(^Sub-patch)"opatch lsinventory | grep -E "(^Patch)|(^Sub-patch)"
export PATH=$ORACLE_HOME/OPatch:$PATH
to clean ..
export PATH=$ORACLE_HOME/OPatch:$PATH
opatch util listorderedinactivepatches
opatch util deleteinactivepatches
opatch util cleanup
mv OPatch OPatch.`date +"%Y"-"%m"-"%d"`
mv: cannot move 'OPatch' to 'OPatch.2024-12-13': Permission denied
[grid@oragrid grid]$ pwd
/u01/app/21.3.0/grid
[grid@oragrid grid]$ pwd
/u01/app/21.3.0/grid
[grid@oragrid grid]$ logout
login as root
[root@oragrid 19.2.0]# cd /u01/app/21.3.0/grid
[root@oragrid grid]# id
uid=0(root) gid=0(root) groups=0(root)
[root@oragrid grid]# mv OPatch OPatch.`date +"%Y"-"%m"-"%d"`
[root@oragrid grid]# ls -ld OPatch*
drwxr-xr-x 13 grid oinstall 303 Jul 27 2021 OPatch.2024-12-13
[root@oragrid grid]#
As root
[root@oragrid ~]# cd /u01/app/21.3.0/grid
[root@oragrid grid]# unzip -oq /home/grid/p6880880_210000_Linux-x86-64.zip
[root@oragrid grid]# ls -ld OPatch*
drwxr-x--- 15 root root 4096 Oct 4 19:48 OPatch
drwxr-xr-x 13 grid oinstall 303 Jul 27 2021 OPatch.2024-12-13
[root@oragrid grid]# pwd
/u01/app/21.3.0/grid
[root@oragrid grid]# chown -R grid:oinstall OPatch/
