Atualização do Oracle Java Virtual Machine (OJVM) e Atualização da versão do Grid Infrastructure e Database de 19.3 para 19.25

O Patch 36866740 esta distribuido da seguinte forma:

Patch 36866740:
├── Combo_of_OJVM_Component_Release_Update_19.25.0.0.241015
│   ├── 36866740
│   └── 36878697
└── Grid_Infrastructure_Oct_2024_Release_Update_19.25.0.0.241015
    ├── 36866740
    ├── 36916690
    ├── 36758186
    ├── 36912597
    ├── 36917397
    ├── 36917416
    └── 36940756

• Para validar no SO se os discos foram criados basta iniciar a VM e ao logar-se, dar o comando lsblk

cluvfy stage -pre patch

	Verifying cluster upgrade state ...PASSED
	Verifying Software home: /u01/app/19.3.0.0/grid ...PASSED

	Pre-check for Patch Application was successful.

	CVU operation performed:      stage -pre patch
	Date:                         Jan 3, 2025 4:18:51 PM
	CVU home:                     /u01/app/19.3.0.0/grid/
	User:                         grid

srvctl config database -verbose
	ORCL    /u01/app/oracle/product/19.3.0/dbhome_1 19.0.0.0.0

crsctl query crs softwareversion -all
	Oracle Clusterware version on node [node1] is [19.0.0.0.0]
	Oracle Clusterware version on node [node2] is [19.0.0.0.0]

cat /etc/redhat-release
	Red Hat Enterprise Linux Server release 7.9 (Maipo)

uname -sr
	Linux 4.1.12-124.92.3.el7uek.x86_64

$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME
	...
	
/u01/app/19.3.0.0/grid/OPatch/opatch version
	OPatch Version: 12.2.0.1.17 
	OPatch succeeded. 	
	
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version
	OPatch Version: 12.2.0.1.17 
	OPatch succeeded. 	

LINKS:

• OPATCH TOOL
• CRITICAL PATCH UPDATES

cd /software ; ll
	-rw-r--r--. 1 root root  p6880880_190000_Linux-x86-64.zip
	-rw-r--r--. 1 root root  p36866740_190000_Linux-x86-64.zip

• Renomei o pasta OPatch

mv -v /u01/app/19.3.0.0/grid/OPatch  /u01/app/19.3.0.0/grid/OPatch_old
mv -v /u01/app/oracle/product/19.3.0/dbhome_1/OPatch /u01/app/oracle/product/19.3.0/dbhome_1/OPatch_old

• Verifique a integridade do arquivo

unzip -t p6880880_190000_Linux-x86-64.zip 

• Descompactação do OPatch

unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/19.3.0.0/grid/ 
unzip p6880880_190000_Linux-x86-64.zip -d /u01/app/oracle/product/19.3.0/dbhome_1 

• Alterando as permissões e o owner do OPatch

chown -Rv grid:oinstall   /u01/app/19.3.0.0/grid/OPatch
chown -Rv oracle:oinstall /u01/app/oracle/product/19.3.0/dbhome_1/OPatch
chmod 775 -Rv /u01/app/19.3.0.0/grid/OPatch
chmod 775 -Rv /u01/app/oracle/product/19.3.0/dbhome_1/OPatch

• Verifique a versão do OPatch

/u01/app/19.3.0.0/grid/OPatch/opatch version
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version

	OPatch Version: 12.2.0.1.44
	OPatch succeeded. 

• Verifique a versão do OPatch

/u01/app/19.3.0.0/grid/OPatch/opatch version
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version

	OPatch Version: 12.2.0.1.44
	OPatch succeeded. 

• Verifique a integridade do Patch
• Descompactação do Patch

unzip -t p36866740_190000_Linux-x86-64.zip
unzip p36866740_190000_Linux-x86-64.zip 

• Alterando as permissões e o owner do Patch

chown -Rv grid:oinstall /softwares/36866740  && chmod 775 -Rv  /softwares/36866740   &&  ll 

• Run OPatch Conflict Check - OJVM.

/u01/app/19.3.0.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /softwares/36866740/36878697
#(or)
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /softwares/36866740/36878697

• Run OPatch Conflict Check - GI & DB.

cat patch_list_gihome.txt
/softwares/36866740/36916690/36758186
/softwares/36866740/36916690/36912597
/softwares/36866740/36916690/36917397
/softwares/36866740/36916690/36917416
/softwares/36866740/36916690/36940756

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /softwares/patch_list_gihome.txt

	Invoking prereq "checksystemspace"
	Prereq "checkSystemSpace" passed.

• Run OPatch Conflict Check - GI e DB.

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /softwares/36866740/36916690/36758186
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /softwares/36866740/36916690/36912597
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /softwares/36866740/36916690/36917397
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /softwares/36866740/36916690/36917416
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /softwares/36866740/36916690/36940756

export PATH=$PATH:/u01/app/19.3.0.0/grid/OPatch
cd /softwares/36866740/36916690/
opatchauto apply -analyze
opatchauto apply  	(or) 	opatchauto apply  /softwares/36866740/36916690

cd /softwares/36866740/36878697
opatchauto apply -analyze
opatchauto apply 

[root@node1 36916690]\# opatchauto apply -analyze                                                     
	OPatchauto session is initiated at Fri Jan  3 18:35:01 2025

	System initialization log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025-01-03_06-35-08PM.log.

	Session log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-01-03_06-37-32PM.log
	The id for this session is ZFI5

	Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0.0/grid
	Patch applicability verified successfully on home /u01/app/19.3.0.0/grid

	Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1
	Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1

	Executing patch validation checks on home /u01/app/19.3.0.0/grid
	Patch validation checks successfully completed on home /u01/app/19.3.0.0/grid

	Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1
	Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1

	Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1
	SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1

	OPatchAuto successful.

	--------------------------------Summary--------------------------------

	Analysis for applying patches has completed successfully:

	Host:node1
	CRS Home:/u01/app/19.3.0.0/grid
	Version:19.0.0.0.0

	==Following patches were SUCCESSFULLY analyzed to be applied:

	Patch: /softwares/36866740/36916690/36917416
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-38-02PM_1.log

	Patch: /softwares/36866740/36916690/36917397
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-38-02PM_1.log

	Patch: /softwares/36866740/36916690/36758186
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-38-02PM_1.log

	Patch: /softwares/36866740/36916690/36940756
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-38-02PM_1.log

	Patch: /softwares/36866740/36916690/36912597
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-38-02PM_1.log

	Host:node1
	RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1
	Version:19.0.0.0.0

	==Following patches were SKIPPED:

	Patch: /softwares/36866740/36916690/36917397
	Reason: This patch is not applicable to this specified target type - "rac_database"

	Patch: /softwares/36866740/36916690/36758186
	Reason: This patch is not applicable to this specified target type - "rac_database"

	Patch: /softwares/36866740/36916690/36940756
	Reason: This patch is not applicable to this specified target type - "rac_database"

	==Following patches were SUCCESSFULLY analyzed to be applied:

	Patch: /softwares/36866740/36916690/36917416
	Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-39-33PM_1.log

	Patch: /softwares/36866740/36916690/36912597
	Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-39-33PM_1.log

	OPatchauto session completed at Fri Jan  3 18:41:15 2025
	Time taken to complete the session 6 minutes, 7 seconds
	
	
	
[root@node1 36916690]\# opatchauto apply

	OPatchauto session is initiated at Fri Jan  3 18:41:56 2025

	System initialization log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2025--03_06-42-04PM.log  >>>> "*** Monitore o log ( tail -f ) ***"

	Session log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/opatchauto2025-01-03_06-44-31PM.log
	The id for this session is X3ZG

	Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0.0/grid
	Patch applicability verified successfully on home /u01/app/19.3.0.0/grid

	Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0/dbhome_1
	Patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1

	Executing patch validation checks on home /u01/app/19.3.0.0/grid
	Patch validation checks successfully completed on home /u01/app/19.3.0.0/grid

	Executing patch validation checks on home /u01/app/oracle/product/19.3.0/dbhome_1
	Patch validation checks successfully completed on home /u01/app/oracle/product/19.3.0/dbhome_1

	Verifying SQL patch applicability on home /u01/app/oracle/product/19.3.0/dbhome_1
	SQL patch applicability verified successfully on home /u01/app/oracle/product/19.3.0/dbhome_1

	Preparing to bring down database service on home /u01/app/oracle/product/19.3.0/dbhome_1
	Successfully prepared home /u01/app/oracle/product/19.3.0/dbhome_1 to bring down database service

	Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.3.0.0/grid
	Prepatch operation log file location: /u01/app/grid/crsdata/node1/crsconfig/crs_prepatch_apply_inple_node1_2025-01-03_06-48-26PM.log
	CRS service brought down successfully on home /u01/app/19.3.0.0/grid

	Performing prepatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1
	Prepatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1

	Start applying binary patch on home /u01/app/oracle/product/19.3.0/dbhome_1
	Binary patch applied successfully on home /u01/app/oracle/product/19.3.0/dbhome_1

	Running rootadd_rdbms.sh on home /u01/app/oracle/product/19.3.0/dbhome_1
	Successfully executed rootadd_rdbms.sh on home /u01/app/oracle/product/19.3.0/dbhome_1

	Performing postpatch operation on home /u01/app/oracle/product/19.3.0/dbhome_1
	Postpatch operation completed successfully on home /u01/app/oracle/product/19.3.0/dbhome_1

	Start applying binary patch on home /u01/app/19.3.0.0/grid
	Binary patch applied successfully on home /u01/app/19.3.0.0/grid

	Running rootadd_rdbms.sh on home /u01/app/19.3.0.0/grid
	Successfully executed rootadd_rdbms.sh on home /u01/app/19.3.0.0/grid

	Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.3.0.0/grid
	Postpatch operation log file location: /u01/app/grid/crsdata/node1/crsconfig/crs_postpatch_apply_inace_node1_2025-01-03_07-06-06PM.log
	CRS service started successfully on home /u01/app/19.3.0.0/grid

	Preparing home /u01/app/oracle/product/19.3.0/dbhome_1 after database service restarted
	No step execution required.........

	Trying to apply SQL patch on home /u01/app/oracle/product/19.3.0/dbhome_1
	No SQL patch operations are required on local node for this home

	OPatchAuto successful.

	--------------------------------Summary--------------------------------

	Patching is completed successfully. Please find the summary as follows:

	Host:node1
	RAC Home:/u01/app/oracle/product/19.3.0/dbhome_1
	Version:19.0.0.0.0
	Summary:

	==Following patches were SKIPPED:

	Patch: /softwares/36866740/36916690/36917397
	Reason: This patch is not applicable to this specified target type - "rac_database"

	Patch: /softwares/36866740/36916690/36758186
	Reason: This patch is not applicable to this specified target type - "rac_database"

	Patch: /softwares/36866740/36916690/36940756
	Reason: This patch is not applicable to this specified target type - "rac_database"

	==Following patches were SUCCESSFULLY applied:

	Patch: /softwares/36866740/36916690/36912597
	Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_181-15PM_1.log

	Patch: /softwares/36866740/36916690/36917416
	Log: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_181-15PM_1.log

	Host:node1
	CRS Home:/u01/app/19.3.0.0/grid
	Version:19.0.0.0.0
	Summary:

	==Following patches were SUCCESSFULLY applied:

	Patch: /softwares/36866740/36916690/36758186
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-58-46PM_1.log

	Patch: /softwares/36866740/36916690/36912597
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-58-46PM_1.log

	Patch: /softwares/36866740/36916690/36917397
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-58-46PM_1.log

	Patch: /softwares/36866740/36916690/36917416
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-58-46PM_1.log

	Patch: /softwares/36866740/36916690/36940756
	Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2025-01-03_18-58-46PM_1.log

	OPatchauto session completed at Fri Jan  3 19:14:06 2025
	Time taken to complete the session 32 minutes, 3 seconds

• Executar o PATCH no NODE2

export PATH=$PATH:/u01/app/19.3.0.0/grid/OPatch
cd /softwares/36866740/36916690/
opatchauto apply -analyze
opatchauto apply  	(or) 	opatchauto apply  /softwares/36866740/36916690  

cd /softwares/36866740/36878697
opatchauto apply -analyze
opatchauto apply   

• Para validar execute os comandos:

sqlplus / as sysdba
 
SQL> SELECT description,ACTION,STATUS,TARGET_BUILD_TIMESTAMP from DBA_REGISTRY_SQLPATCH;

                                             DESCRIPTION    ACTION        STATUS             TARGET_BUILD_TIMESTAMP
________________________________________________________ _________ _____________ __________________________________
Database Release Update : 19.3.0.0.190416 (29517242)     APPLY     SUCCESS       10-APR-19 12.27.20.000000000 PM
Database Release Update : 19.25.0.0.241015 (36912597)    APPLY     SUCCESS	     10-OCT-24 06.42.53.000000000 PM


SELECT TO_CHAR(ACTION_TIME,'DD-MON-YYYY HH24:MI:SS') AS ACTION_TIME,ACTION,VERSION,ID,COMMENTS,BUNDLE_SERIES FROM SYS.REGISTRY$HISTORY ORDER BY ACTION_TIME;

            ACTION_TIME       ACTION       VERSION    ID                                                      COMMENTS    BUNDLE_SERIES
_______________________ ____________ _____________ _____ _____________________________________________________________ ________________
02-JAN-2025 18:20:53    RU_APPLY     19.0.0.0.0          Patch applied on 19.3.0.0.0: Release_Update - 190410122720
                        BOOTSTRAP    19                  RDBMS_19.25.0.0.0DBRU_LINUX.X64_241010



SELECT BANNER FROM V$VERSION;

BANNER
_________________________________________________________________________
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

crsctl query crs releasepatch
Oracle Clusterware release patch level is [4193353356] and the complete list of patches [36758186 36878697 36912597 36917397 36917416 36940756 ] have been applied on the local node. 
The release patch string is [19.25.0.0.0]. 

crsctl query crs releasepatch
Oracle Clusterware release patch level is [4193353356] and the complete list of patches [36758186 36878697 36912597 36917397 36917416 36940756 ] have been applied on the local node.
The release patch string is [19.25.0.0.0]. 

 cluvfy stage -post patch

	Performing following verification checks ...
	  cluster upgrade state ...
	  Oracle Clusterware active patch level is "724960844".

	  Node Name     Software Patch Level(OCR)  Software Patch Level(OLR)  Release Patch Level
	  ------------  ------------------------  ------------------------  ----------
	  node1         4193353356                4193353356                4193353356
	  node2         4193353356                4193353356                4193353356
	
	CVU operation performed:      stage -post patch
	Date:                         Jan 5, 2025 3:28:17 PM
	CVU version:                  19.25.0.0.0 (100824x8664)
	Clusterware version:          19.0.0.0.0
	CVU home:                     /u01/app/19.3.0.0/grid
	Grid home:                    /u01/app/19.3.0.0/grid
	User:                         grid
	Operating system:             Linux4.1.12-124.92.3.el7uek.x86_64