ORA-24550: unhandled signal received

I got ” ORA-24550: unhandled signal received ”  error in Oracle database.

 

ORA-24550: unhandled signal received

 

Details of error are as follows.

ORA-24550: unhandled signal #number received. string

Cause: Serious error: signal received

Action: Refer to the platform-specific signal code, and see if the application code caused 
the error. Otherwise, record all error state and notify Oracle Support Services."

 

 

unhandled signal received

This ORA-24550 errors are related with the Oracle 11g ( bug 7308054 )

Refer to the platform-specific signal code, and see if the application code caused the error. Otherwise, record all error state and notify Oracle Support Services.”

Try to set DIAG_SIGHANDLER_ENABLED=FALSE in sqlnet.ora file and restart the listener.

Or apply Oracle patch 8670579 to solve this error.

 

Other case is as follows.

The issue is caused by a memory corruption in an Oracle library. This is addressed in:

Bug 9161173 – PRO*C/C++ APPLICATION DUMPED CORE IN SQLCLN

which is closed as a duplicate of:

Bug 7365514 – EXISTING PRO*C APPLICATION OVERWRITES MEMORY AFTER UPGRADE TO 11G.

 

To solve this case, Try the workaround of precompiling with the Precompiler Option HOLD_CURSOR=YES

or

Install a fix for this issue. This issue is/will be fixed in the following versions:
Oracle release: 12.1.
Oracle patchset; 11.2.0.3 [Patch:10404530] Oracle one-off patches: Please search MOS by selecting patch number 7365514 and your platform.

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 224 views last month,  1 views today

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