Oracle Database 19C Nisan 2021 CPU Geçerken Alınan Hatalar ve Çözümleri
Oracle GoldenGate 19c Microservice Architecture Patching
2 Mayıs 2021
Oracle GoldenGate 19c Microservice Architecture XAG ile Oracle RAC konfigürasyonu (silent)
11 Mayıs 2021
Merhaba, 19c Grid ve RDBMS olan ortamımızda yeni çıkan Nisan 2021 Critical Patch Update (CPU) geçerken 2 farklı hata ile karşılaştık. Geçtiğimiz patch numarası : GI Release Update 19.11.0.0.210420 Patch 32545008.
Exadata üzerinde patch geçerken 1. node’a sorunsuz olarak patch geçildi ancak diğer node’ların tamamında aşağıdaki hatalar ile karşılaşıldı. Bu hataların workaround’unu aşağıda bulabilirsiniz.
Hata 1 – java.io.FileNotFoundException: /u01/app/oraInventory/ContentsXML/oui-patch.xml (Permission denied)
opatchauto ile patch geçerken aşağıdaki gibi permission denied hatası alındı.
[root@exa1db02 patches]# opatchauto apply /u01/patches/32545008
OPatchauto session is initiated at Thu Apr 29 10:14:06 2021
System initialization log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-04-29_10-14-08AM.log.
Session log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/opatchauto2021-04-29_10-15-08AM.log
The id for this session is 1BYB
Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.0.0.0/grid
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Patch applicability verified successfully on home /u01/app/19.0.0.0/grid
Executing patch validation checks on home /u01/app/19.0.0.0/grid
Patch validation checks successfully completed on home /u01/app/19.0.0.0/grid
Executing patch validation checks on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Patch validation checks successfully completed on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Verifying SQL patch applicability on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Skipping SQL patch step execution on standby database : dr2test
SQL patch applicability verified successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Preparing to bring down database service on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Successfully prepared home /u01/app/oracle/product/19.0.0.0/dbhome_1 to bring down database service
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/19.0.0.0/grid
Prepatch operation log file location: /u01/app/grid/crsdata/exa1db02/crsconfig/crs_prepatch_apply_inplace_exa1db02_2021-04-29_10-16-13AM.log
CRS service brought down successfully on home /u01/app/19.0.0.0/grid
Performing prepatch operation on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Perpatch operation completed successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Start applying binary patch on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Binary patch applied successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Performing postpatch operation on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Start applying binary patch on home /u01/app/19.0.0.0/grid
Failed while applying binary patches on home /u01/app/19.0.0.0/grid
Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : exa1db02->/u01/app/19.0.0.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/19.0.0.0/grid, host: exa1db02.
Command failed: /u01/app/19.0.0.0/grid/OPatch/opatchauto apply /u01/patches/32545008 -oh /u01/app/19.0.0.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.0.0.0/grid/oraInst.loc -jre /u01/app/19.0.0.0/grid/OPatch/jre -persistresult /u01/app/19.0.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_exa1db02_crs_16.ser -analyzedresult /u01/app/19.0.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_exa1db02_crs_16.ser
Command failure output:
==Following patches FAILED in apply:
Patch: /u01/patches/32545008/32545013
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-22-43AM_1.log
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.io.FileNotFoundException: /u01/app/oraInventory/ContentsXML/oui-patch.xml (Permission denied)'
After fixing the cause of failure Run opatchauto resume
]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.
OPatchauto session completed at Thu Apr 29 10:25:57 2021
Time taken to complete the session 11 minutes, 51 seconds
opatchauto failed with error code 42Çözüm 1 – chmod 600
Çözüm için ilgili xml’in yetkileri değiştirildi ve opatchauto resume ile patch’e devam edildi.
[root@exa1db02 ~]# ls -l /u01/app/oraInventory/ContentsXML/oui-patch.xml
-rw-r--r-- 1 grid oinstall 174 Apr 26 11:15 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@exa1db02 ~]# chmod 660 /u01/app/oraInventory/ContentsXML/oui-patch.xml
[root@exa1db02 ~]# ls -l /u01/app/oraInventory/ContentsXML/oui-patch.xml
-rw-rw---- 1 grid oinstall 174 Apr 26 11:15 /u01/app/oraInventory/ContentsXML/oui-patch.xml
Hata 2 – ORACLE_HOME/inventory/oneoffs/32545013 is corrupted
Yukarıdaki hata çözüldükten sonra opatchauto resume ile patch’e devam edildiğinde aşağıdaki gibi hata alındı.
[root@exa1db02 patches]# opatchauto resume
OPatchauto session is initiated at Thu Apr 29 10:29:10 2021
Session log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/opatchauto2021-04-29_10-29-10AM.log
Resuming existing session with id 1BYB
Start applying binary patch on home /u01/app/19.0.0.0/grid
Failed while applying binary patches on home /u01/app/19.0.0.0/grid
Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures:
Patch Target : exa1db02->/u01/app/19.0.0.0/grid Type[crs]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u01/app/19.0.0.0/grid, host: exa1db02.
Command failed: /u01/app/19.0.0.0/grid/OPatch/opatchauto apply /u01/patches/32545008 -oh /u01/app/19.0.0.0/grid -target_type cluster -binary -invPtrLoc /u01/app/19.0.0.0/grid/oraInst.loc -jre /u01/app/19.0.0.0/grid/OPatch/jre -persistresult /u01/app/19.0.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_exa1db02_crs_16.ser -analyzedresult /u01/app/19.0.0.0/grid/opatchautocfg/db/sessioninfo/sessionresult_analyze_exa1db02_crs_16.ser
Command failure output:
==Following patches FAILED in apply:
Patch: /u01/patches/32545008/32545013
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-29-37AM_1.log
Reason: Failed during Analysis: CheckNApplyReport Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/32545013 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0.0/grid/inventory/oneoffs/32545013/etc/config/actions" or "/u01/app/19.0.0.0/grid/inventory/oneoffs/32545013/etc/config/inventory" does not exist.
]
After fixing the cause of failure Run opatchauto resume
]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.
OPatchauto session completed at Thu Apr 29 10:29:43 2021
Time taken to complete the session 0 minute, 34 seconds
opatchauto failed with error code 42Çözüm 2 – scp
node1’de patch sorunsuz geçildiği için node1’den bu node’a ilgili klasörler taşındı. Muhtemelen patch dizini içerisinden de taşınabilirdi.
[root@exa1db01 oneoffs]# ll
total 20
drwxr-x--- 4 oracle oinstall 4096 Apr 18 2019 29517242
drwxr-x--- 4 oracle oinstall 4096 Apr 18 2019 29585399
drwxr-x--- 4 oracle oinstall 4096 Mar 15 17:34 32218454
drwxr-xr-x 4 oracle oinstall 4096 Apr 26 12:19 32545013
drwxr-xr-x 4 oracle oinstall 4096 Apr 26 12:21 32579761
[root@exa1db01 oneoffs]# scp -r 32545013/ exa1db02:/u01/app/oracle/product/19.0.0.0/dbhome_1/inventory/oneoffs/
inventory.xml 100% 552KB 94.0MB/s 00:00
actions.xml 100% 5502KB 111.7MB/s 00:00
[root@exa1db01 oneoffs]# scp -r 32579761/ exa1db02:/u01/app/oracle/product/19.0.0.0/dbhome_1/inventory/oneoffs/
inventory.xml 100% 124KB 77.0MB/s 00:00
actions.xml Daha sonra tekrar opatchauto resume ile patch’e devam edildi ve başarılı tamamlandı.
[root@exa1db02 patches]# opatchauto resume
OPatchauto session is initiated at Thu Apr 29 10:32:56 2021
Session log file is /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/opatchauto2021-04-29_10-32-57AM.log
Resuming existing session with id 1BYB
Start applying binary patch on home /u01/app/19.0.0.0/grid
Binary patch applied successfully on home /u01/app/19.0.0.0/grid
Checking shared status of home.....
Performing postpatch operations on CRS - starting CRS service on home /u01/app/19.0.0.0/grid
Postpatch operation log file location: /u01/app/grid/crsdata/exa1db02/crsconfig/crs_postpatch_apply_inplace_exa1db02_2021-04-29_10-40-28AM.log
CRS service started successfully on home /u01/app/19.0.0.0/grid
Preparing home /u01/app/oracle/product/19.0.0.0/dbhome_1 after database service restarted
No step execution required.........
Trying to apply SQL patch on home /u01/app/oracle/product/19.0.0.0/dbhome_1
Skipping SQL patch step execution on standby database : dr2test
SQL patch applied successfully on home /u01/app/oracle/product/19.0.0.0/dbhome_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:exa1db02
RAC Home:/u01/app/oracle/product/19.0.0.0/dbhome_1
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /u01/patches/32545008/32576499
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/patches/32545008/32585572
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /u01/patches/32545008/32584670
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/patches/32545008/32545013
Log: /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-17-27AM_1.log
Patch: /u01/patches/32545008/32579761
Log: /u01/app/oracle/product/19.0.0.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-17-27AM_1.log
Host:exa1db02
CRS Home:/u01/app/19.0.0.0/grid
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /u01/patches/32545008/32545013
Reason: This patch is not applicable to this specified target type - "cluster"
==Following patches were SUCCESSFULLY applied:
Patch: /u01/patches/32545008/32576499
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-33-24AM_1.log
Patch: /u01/patches/32545008/32579761
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-33-24AM_1.log
Patch: /u01/patches/32545008/32584670
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-33-24AM_1.log
Patch: /u01/patches/32545008/32585572
Log: /u01/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-29_10-33-24AM_1.log
Following homes are skipped during patching as patches are not applicable:
/u01/app/oracle/product/12.2.0.1/dbhome_1
OPatchauto session completed at Thu Apr 29 10:46:33 2021
Time taken to complete the session 13 minutes, 37 secondsOracle Database hakkında yaşadığınız tüm sorunlar için Forenda’dan destek alabilirsiniz. Umarım faydalı olmuştur.
Kaynak:
opatchauto apply Results java.io.FileNotFoundException: <oraInventory>/ContentsXML/oui-patch.xml (Permission denied) Error in Non-OUI Nodes (Doc ID 2582139.1)
Erman İbrişim
Erman İbrişim, Co-Founder & Principal Database Consultant olarak Forenda Bilişim Teknolojileri'nde kariyerine devam etmektedir. Ayrıca forenda.com.tr sitesi üzerinden veri tabanı, Oracle, CouchBase konularında konularında teknik bilgiler paylaşmaktadır.
