ORA-7445 [_etext_f] with Intelligent Agent and Enterprise Manager/Grid Control (Doc ID 457441.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 9.2.0.7
This problem can occur on any platform.

Symptoms

The following error is reported when the Intelligent Agent takes a snapshot collection and sends it to GRID Control: 

   ORA-07445: exception encountered: core dump [_etext_f()+2305843009112923042] [SIGILL]
                         [Illegal opcode] [0x600000000047C562]

The call stack in the trace file resembles: 

_etext_f
ksurlmf
qerfxFetch
rwsfcd
qeruaFetch
qervwFetch
qersoFetch


The failing statement reported in the trace file is: 
   /* OracleOEM */
   SELECT usage
   FROM (select RESOURCE_NAME name, 100*DECODE(initial_allocation,' UNLIMITED',0,
   current_utilization /
   initial_allocation) usage
   from v$resource_limit
   where LTRIM(limit_value) != '0' and LTRIM(initial_allocation) != '0'
   and resource_name in ('dml_locks', 'processes', 'sessions') 
   union all
   select 'user' name
   ,100* DECODE(sessions_max,0,0,sessions_current/sessions_max) usage
   from v$license
   )
   order by name

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