ORA-7445 [_etext_f] with Intelligent Agent and Enterprise Manager/Grid Control
(Doc ID 457441.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168 to 22.214.171.124
This problem can occur on any platform.
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:
The failing statement reported in the trace file is:
/* OracleOEM */
FROM (select RESOURCE_NAME name, 100*DECODE(initial_allocation,' UNLIMITED',0,
where LTRIM(limit_value) != '0' and LTRIM(initial_allocation) != '0'
and resource_name in ('dml_locks', 'processes', 'sessions')
select 'user' name
,100* DECODE(sessions_max,0,0,sessions_current/sessions_max) usage
order by name
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document