ORA-24550错误
问题描述:
[oracle@app-148-39 oracledata]$ sqluldr2_linux64_10204.bin USER=xxx/xxx@xxx:1521 charset=AL32UTF8 QUERY="select /*+ parallel(2) */ * from zxjs.TMP_SJXQ_EDUCATION_20161108" log=/data/oracledata/TMP_SJXQ_EDUCATION/TMP_SJXQ_EDUCATION_20161108.log table=TMP_SJXQ_EDUCATION_20161108 head=yes FILE=/data/oracledata/TMP_SJXQ_EDUCATION/TMP_SJXQ_EDUCATION_20161108.txt
ORA-24550: signal received: [si_signo=11] [si_errno=0] [si_code=1] [si_int=647055272] [si_ptr=0x7f99269147a8] [si_addr=(nil)]
kpedbg_dmp_stack()+314<-kpeDbgCrash()+166<-kpeDbgSignalHandler()+158<-skgesig_sigactionHandler()+217<-__restore_rt()<-fclose()+4<-3237314033323173
Killed
解决方式:
修改sqlnet.ora文件
vi /home/oracle/oracle_base/ora11g/network/admin/sqlnet.ora
ADR_BASE = /home/oracle/oracle_base
其它解决方式:
vi /home/oracle/oracle_base/ora11g/network/admin/sqlnet.ora
添加:
<span style="BACKGROUND-COLOR: #ffff33">DIAG_ADR_ENABLED=OFF
DIAG_SIGHANDLER_ENABLED=FALSE
DIAG_DDE_ENABLED=FALSE</span>