Solution of ORA-24550 Signal Received error

Oracle RAC Architecture.

A variety of online sayings.

ORA-24550 Signal Received Error from Client Based application [ID 1284564.1]
Modify Time 01-jul-2011 type PROBLEM State moderated

In this Document
Symptoms
Changes
Cause
Solution
References

This document was being delivered to you via Oracle Support ' s Rapid Visibility (RaV) process and therefore has not been sub Ject to a independent technical review.

Applies To:
Oracle server-enterprise edition-version:11.2.0.1 and later [release:11.2 and later]
Information in this document applies to any platform.
OCI, OCCI, precompiler based applications such as Pro*c, Pro*cobol.
Symptoms
When trying to execute C, at Server-oracle 11g 11.2.0.1 on IBM AIX-bit, 6.1, the following error message is RE ceived.

Application connects to Server with Oracle 11g 11.2.0.1:

Ora-24550:signal received: [si_signo=11] [si_errno=0] [si_code=50] [SI_ADR = 2020202020202020] Killed

Depending on the operating System the stack would differ. for example;

Linux x86-64 would is something like;

/lib64/libpthread.so.0[0X3412A0673D]/lib64/libc.so.6 (CLONE+0X6D) [0X3411ED44BD] Ora-24550:signal received: [si_signo=6] [si_errno=0] [si_ CODE=-6] [si_int=0] [si_ptr=0x200000000] [si_addr=0x1f400001c43] Kpedbg_dmp_stack () +314<-kpedbgcrash () +166<- Kpedbgsignalhandler () +158<-skgesig_sigactionhandler () +217<-__restore_rt () <-gsignal () +53<- 000000000de723a0<-000000000de723a0<

Changes
Upgraded Database from Oracle 10g 10.2.0.1 to Oracle 11g 11.2.0.1
Cause
Diagnosability features which are turned on ' by default ' Oracle 11g Release 2 causes the problem.

Parameters are:

Diag_adr_enabled
Diag_sighandler_enabled
Diag_dde_enabled
Solution
1. Such errors can occur if the "diagnosability" features are ' on '.

To turn off the OCI signal handler and re-enable standard operating System failure processing, place the following Paramet Er setting in Sqlnet.ora:

Diag_sighandler_enabled=false

By default this parameter is set to True.

If you are want to, the old behavior can simply turn off the feature by placing the following parameter of setting in your Client side Sqlnet.ora file under $ORACLE _home/network/admin directory.

2. In addition, please turn off of the other diagnostics parameters as a, placing the following entries in the client side O R server Sqlnet.ora file. i.e., from where the application is run.

Diag_adr_enabled=off
Diag_sighandler_enabled=false
Diag_dde_enabled=false

References
Bug:9342118-ocistmtrelease crashes with CORE DUMP when called OUTSIDE A TRANSACTION
note:1062759.1-ora-24550 and CRASH in Ocistmtrelease on client upgrade to ORACLE 11.2

Display related information related to
Products

Oracle Database Products > Oracle database > Oracle Database > Oracle server-enterprise Edition

Key words
diagnostics; HANDLER; OCCI; OCI; Sqlnet. ORA
Error
ORA-24550

Finally, it seems that the Libpthread.so library file for the RAC client is broken. Do not know how bad, changed a new (or comment out the class library, forget:) on the good. Database connection method has OCI link RAC, modified to thin way