Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Tuesday, 16 February 2010

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.

1 comment:

Anonymous said...

Hi,

Nice work!!!

Post really helped me out to overcome 07445 issue.