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

If you get ” LMHB (ospid: XXXX): terminating the instance due to error 29770 ” error, probably your instance is restarted automatically and I have seen this error on Exadata X7-2 Full Rack.
This Issue is due to Bug 22806698 : GCW1AP CRASH – ORA-29770 LMHB TERMINATES INSTANCE

 

_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

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *