LMHB terminating the instance due to ORA error 29770 on Exadata

Hi,

Sometimes You can get ” LMHB terminating the instance due to ORA error 29770 ” error on Exadata

terminating the instance due to ORA error 29770 on Exadata

Details of error are as follows.

LMHB terminating the instance due to ORA error 29770
2020-10-26T10:12:43.874563+03:00
Cause - 'ERROR: Some process(s) is not making progress.
LMHB (ospid: 66583) is terminating the instance.
Please check LMHB trace file for more details.
Please also check the CPU load, I/O load and other system properties for anomalous behavior
ERROR: Some process(s'
2020-10-26T10:12:44.011585+03:00
Dumping diagnostic data in directory=[cdmp_20201026101244], requested by (instance=1, osid=66583 (LMHB)), summary=[abnormal instance termination].
2020-10-26T10:12:44.526700+03:00
ORA-1092 : opitsk aborting process
2020-10-26T10:12:46.744889+03:00
License high water mark = 543
1900-01-00T00:00:00.548934+00:00
Process termination requested for pid 172804 [source = unknown], [info = 233284845] [request issued by pid: 172804, uid: 1001]
2020-10-26T10:12:51.553790+03:00
Instance terminated by LMHB, pid = 66583
2020-10-26T10:12:51.994643+03:00
Warning: 2 processes are still attacheded to shmid 1028128773:
(size: 2097152 bytes, creator pid: 65250, last attach/detach pid: 66484)
2020-10-26T10:12:52.746328+03:00
USER(prelim) (ospid: 93983): terminating the instance
2020-10-26T10:12:52.747475+03:00
Instance terminated by USER(prelim), pid = 93983
2020-10-26T10:12:55.369476+03:00
Starting ORACLE instance (normal) (OS id: 95011)
2020-10-26T10:12:55.394340+03:00
************************************************************
Instance SGA_TARGET = 204800 MB and SGA_MAX_SIZE = 204800 MB
************************************************************

LMHB (ospid: XXXX): terminating the instance due to error 29770

_lm_enable_aff_benefit_stats

To solve this error, you should set the value of the parameter “_lm_enable_aff_benefit_stats” to FALSE in the database.

alter system set “_lm_enable_aff_benefit_stats”=FALSE scope=both sid=’*’;

Or you can apply patch 22806698 for the Bug 22806698 : GCW1AP CRASH – ORA-29770 LMHB TERMINATES INSTANCE

== OR ==

Apply the Bundle Patches where Bug fix included. Please refer following MOS Note:

Bug 22806698 – ORA-29770 due to default value for _lm_enable_aff_benefit_stats (Doc ID 22806698.8)

Do you want to learn more details about RMAN, then read the following articles.

RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA