On Login Users Hang And OSM DB Has Alert Error ORA-07445 (Doc ID 740508.1)

Last updated on FEBRUARY 05, 2013

Applies to:

Oracle Communications Order and Service Management - Version 6.3.1 to 6.3.1 [Release 6.3]
Information in this document applies to any platform.

Symptoms

Web login users are hanging. The following alert log was found in Oracle Database:

Errors in file /u01/app/oracle/admin/NOTADB/udump/notadb_ora_16965.trc:
*** 2008-09-18 13:19:54.540
*** SERVICE NAME:(SYS$USERS) 2008-09-18 13:19:54.529
*** SESSION ID:(150.25) 2008-09-18 13:19:54.529
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1017d64dc, evaopn2()+220]
*** 2008-09-18 13:19:54.547
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [evaopn2()+220] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
SELECT RESPDESC, RESPID, CARTRIDGE_ID, SUM(RT.ORDER_SUM), SUM(RT.OVERDUE_SUM), MAX(RT.LATEST), MIN(RT.OLDEST) FROM ( SELECT NVL(R.RESPONSIBILITY_DESCRIPTION, OM_DB_MSG_PKG.V_TASK) RESPDESC, NVL(EXT_TASK.RESPONSIBILITY_ID, -2) RESPID, T.CARTRIDGE_ID, T.TASK_ID, T.TASK_TYPE, T.TASK_DESCRIPTION, S.STATE_ID, S.STATE_DESCRIPTION, ORDER_SUM, OVERDUE_SUM, LATEST, OLDEST FROM ( SELECT PRO_POS.TASK_ID, PRO_POS.TASK_TYPE, OFLOW.STATE_ID, SUM(ORDERCOUNT) ORDER_SUM, SUM(OVERDUE) OVERDUE_SUM, MAX(LATEST) LATEST, MIN(OLDEST) OLDEST FROM ( SELECT FLOW.PROCESS_ID, FLOW.PROCESS_POSITION_ID, FLOW.STATE_ID, COUNT(1) AS ORDERCOUNT, SUM(DECODE(SIGN(:B5 - HDR.ORD_COMPL_DATE_EXPECTED), 1, 1,0)) AS OVERDUE, MAX(HDR.ORD_CREATION_DATE) LATEST, MIN(HDR.ORD_CREATION_DATE) OLDEST FROM OM_ORDER_HEADER HDR, OM_ORDER_FLOW FLOW, OM_ORDER_TYPE TYP, OM_ORDER_SOURCE SRC WHERE HDR.ORDER_SEQ_ID = FLOW.ORDER_SEQ_ID AND HDR.ORDER_SOURCE_ID = SRC.ORDER_SOURCE_ID AND HDR.ORDER_TYPE_ID = TYP.ORDER_TYPE_ID AND ( SRC.ORDER_SOURCE_MNEMONIC = :B4 OR :B4 IS NULL ) AND ( TYP.ORDER_TYPE_MNEMONIC = :B3 OR :B3 IS NULL ) AND ( HDR.CARTRIDGE_ID = :B2 OR :B2 IS NULL ) AND (HDR.CARTRIDGE_ID IN (SELECT CARTRIDGE_ID FROM OM_CARTRIDGE WHERE NAMESPACE_MNEMONIC = :B1 ) OR :B1 IS NULL ) GROUP BY FLOW.PROCESS_ID, FLOW.PROCESS_POSITION_ID, FLOW.STATE_ID ) OFLOW, OM_PROCESS_POSITION PRO_POS WHERE PRO_POS.PROCESS_ID = OFLOW.PROCESS_ID AND PRO_POS.PROCESS_POSITION_ID = OFLOW.PROCESS_POSITION_ID GROUP BY PRO_POS.TASK_ID, PRO_POS.TASK_TYPE, OFLOW.STATE_ID) ORD, OM_EXTERNAL_TASK EXT_TASK, OM_TASK T, OM_RESPONSIBILITY R, OM_STATE S WHERE S.STATE_ID = ORD.STATE_ID AND T.TASK_ID = ORD.TASK_ID AND T.TASK_TYPE = ORD.TASK_TYPE AND EXT_TASK.TASK_ID(+) = ORD.TASK_ID AND EXT_TASK.TASK_TYPE(+) = ORD.TASK_TYPE AND R.RESPONSIBILITY_ID(+) = EXT_TASK.RESPONSIBILITY_ID ) RT GROUP BY RESPID , CARTRIDGE_ID , RESPDESC ORDER BY RESPID


WebLogic server had to be rebooted to continue using the system.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms