The monitored Oracle database encounters the following error:
"ORA-7445: exception encountered: core dump [kgghash()+261] [SIGSEGV][ADDR:0x2B0BDA834000][PC:0x770C04D] [Address not mapped to object] []"
How can it be fixed?
This is an Oracle issue and not an Foglight issue.
Oracle bug number: 8938663
or
Oracle Metalink bug 25764352 for Oracle 12c
ORA-07445 is Oracle error message.
RESOLUTION 1
Please contact the Oracle support or apply the Oracle patch 8763922 to solve the issue.
The database getting the error in the alert logs within Foglight.
Turn off the Alert log collections as a workaround in Foglight console.
Steps:
Navigate to the Database dashboard
select/check on the instance in question
Click Settings | Adminstration
Select the Collections item
search for Alert log
disable the Collection
click on Save Changes.
Some the details from the Oracle bug report:
When executing UPDATE statements from a 3rd-party application the following error is raised:
ORA-7445: exception encountered: core dump [kgghash()+261] [SIGSEGV][ADDR:0x2B0BDA834000][PC:0x770C04D] [Address not mapped to object] []
In the incident trace file the following information is found:
1. In the bind variable section of cursor dump one can see that:
- bind variable causing the error has the oacdty=23 and the avl value (4001) is greater than bln value (4000)
2. The call stack trace contains:
... kgghash kkocsCreateBindSet kkocsInitAdaptiveCt ...
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center