ORA-07445 [STRLEN()+24] Running Command 'Show Parameter'
(Doc ID 1078807.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
After entering 'show parameter...' in sqlplus, received an ORA-3113 error
The alert log also reports this error at the same time:
ORA-07445: exception encountered: core dump [strlen()+24] [SIGSEGV] [Address not mapped to object] [0x00038001D] [] []
Trace file indicates the failing sql is:
SELECT NAME NAME_COL_PLUS_SHOW_PARAM, DECODE(TYPE,1,'boolean',2,'string',3,'integer',4,'file',5,'number', 6,'big integer', 'unknown') TYPE,DISPLAY_VALUE VALUE_COL_PLUS_SHOW_PARAM
FROM V$PARAMETER
WHERE UPPER(NAME) LIKE UPPER('%sga%')
ORDER BY NAME_COL_PLUS_SHOW_PARAM,ROWNUM
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 |
| Cause |
| Solution |
| References |