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
Install a fix for this issue. This issue is/will be fixed in the following versions:
Oracle release: 12.1.
Oracle patchset; 220.127.116.11 [Patch:10404530] Oracle one-off patches: Please search MOS by selecting patch number 7365514 and your platform.
502 views last month, 1 views today