top of page
Search
  • Writer's pictureSudipta Bhaskar

Patch 35037840 - GI Release Update 19.19.0.0.230418 fails with ORA-00845:MEMORY_TARGET not supported

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/35037840


It 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 online


oracle@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' failed




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/0

Tried 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 pmon

After 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 seconds

Thanks.

48 views0 comments

Recent Posts

See All

Comments


Post: Blog2_Post
bottom of page