GI/RDBMS alert reported in LIST ALERTHISTORY
(Doc ID 2856479.1)
Last updated on DECEMBER 02, 2022
Applies to:
Oracle Exadata Storage Server Software - Version 21.2.0.0.0 and laterInformation in this document applies to any platform.
Goal
Oracle Exadata System Software release 21.2.0 introduces enhanced alerting on the database servers. With this capability, the DBMCLI LIST ALERTHISTORY command now shows incidents relating to Oracle Grid Infrastructure and Oracle Database software.
Example of Alert: dbmcli -e list alerthistory
40313 2022-02-23T12:18:51-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 1")"
40314 2022-02-23T12:24:21-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 1")"
40315 2022-02-23T12:28:30-05:00 warning "oci-24550 [11] [[si_signo=11] [si_errno=0] [si_code=1] [si_int=848346464] [si_ptr=0x7ffc3290bd60] [si_addr=0x18]] [] [] [] [] [] [] [] [] [] []"
40316 2022-02-23T12:28:51-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 1")"
40317 2022-02-23T12:28:54-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 0")
ORA-10387: parallel query server interrupt (normal)"
40318 2022-02-23T12:29:01-05:00 warning "oci-24550 [11] [[si_signo=11] [si_errno=0] [si_code=1] [si_int=-815906464] [si_ptr=0x7ffccf5e4160] [si_addr=0x18]] [] [] [] [] [] [] [] [] [] []"
40319 2022-02-23T12:38:39-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 1")"
40314 2022-02-23T12:24:21-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 1")"
40315 2022-02-23T12:28:30-05:00 warning "oci-24550 [11] [[si_signo=11] [si_errno=0] [si_code=1] [si_int=848346464] [si_ptr=0x7ffc3290bd60] [si_addr=0x18]] [] [] [] [] [] [] [] [] [] []"
40316 2022-02-23T12:28:51-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 1")"
40317 2022-02-23T12:28:54-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 0")
ORA-10387: parallel query server interrupt (normal)"
40318 2022-02-23T12:29:01-05:00 warning "oci-24550 [11] [[si_signo=11] [si_errno=0] [si_code=1] [si_int=-815906464] [si_ptr=0x7ffccf5e4160] [si_addr=0x18]] [] [] [] [] [] [] [] [] [] []"
40319 2022-02-23T12:38:39-05:00 warning "ORA-04031: unable to allocate 32928 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","NUMA pool 1")"
How to disable DB alert reporting in Exadata DB server alerthistory?
Solution
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
| Goal |
| Solution |