Getting ORA-03113 when compiling an SP
Oracle - 10.2.0.5
OS-Solaris10
xxx > alter PROCEDURE sc.PRC_LC_X_SELECT_TL_RATCHET compile;
alter PROCEDURE sc.PRC_LC_X_SELECT_TL_RATCHET compile
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Can any body help me out on this issue? Core dump file is generated at USER_DUMP_DEST with following messages:
*** 2010-09-22 06:07:04.922
*** ACTION NAME:() 2010-09-22 06:07:04.919
*** MODULE NAME:(sqlplus@whdsnavdb01 (TNS V1-V3)) 2010-09-22 06:07:04.919
*** SERVICE NAME:(SYS$USERS) 2010-09-22 06:07:04.919
*** SESSION ID:(1110.716) 2010-09-22 06:07:04.919
Exception signal: 10 (SIGBUS), code: 1 (Invalid address alignment), addr: 0xffffffffdcd329b4, PC: [0x1040ff84c, kgh_subtract_e
xtent_chunks()+396]
Registers:
----------
%o0: 0x000000002d205468 %o1: 0x000000002d205468 %o2: 0x0000000106329548
%o3: 0x0000000000000003 %o4: 0x0000000000007fff %o5: 0x00000000000000c8
%o6: 0xffffffff7fff6000 %o7: 0x0000000000008000
%g1: 0x000000007ffffffc %g2: 0x000000005f585f54 %g3: 0x000000002d205448
%g4: 0x000000002d205468 %g5: 0xffffffff7d7ac93f %g6: 0x0000000000000000
%g7: 0xffffffff7d500200
%pc: 0x00000001040ff84c %npc: 0x00000001040ff720 %y: 0x0000000000000000
Stack info:
----------
ss_sp: 0xffffffff7e000000 ss_size: 0x0000000002000000 ss_flags: 0
*** 2010-09-22 06:07:04.926
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgh_subtract_extent_chunks()+396] [SIGBUS] [Invalid address alignment] [0xFFFFFFF
FDCD329B4] [] []
Current SQL statement for this session:
alter PROCEDURE sc.PRC_LC_X_SELECT_TL_RATCHET compile
Regards.