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 )