Patch 35037840 - GI Release Update 19.19.0.0.230418 fails with ORA-00845:MEMORY_TARGET not supported
I was applying GI RU 35037840 in 19c home
/u01/app/oracle/19.3/gridhome/OPatch/opatchauto apply /u02/software/35037840It fails with
Starting database service on home /u02/app/oracle/19.3/dbhome
Failed to start database service on home /u02/app/oracle/19.3/dbhome
Execution of [SIDBStartupAction] patch action failed, check log for more details. Failures:
Patch Target : sbprimary->/u02/app/oracle/19.3/dbhome Type[sidb]
Details: [
---------------------------Patching Failed---------------------------------
Command execution failed during patching in home: /u02/app/oracle/19.3/dbhome, host: sbprimary.
Command failed: /bin/sh -c 'ORACLE_HOME=/u02/app/oracle/19.3/dbhome /u02/app/oracle/19.3/dbhome/bin/srvctl start home -o /u02/app/oracle/19.3/dbhome -s /u02/app/oracle/19.3/dbhome/opatchautocfg/db/sessioninfo/statfile/sbprimary/OracleHome-cd2afa99-58a3-46e6-bd23-677d0e1c8836_sbprimary.stat'
Command failure output:
PRCH-1001 : Failed to start resources in Oracle home /u02/app/oracle/19.3/dbhome
PRCR-1095 : Failed to start resources using filter ((((NAME == ora.dbtest.db) OR (NAME == ora.dbmv.db)) OR (NAME == ora.dbasm.db)) OR (NAME == ora.canalespru.db))
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'sbprimary' failed
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbprimary/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.asm' on 'sbprimary' failed
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'sbprimary' failed
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbprimary/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.asm' on 'sbprimary' failed
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'sbprimary' failed
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbprimary/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.asm' on 'sbprimary' failed
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'sbprimary' failed
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbprimary/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.asm' on 'sbprimary' failed
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.
Tried to do some troubleshooting.
[root@sbprimary ~]# crsctl check has
CRS-4638: Oracle High Availability Services is online
[root@sbprimary ~]#
[root@sbprimary ~]# crsctl stop has -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'sbprimary'
CRS-2673: Attempting to stop 'ora.evmd' on 'sbprimary'
CRS-2677: Stop of 'ora.evmd' on 'sbprimary' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'sbprimary'
CRS-2677: Stop of 'ora.cssd' on 'sbprimary' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'sbprimary' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@sbprimary ~]#
[root@sbprimary ~]# crsctl start has -nowait
CRS-4123: Oracle High Availability Services has been started.
[root@sbprimary ~]# crsctl check has
CRS-4638: Oracle High Availability Services is onlineoracle@sbprimary ~]$ srvctl status ASM
ASM is not running.
[oracle@sbprimary ~]$ srvctl start aSM
PRCR-1079 : Failed to start resource ora.asm
CRS-2674: Start of 'ora.LISTENER.lsnr' on 'sbprimary' failed
CRS-5017: The resource action "ora.asm start" encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/sbprimary/crs/trace/ohasd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.asm' on 'sbprimary' failedFound an Oracle Support document ORA-00845 Raised When Starting Instance (Doc ID 465048.1)
As per the document
Make sure that the /dev/shm size is configured large enough, like in:
# mount -t tmpfs shmfs -o size=7g /dev/shm
In this case, the size of the shared memory device is configured to be 7GB.
In order to make the same change persistent across system reboots, add an entry for this to the /etc/fstab mount table, as in:
shmfs /dev/shm tmpfs size=7g 0 Followed the following steps
[root@sbprimary ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 1.8G 0 1.8G 0% /dev
tmpfs 1.8G 16K 1.8G 1% /dev/shm
tmpfs 1.8G 34M 1.8G 2% /run
tmpfs 1.8G 0 1.8G 0% /sys/fs/cgroup
/dev/mapper/ol-root 34G 9.0G 26G 27% /
/dev/sdd1 50G 14G 37G 27% /u01
/dev/sde1 50G 31G 20G 62% /u02
/dev/sda1 1014M 239M 776M 24% /boot
tmpfs 365M 12K 365M 1% /run/user/42
tmpfs 365M 0 365M 0% /run/user/0
[root@sbprimary ~]#
[root@sbprimary ~]# mount -t tmpfs shmfs -o size=7g /dev/shm
[root@sbprimary ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 1.8G 0 1.8G 0% /dev
shmfs 7.0G 0 7.0G 0% /dev/shm
tmpfs 1.8G 34M 1.8G 2% /run
tmpfs 1.8G 0 1.8G 0% /sys/fs/cgroup
/dev/mapper/ol-root 34G 9.0G 26G 27% /
/dev/sdd1 50G 14G 37G 27% /u01
/dev/sde1 50G 31G 20G 62% /u02
/dev/sda1 1014M 239M 776M 24% /boot
tmpfs 365M 12K 365M 1% /run/user/42
tmpfs 365M 0 365M 0% /run/user/0Tried to start ASM again
[oracle@sbprimary ~]$ srvctl status ASM
ASM is not running.
[oracle@sbprimary ~]$ srvctl start ASM
[oracle@sbprimary ~]$
[oracle@sbprimary ~]$ ps -ef | grep pmon
oracle 3082 1 0 02:22 ? 00:00:00 asm_pmon_+ASM
oracle 3301 1 0 02:22 ? 00:00:00 ora_pmon_DBASM
oracle 3303 1 0 02:22 ? 00:00:00 ora_pmon_CANALESPRU
oracle 3305 1 0 02:22 ? 00:00:00 ora_pmon_DBMV
oracle 3306 1 0 02:22 ? 00:00:00 ora_pmon_DBTEST
oracle 3308 1 0 02:22 ? 00:00:00 ora_pmon_DBST
oracle 5888 2569 0 02:26 pts/1 00:00:00 grep --color=auto pmonAfter resuming the opatchauto, it completed successfully.
[root@sbprimary ~]# /u01/app/oracle/19.3/gridhome/OPatch/opatchauto resume--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:sbprimary
SIDB Home:/u02/app/oracle/19.3/dbhome
Version:19.0.0.0.0
Summary:
==Following patches were SKIPPED:
Patch: /u02/software/35037840/35050325
Reason: This patch is not applicable to this specified target type - "oracle_database"
Patch: /u02/software/35037840/33575402
Reason: This patch is not applicable to this specified target type - "oracle_database"
Patch: /u02/software/35037840/35107512
Reason: This patch is not applicable to this specified target type - "oracle_database"
==Following patches were SUCCESSFULLY applied:
Patch: /u02/software/35037840/35042068
Log: /u02/app/oracle/19.3/dbhome/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-13_01-50-11AM_1.log
Patch: /u02/software/35037840/35050331
Log: /u02/app/oracle/19.3/dbhome/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-13_01-50-11AM_1.log
Host:sbprimary
SIHA Home:/u01/app/oracle/19.3/gridhome
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u02/software/35037840/33575402
Log: /u01/app/oracle/19.3/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-13_01-57-26AM_1.log
Patch: /u02/software/35037840/35042068
Log: /u01/app/oracle/19.3/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-13_01-57-26AM_1.log
Patch: /u02/software/35037840/35050325
Log: /u01/app/oracle/19.3/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-13_01-57-26AM_1.log
Patch: /u02/software/35037840/35050331
Log: /u01/app/oracle/19.3/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-13_01-57-26AM_1.log
Patch: /u02/software/35037840/35107512
Log: /u01/app/oracle/19.3/gridhome/cfgtoollogs/opatchauto/core/opatch/opatch2023-06-13_01-57-26AM_1.log
OPatchauto session completed at Tue Jun 13 02:43:05 2023
Time taken to complete the session 4 minutes, 2 secondsThanks.
Commentaires