Oracle Instance terminated by PMON

Hi,

You can get error in Oracle that instance is terminated by PMON.

When Oracle Instance terminated by PMON, then go to check Alertlog errors. I have checked alertlog, then I saw following errors.

 

TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=41361))
2019-03-27T15:44:35.227680+03:00
Instance Critical Process (pid: 4, ospid: 3321, PSP0) died unexpectedly
PMON (ospid: 3317): terminating the instance due to error 490
2019-03-27T15:44:35.341119+03:00
System state dump requested by (instance=1, osid=3317 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/product/diag/rdbms/devecidb/deveci/trace/deveci_diag_3337_20190327154435.trc
2019-03-27T15:44:37.035726+03:00
Dumping diagnostic data in directory=[cdmp_20190327154435], requested by (instance=1, osid=3317 (PMON)), summary=[abnormal instance termination].
2019-03-27T15:44:38.480887+03:00
Instance terminated by PMON, pid = 3317

 

This error means, there is any problem with Swap partition of Linux. It is not enough space or exist.

To solve this problem, increase swap partition if it exists.

If swap partition does not exist then create it with following link.

 

Mehmet Salih Deveci

I am Founder of 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 mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

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