Skip to main content

ORA-07445 After 11g Upgrade in Apps 11i

Hi,

Recently we upgraded our database from 10.2.0.4 to 11.1.07, after some time we encountered error ORA-07445 in our alert log. At the same time we were getting errors at OS level as :

Feb 9 11:41:38 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[27393] attempt to execute code on stack by uid 1001
Feb 9 11:47:41 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[27899] attempt to execute code on stack by uid 1001
Feb 9 11:53:46 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[28755] attempt to execute code on stack by uid 1001
Feb 9 12:01:18 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[29307] attempt to execute code on stack by uid 1001
Feb 9 12:07:21 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[29889] attempt to execute code on stack by uid 1001
Feb 9 12:13:44 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[439] attempt to execute code on stack by uid 1001
Feb 9 13:27:51 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[9905] attempt to execute code on stack by uid 1001
Feb 9 13:32:58 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[10356] attempt to execute code on stack by uid 1001
Feb 9 13:39:00 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[11156] attempt to execute code on stack by uid 1001
Feb 9 13:45:02 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[11701] attempt to execute code on stack by uid 1001
Feb 9 13:51:04 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[12363] attempt to execute code on stack by uid 1001
Feb 9 13:57:07 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[12832] attempt to execute code on stack by uid 1001
Feb 9 14:03:09 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[13401] attempt to execute code on stack by uid 1001
Feb 9 14:09:11 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[14161] attempt to execute code on stack by uid 1001
Feb 9 14:15:15 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[14712] attempt to execute code on stack by uid 1001
Feb 9 14:21:16 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[15298] attempt to execute code on stack by uid 1001
Feb 9 14:27:21 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[15841] attempt to execute code on stack by uid 1001
Feb 9 14:33:21 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[16374] attempt to execute code on stack by uid 1001
Feb 9 14:39:22 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[17149] attempt to execute code on stack by uid 1001
Feb 13 10:41:50 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[7641] attempt to execute code on stack by uid 1001
Feb 13 10:43:37 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[7709] attempt to execute code on stack by uid 1001
Feb 13 10:44:40 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[7707] attempt to execute code on stack by uid 1001
Feb 13 10:46:42 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[8233] attempt to execute code on stack by uid 1001
Feb 13 10:48:44 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[8641] attempt to execute code on stack by uid 1001
Feb 13 10:49:56 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[8639] attempt to execute code on stack by uid 1001
Feb 13 10:52:46 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[8895] attempt to execute code on stack by uid 1001
Feb 13 10:54:47 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[9251] attempt to execute code on stack by uid 1001
Feb 13 10:55:12 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[9253] attempt to execute code on stack by uid 1001
Feb 13 10:58:49 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[9836] attempt to execute code on stack by uid 1001
Feb 13 11:00:53 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[9979] attempt to execute code on stack by uid 1001
Feb 13 11:01:32 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[9981] attempt to execute code on stack by uid 1001
Feb 13 11:05:07 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[10512] attempt to execute code on stack by uid 1001
Feb 13 11:06:57 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[10637] attempt to execute code on stack by uid 1001
Feb 13 11:07:51 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[10639] attempt to execute code on stack by uid 1001
Feb 13 11:10:56 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[11116] attempt to execute code on stack by uid 1001
Feb 13 11:12:58 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[11282] attempt to execute code on stack by uid 1001
Feb 13 11:14:10 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[11280] attempt to execute code on stack by uid 1001
Feb 13 11:16:56 mydomain.com genunix: [ID 533030 kern.notice] NOTICE: oracle[11806] attempt to execute code on stack by uid 1001


In alert log:

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0xFFFFFFFF7FFED1E0] [PC:0xFFFFFFFF7FFED1E0, {empty}]
Errors in file /db1/11g_home/diag/rdbms/diag/rdbms/clonenew/clonenew/trace/clonenew_ora_10356.trc (incident=24790):
ORA-07445: exception encountered: core dump [PC:0xFFFFFFFF7FFED1E0] [SIGSEGV] [ADDR:0xFFFFFFFF7FFED1E0] [PC:0xFFFFFFFF7FFED1E0] [Invalid permissions for mapped object] []
Incident details in: /db1/11g_home/diag/rdbms/diag/rdbms/clonenew/clonenew/incident/incdir_24790/clonenew_ora_10356_i24790.trc
Tue Feb 09 13:33:05 2010
Trace dumping is performing id=[cdmp_20100209133305]
Tue Feb 09 13:33:07 2010

on analysis we found that whenever user running "Process transaction interface" request all child requests "inventory transaction worker" are getting error out.

Whenever we submit this is request it is shutting down the Inventory manager.


Solution:

In oracle database 11g parameter java_jit_enabled is by default true. We changed this parameter to false.

After setting this value we restarted our database and issue resolved.

Comments

Anonymous said…
Hi,

Nice work!!!

Post really helped me out to overcome 07445 issue.
23 November 2010 at 10:30
Post a Comment

Popular posts from this blog

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R
3 comments
Read more

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server  repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment...
1 comment
Read more

Oracle Applications R12.2 Installation on Linux using virtual box

Oracle E-Business suite R12.2 is released a month ago. I received too many requests from my followers to demonstrate this Installation. This is a step by step detailed article for Installing Oracle E-business suite R12,2 on Oracle Enterprise Linux 5.7 (64-bit). I've used oracle virtual box for Installing Linux. Note:  This Installation is demonstrated on virtual machine with 8GB RAM and Installation completed in 7 hours. I am not sure whether this Installation will work with less than this .  My Virtual Machine configuration: CPU    = 1 core RAM   = 8 GB HDD   =  380 GB Software's Required: 1) Oracle Virtual Box 2) Oracle Enterprise Linux 5.7 (64-bit) 3) Oracle E-Business suite R12.2 for LinuxX86-64-bit Installation Steps: Hardware requirements Create virtual machine and Install operating system Operating System pre-requisites Prepare Stage Area Install Oracle EBS R12.2 software Verify Insta...
12 comments
Read more