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

Last updated on AUGUST 04, 2018

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.