19c OCT 2024 patch apply

-
     19c OCT 2024 patch apply 
==========================
Patch 36916690 - GI Release Update 19.25.0.0.241015
Patch Number Description Applicable Homes
36912597        Database Release Update 19.25.0.0.241015        Only Oracle home for non-Oracle RAC setup. Both Oracle home and Grid home for Oracle RAC setup.
36917416 OCW Release Update 19.25.0.0.241015  Both Oracle home and Grid home
36917397 ACFS Release Update 19.25.0.0.241015 Footnote 2 Only Grid home.
36940756 Tomcat Release Update 19.0.0.0.0Footnote 2      Only Grid home.
36758186 DBWLM Release Update 19.0.0.0.0Footnote 2 Only Grid home.

You must use the OPatch utility version 12.2.0.1.43
[oracle@19ctest01 ~]$ /u01/app/grid/19.3.0/OPatch/opatch version
OPatch Version: 12.2.0.1.17
cd /u01/soft
unzip p6880880_122010_Linux-x86-64.zip -d /u01/app/grid/19.3.0
unzip p6880880_122010_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1
/u01/app/grid/19.3.0/OPatch/opatch version
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version
/u01/app/grid/19.3.0/OPatch/opatch lsinventory -detail -oh u01/app/grid/19.3.0
/u01/app/grid/19.3.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft//36916690/36912597
/u01/app/grid/19.3.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft//36916690/36917416
/u01/app/grid/19.3.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft//36916690/36917397
/u01/app/grid/19.3.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft//36916690/36940756
/u01/app/grid/19.3.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft//36916690/36758186
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/36916690/36912597
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/36916690/36917416

Run OPatch System Space Check Grid_Home
cat /tmp/patch_list_gihome.txt
/u01/soft/36916690/36912597
/u01/soft/36916690/36917416
/u01/soft/36916690/36917397
/u01/soft/36916690/36940756
/u01/soft/36916690/36758186
/u01/app/grid/19.3.0/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
DB_HOME
cat /tmp/patch_list_dbhome.txt
/u01/soft/36916690/36912597
/u01/soft/36916690/36917416
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
export PATH=$PATH:/u01/app/grid/19.3.0/OPatch
cd /u01/soft
To patch the Grid home and all Oracle RAC database homes of the same version:
opatchauto apply /u01/soft/36916690
Verify the patches on Homes
/u01/app/grid/19.3.0/OPatch/opatch lsinventory|grep "Patch description"
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinventory|grep "Patch description"
Non-CDB or Non-PDB Database
sqlplus /nolog
SQL> Connect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -sanity_checks (optional)
./datapatch -verbose
--From 12c onwards
col action_time for a28
col action for a8
col version for a8
col comments for a30
col status for a10
set line 999 pages 999
select patch_id,  version, status, Action,Action_time from dba_registry_sqlpatch order by action_time;

2.1.8.3 Upgrade Oracle Recovery Manager Catalog
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;
RMAN> UPGRADE CATALOG;
RMAN> EXIT;

crsctl Root user  ...cluser level commands
srvctl oracle user  db manages and otehr services 

Comments

Post a Comment

Popular posts from this blog

MY NOTEPAD

-
set lines 200 pages 200; col END_TIME for a20; col ELAPSED_TIME for a25; col START_TIME for a20 SELECT T.SESSION_KEY, T.INPUT_TYPE, T.STATUS, T.SUM_BACKUP_PIECES_IN_GB, T.START_TIME, T.END_TIME, T.SECONDS ELAPSED_TIME FROM ( SELECT SESSION_KEY, INPUT_TYPE, STATUS, OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_IN_GB, TO_CHAR (START_TIME, 'dd/mm/yyyy hh24:mi') START_TIME, TO_CHAR (END_TIME, 'dd/mm/yyyy hh24:mi') END_TIME, TIME_TAKEN_DISPLAY SECONDS FROM V$RMAN_BACKUP_JOB_DETAILS WHERE INPUT_TYPE='ARCHIVELOG' ORDER BY SESSION_KEY DESC) T WHERE ROWNUM <= 1; ================ ASM disk group free space ============== set sqlblanklines on set lines 180 set pages 999le col "Group Name" form a25 col "Disk Name" form a30 col "State" form a15 ...
Read more

Oracle OEM Holistic Patch

-
  Oracle OEM Holistic Patch  The Concept Starting with Oracle Enterprise Manager (OEM) 13.5 RU24 (October 2024), Oracle introduced the Holistic Patch for OEM — a unified patching model that consolidates several separate updates into a single coordinated package. Previously, administrators had to patch: * The OMS and Agents with the quarterly Release Update (RU). * OEM Application via the System Patch Bundle (SPB). * WebLogic CPU and JDK manually. There was an element of complication because of the need to keep the solution homogeneous. With the Holistic Patch, the last two steps are merged into a single patch bundle. Now we have a new Holistic patch for OEM that is released with each new OMS Release Update. Prerequisites Apply RU 24 Patch  PATCH 36761595  /later on all OMSes before applying Oct Holistic Patch   PATCH 37305292             (OR) Apply RU 25 Patch  PATCH 37057635  /later on all OMSes before applying ...
Read more

Upgrade Oracle 19c DB to 21c using Auto Upgrade utility inprogress

-
Image
  Upgrade Oracle 11g to 21c using AutoUpgrade utility: How do I upgrade Oracle database to 21c?  install the 21c oracle binaries into the server . Oracle Virtual Bix  Oracle Linux 7 Oracle Database 19c currently running Upgrading 19c database to 21c directly Oracle Database 19c on premises is available – and one of the key features is the new Auto Upgrade utility. In the following days I will publish several blog posts explaining and showcasing the new Auto Upgrade. What is the Auto Upgrade? The Oracle Database Auto Upgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. The new Auto Upgrade utility in Oracle 19che idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong – and then upgrade your databases. And of course, do the post upgrade, recompilation and time zone adjustment. The...
Read more