ORA-24550 Signal Received Error的解决方法

迈不过友情╰ 2022-08-06 08:24 344阅读 0赞

oracle RAC结构。

网上的说法各种。

ORA-24550 Signal Received Error From Client Based Application \[ID 1284564.1\]  
 修改时间 01-JUL-2011 类型 PROBLEM 状态 MODERATED   
  
In this Document  
 Symptoms  
 Changes  
 Cause  
 Solution  
 References  
  
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an 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 program on Server - Oracle 11g 11.2.0.1 on IBM AIX 64 bit, 6.1, the following error message is received.  
  
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 be 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 on 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 parameter setting in sqlnet.ora:  
  
DIAG\_SIGHANDLER\_ENABLED=FALSE  
  
By default this parameter is set to true.  
  
If you want to see the old behavior you can simply turn off the feature by placing the following parameter setting in your client side sqlnet.ora file under $ORACLE\_HOME/network/admin directory.  
  
2. In addition, please turn off other Diagnostics parameters as well by placing the following entries in the client side or 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 after client upgrade to ORACLE 11.2  
  
显示相关信息 相关的  
产品  
  
 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition  
  
关键字  
DIAGNOSTICS; HANDLER; OCCI; OCI; SQLNET.ORA  
错误  
ORA-24550

最后好像是RAC 客户端的libpthread.so库文件坏了。不知道怎么坏的，换了个新的（还是注释掉这个类库，忘了：））就好了。 数据库连接方式有oci链接RAC，修改成了thin的方式