Patch 37257886 - GI Release Update 19.26.0.0.250121

-

 1, Take the backup of database

2, Take the backup of Grid_Home and DB_HOME.

3, Take the backup of Lsinventory 

4,UPdate the Opatch to the latest version for grid_home and db_home

5,Check for onvalid objects make them valid if any 

6,Disable the monitoring for patching servers .

7,Verify the services and relocate services if any .

8,stop the MRP on the standby servers

9,Apply the patch on Grid_Home and DB_HOME


Patch 37257886 - GI Release Update 19.26.0.0.250121


Patch Number Applicable Homes

37260974 Only Oracle home for non-Oracle RAC setup. Both Oracle home and Grid home for Oracle RAC setup.

37268031 Both Oracle home and Grid home.

37266638     Only Grid home

37461387 Only Grid home.

36758186 Only Grid home


You must use the OPatch utility version 12.2.0.1.44

[oracle@dalprim02 soft]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version

OPatch Version: 12.2.0.1.45



[oracle@dalprim02 ~]$ /u01/app/19.3.0/grid/OPatch/opatch version

OPatch Version: 12.2.0.1.17




/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/19.3.0/dbhome_1

/u01/app/19.3.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/19.3.0/grid



/u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/37257886/37260974

/u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/37257886/37268031

/u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/37257886/37266638

/u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/37257886/37461387

/u01/app/19.3.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/37257886/36758186



 /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/37257886/37260974

 /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/soft/37257886/37268031

 

 

 

 vi /tmp/patch_list_gihome.txt

 

/u01/soft/37257886/37260974

/u01/soft/37257886/37268031

/u01/soft/37257886/37266638

/u01/soft/37257886/37461387

/u01/soft/37257886/36758186


/u01/app/19.3.0/grid/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt



/u01/soft/37257886/37260974

/u01/soft/37257886/37268031


/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt



# export PATH=$PATH:/u01/app/19.3.0/grid/OPatch

# cd /u01/soft

opatchauto apply /u01/soft/37257886



[root@dalprim01 ~]# export PATH=$PATH:/u01/app/19.3.0/grid/OPatch

[root@dalprim01 ~]# cd /u01/soft

[root@dalprim01 soft]# ll

total 3687064

drwxrwxrwx 8 oracle oinstall       4096 Jan 20 14:03 37257886

-rwxrwxrwx 1 oracle oinstall  128599045 Mar 17 02:55 p37213431_190000_Linux-x86-64.zip

-rwxrwxrwx 1 oracle oinstall 3512303969 Mar 17 02:56 p37257886_190000_Linux-x86-64.zip

-rwxrwxrwx 1 oracle oinstall  131979857 Mar 17 02:56 p6880880_122010_Linux-x86-64.zip

-rwxrwxrwx 1 oracle oinstall    2654673 Jan 21 21:28 PatchSearch.xml

[root@dalprim01 soft]# opatchauto apply /u01/soft/37257886


OPatchauto session is initiated at Tue Mar 25 23:26:49 2025


System initialization log file is /u01/app/19.3.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-03-25_11-26-53PM.log.







 

 

 

 

 

 

 

 

 



export PATH=$PATH:/u01/app/21.3.0/grid/OPatch

cd /u01/soft/37349593

opatchauto apply /u01/soft/37349593/opatch lsinventory -oh /



while :

do

#date

echo -e "\n"

sleep 120

done &


OEMPRD1:/u01/app/oracle/product/21.3.0/dbhome_1:N

+ASM1:/u01/app/21.3.0/grid:N


drwxr-x--- 4 oracle oinstall     48 Jan 13 08:27 37210835

drwxr-x--- 5 oracle oinstall     81 Jan 13 08:27 37350281

drwxr-x--- 5 oracle oinstall     62 Jan 13 08:26 37355839

drwxr-x--- 4 oracle oinstall     48 Jan 13 08:27 37356537

drwxr-x--- 5 oracle oinstall     62 Jan 13 08:26 37402165

drwxr-x--- 4 oracle oinstall     48 Jan 13 08:27 37465665



/u01/app/21.3.0/grid/OPatch/opatch lsinventory -oh /u01/app/21.3.0/grid|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort


Patch  37210835     : applied on Fri Feb 21 20:27:02 IST 2025

Patch  37350281     : applied on Fri Feb 21 20:31:09 IST 2025

Patch  37355839     : applied on Fri Feb 21 20:33:10 IST 2025

Patch  37356537     : applied on Fri Feb 21 20:33:28 IST 2025

Patch  37402165     : applied on Fri Feb 21 20:33:44 IST 2025

Patch  37465665     : applied on Fri Feb 21 20:33:58 IST 2025

Patch description:  "ACFS RELEASE UPDATE 21.17.0.0.0 (37402165)"

Patch description:  "Database Release Update : 21.17.0.0.250121 (37350281)"

Patch description:  "DBWLM RELEASE UPDATE 21.0.0.0.0 (37210835)"

Patch description:  "OCW RELEASE UPDATE 21.17.0.0.0 (37355839)"

Patch description:  "RHP RELEASE UPDATE 21.17.0.0.0 (37356537)"

Patch description:  "TOMCAT RELEASE UPDATE 21.0.0.0.0 (37465665)"

[oracle@21crac01 37349593]$




/u01/app/oracle/product/21.3.0/dbhome_1/OPatch/opatch lsinventory -oh /u01/app/oracle/product/21.3.0/dbhome_1|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort



OEMPRD2:/u01/app/oracle/product/21.3.0/dbhome_1:N

catdb2:/u01/app/oracle/product/21.3.0/dbhome_1:N

PRACPLM2:/u01/app/oracle/product/21.3.0/dbhome_1:N



./xagsetup.sh --install --directory /u01/app/grid/xag --all_nodes



 ./appvipcfg create -network=1 -ip=192.168.56.135 -vipname=ogg_vip -user=root

 

 srvctl add service -db PRACPLM -service ogg_PRACPLM -role PRIMARY -preferred PRACPLM1,PRACPLM2



OPatch version    : 12.2.0.1.45

Oracle Interim Patch Installer version 12.2.0.1.45

Patch  37350281     : applied on Fri Feb 21 20:22:48 IST 2025

Patch  37355839     : applied on Fri Feb 21 20:23:36 IST 2025

Patch description:  "Database Release Update : 21.17.0.0.250121 (37350281)"

Patch description:  "OCW RELEASE UPDATE 21.17.0.0.0 (37355839)"

[oracle@21crac01 ~]$



/u01/app/21.3.0/grid/OPatch/opatch lsinventory -oh / 



[oracle@21crac02 ~]$ /u01/app/21.3.0/grid/OPatch/opatch lsinventory -oh /u01/app/21.3.0/grid|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort

Interim patches (6) :

Log file location : /u01/app/21.3.0/grid/cfgtoollogs/opatch/opatch2025-02-21_21-34-28PM_1.log

Lsinventory Output file location : /u01/app/21.3.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2025-02-21_21-34-28PM.txt

OPatch succeeded.

OPatch version    : 12.2.0.1.45

Oracle Interim Patch Installer version 12.2.0.1.45

Patch  37210835     : applied on Fri Feb 21 21:04:43 IST 2025

Patch  37350281     : applied on Fri Feb 21 21:06:06 IST 2025

Patch  37355839     : applied on Fri Feb 21 21:06:47 IST 2025

Patch  37356537     : applied on Fri Feb 21 21:06:58 IST 2025

Patch  37402165     : applied on Fri Feb 21 21:07:08 IST 2025

Patch  37465665     : applied on Fri Feb 21 21:07:18 IST 2025

Patch description:  "ACFS RELEASE UPDATE 21.17.0.0.0 (37402165)"

Patch description:  "Database Release Update : 21.17.0.0.250121 (37350281)"

Patch description:  "DBWLM RELEASE UPDATE 21.0.0.0.0 (37210835)"

Patch description:  "OCW RELEASE UPDATE 21.17.0.0.0 (37355839)"

Patch description:  "RHP RELEASE UPDATE 21.17.0.0.0 (37356537)"

Patch description:  "TOMCAT RELEASE UPDATE 21.0.0.0.0 (37465665)"

[oracle@21crac02 ~]$ /u01/app/oracle/product/21.3.0/dbhome_1/OPatch/opatch lsinventory -oh /u01/app/oracle/product/21.3.0/dbhome_1|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort

Interim patches (2) :

Log file location : /u01/app/oracle/product/21.3.0/dbhome_1/cfgtoollogs/opatch/opatch2025-02-21_21-34-42PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/21.3.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2025-02-21_21-34-42PM.txt

OPatch succeeded.

OPatch version    : 12.2.0.1.45

Oracle Interim Patch Installer version 12.2.0.1.45

Patch  37350281     : applied on Fri Feb 21 21:02:43 IST 2025

Patch  37355839     : applied on Fri Feb 21 21:03:26 IST 2025

Patch description:  "Database Release Update : 21.17.0.0.250121 (37350281)"

Patch description:  "OCW RELEASE UPDATE 21.17.0.0.0 (37355839)"

[oracle@21crac02 ~]$






oracle@19crac01 bin]$ /u01/app/19.3.0/grid/OPatch/opatch lsinventory | grep -i Applied

Patch  37213431     : applied on Sun Jan 26 20:05:20 IST 2025

Patch  37461387     : applied on Sun Jan 26 16:12:07 IST 2025

Patch  37268031     : applied on Sun Jan 26 16:11:50 IST 2025

Patch  37266638     : applied on Sun Jan 26 16:11:25 IST 2025

Patch  37260974     : applied on Sun Jan 26 16:10:17 IST 2025

Patch  36758186     : applied on Sun Jan 26 16:09:16 IST 2025

[oracle@19crac01 bin]$

[oracle@19crac01 bin]$

[oracle@19crac01 bin]$

[oracle@19crac01 bin]$

[oracle@19crac01 bin]$

[oracle@19crac01 bin]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinventory | grep -i Applied

Patch  37213431     : applied on Sun Jan 26 20:03:42 IST 2025

Patch  37268031     : applied on Sun Jan 26 16:06:46 IST 2025

Patch  37260974     : applied on Sun Jan 26 16:05:34 IST 2025



[oracle@19crac02 ~]$ /u01/app/19.3.0/grid/OPatch/opatch lsinventory | grep -i Applied

Patch  37213431     : applied on Mon Jan 27 00:31:12 IST 2025

Patch  37461387     : applied on Sun Jan 26 22:57:53 IST 2025

Patch  37268031     : applied on Sun Jan 26 22:57:39 IST 2025

Patch  37266638     : applied on Sun Jan 26 22:57:19 IST 2025

Patch  37260974     : applied on Sun Jan 26 22:56:22 IST 2025

Patch  36758186     : applied on Sun Jan 26 22:55:15 IST 2025

[oracle@19crac02 ~]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinventory | grep -i Applied

Patch  37213431     : applied on Mon Jan 27 00:30:11 IST 2025

Patch  37268031     : applied on Sun Jan 26 22:53:36 IST 2025

Patch  37260974     : applied on Sun Jan 26 22:52:30 IST 2025

[oracle@19crac02 ~]$




/u01/app/19.3.0/grid/OPatch/opatch lsinventory -oh /u01/app/19.3.0/grid|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort


/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lsinventory -oh /u01/app/oracle/product/19.3.0/dbhome_1|grep -i patch|egrep -v "cfgtools|Opatch succeeded|Unique Patch ID|Sub-patch|Patch descripton|This patch"|sort


/u01/app/19.3.0/grid




/u01/app/19.3.0/grid/bin/crsctl query crs releasepatch

/u01/app/19.3.0/grid/bin/crsctl query crs softwarepatch

/u01/app/19.3.0/grid/bin/crsctl query crs releaseversion

/u01/app/19.3.0/grid/bin/crsctl query crs softwareversion

/u01/app/19.3.0/grid/bin/kfod op=patches

/u01/app/19.3.0/grid/bin/kfod op=patchlvl

/u01/app/19.3.0/grid/OPatch/opatch lspatches

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