ORA-7445 [_etext_f] with Intelligent Agent and Enterprise Manager/Grid Control
(Doc ID 457441.1)
Last updated on OCTOBER 09, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.5 to 9.2.0.7 [Release 9.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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
Changes
NONE
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |