Site icon IT Tutorial

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 )

 

Exit mobile version