GEN0 terminating the instance due to ORA error 15082 | ASMB is stuck

I saw ” GEN0 terminating the instance due to ORA error 15082 | ASMB is stuck ” error in Oracle database alertlog during termination of database.

 

GEN0 terminating the instance due to ORA error 15082

 

Details of error are as follows.

ERROR: terminating instance because ASMB is stuck for 241 seconds
2021-04-21T11:07:44.902926+03:00
Process termination requested for pid 128443_128624 [source = rdbms], [info = 0] [request issued by pid: 128223, uid: 1001]
2021-04-21T11:07:44.902944+03:00
Process termination requested for pid 128443_128618 [source = rdbms], [info = 0] [request issued by pid: 128223, uid: 1001]
2021-04-21T11:07:44.947944+03:00
System state dump requested by (instance=3, osid=128223 (GEN0)), summary=[abnormal instance termination]. error - 'Instance is terminating.
'
GEN0 (ospid: 128223): terminating the instance due to ORA error 15082
System State dumped to trace file /u01/app/oracle/diag/rdbms/MSDB/MSDB3/trace/MSDB3_diag_128232.trc
2021-04-21T11:07:44.964277+03:00
Process termination requested for pid 276047 [source = unknown], [info = 233284845] [request issued by pid: 276047, uid: 1001]
2021-04-21T11:07:44.965307+03:00
   

 

 

ERROR: terminating instance because ASMB is stuck for

This ORA error 15082 errors are related with the ASMB process of ASM Instance.

 

The issue may start with one instance which might have some issues and then eventually it leads to database instances getting terminated on the remaining nodes.

 

If the alert.log shows GEN0 not moving for 4 minutes and GEN0 trace shows ASMB waiting in ‘ASM background timer’ while the UFG (user foreground) process shows waiting in ‘DLM enqueue copy completion’ then you are hitting given below bug.

“BUG 27751755 – DB INSTANCES ON MULTIPLE NODES TERMINATED DUE TO ERROR 1508”

 

The fix of Bug:27751755 is included in 12.1.0.2.190416 and higher), 12.2.0.1.190416 (and higher) and version 19.1 (and higher).

To solve this error, you may need to upgrade your database to these versions ( 12.1.0.2.190416 and higher), 12.2.0.1.190416 (and higher) and version 19.1 and higher )

 

Do you want to learn Oracle RMAN, then read the following articles.

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

 

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 

 

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 *