Oracle patch info

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/