注册 登录  
 加关注
查看详情
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

Memory extender

Beautiful Day..

 
 
 

日志

 
 

“Signal 11″ : Not So Scary Anymore..(转)  

2012-09-27 14:47:43|  分类: EBS Report |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

最近遇到的两次

stat_low = B

stat_high = 0 emsg:was terminated by signal 11
发现其中一个是由于RDF中某个Function里面有table.char_column=1这样的条件语句。。即invalid_number错误
另一个是由于RDF before report trigger中所调用的PACKAGE中有造成too_many_rows错误的SQL
 



以下转自http://www.oracleappshub.com/aol/signal-11-not-so-scary-anymore/

--------------------------------------------------------------------------------------------------------------------------------------------------

Signal 11’ is one of the most scary things in EBS developer/Apps DBA community . If you haven't encounter yet , after working couple of years in EBS, that means you are quite lucky ..kidding

If you came from basic C programing skill, then you might be linking with malloc ..memory allocation , believe me, that is totally different.

In this post I will share some of the information which you need to know, rather than a creating a panic situation with developer or DBA .

dgreybarrow WHAT IS SIGNAL 11

In layman term, Signal 11 is an obscure way to say that there is hardware problem with the system's memory

"Unaligned memory access" is a message coming back from the UNIX operating system letting you know that an Oracle executable has tried to access memory incorrectly. It's not a problem with UNIX but is part of the operating system's mechanism of protecting itself from crashing.

Chances are there you might get either of these ..Autoinvoice ,GLPPOS, GLLEZL, GLBMBO, APXXTR, GLNSVI, INCTGL , GLAMAS, ARZCAR, ARGLTP, RGRARG, GLCRVL,GLPAUTOP ,FADEPR - Depreciation, PDF Reports, XML OUTPUT

dgreybarrow SIMPLE CAUSES MAY INCLUDE

  • Not enough disk space in $APPL_TOP/out directory where the concurrent manager creates the report output files.
  • Lack of storage space in table spaces, rollback segments etc
  • Very complex SQL statements with many Group By columns (which may not all be required)
  • Incorrect OS permission’s
  • Parameter mismatches
  • The reports were FTPed incorrectly (ASCII instead of binary)
  • A 'Numeric or Value error' on some procedure code (although this may also cause a Signal 4 error). Typically this is because you have a field or variable which is too small to hold a value passed to it, which often happens when you are summing values.

dgreybarrow TECHNICALLY

  • All ‘Signal’ messages (there are between 15 and 36 different ones depending on the OS) mean that the OS is telling the current process that something has happened, or is ordering it to do something.
  • Take a example , when you do a ‘kill -9 <proc_id>’ on the server, you are actually sending a Signal 9 (SIGKILL) to that process.
  • Depending on the error, the running process can either ignore the Signal, exit gracefully, or exit and write a copy of its current memory stack to the filesystem
  • Core dump file is always unwanted.
  • Signals 6 (Abort), 10 (Bus Error), 11 (Memory Pointer Error) and 12 (Bad System Call) all fall into the last category and write a ‘core’ file.
  • Signal 11 is : “Process asked to be allocated <x> Bytes of memory, but is now trying to access an address which is not within that allocation or is trying to access a null address”.
  • This may be caused by code or data problems.

You usually find, windows equivalent of a Signal 11 error is when a process terminates with ‘Error -1073741819’

dgreybarrowWHEN YOU ENCOUNTER THIS

  1. First thing to look at is the last few lines of logfile – preferably with Debug on
  2. Searching that you might find in log file, chances are high you will get some node at metalink. if not
  3. Check with your apps DBA , pass the information , he will try to Analyze/diagnosis and advice.
    • what he will do, he will try to locate core file which got is written to the directory from which the executable was called.
    • Take a note,after a Signal 11 error has occurred, the program may write a dump of itself to $<product>_TOP/bin
    • The ‘core’ file which got located is just a dump of the memory occupied by the program at the time of failure, and as such is not easy to read.
    • they need some utilities to produce a readable output. DBA typically used these utilities adb, dbx, xdb, gdb,
  4. If nothing get solved Quickly, raise a SR with Oracle.

Meantime , you can also check the list of unix signals with their explanation in note id 1038055.6

  评论这张
 
阅读(1496)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018