Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

“Signal 11″ : Not So Scary Anymore..

Posted on March 11th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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

Related Posts

Posted in AOL | 1 Comment »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
One Response
  1. Mike Says:

    Thanks Sanjit, this is best ever i read on this topic.

    Keep it good work.
    Mike

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.