What is the meaning of the error ORA-04031: Unable to allocate bytes of shared memory? - WKB125380

ENVIRONMENT

• Empower
• Linux
• Oracle
• Not using the Waters Embedded License

ANSWER

The customer deployed Oracle to a Linux database; therefore, they have their own Oracle license and Oracle support agreement.

Waters cannot advise on this error. The customer should raise the issue directly with Oracle and have their DBAs investigate further.

• https://support.oracle.com/knowledge/Oracle%20Database%20Products/369260_1.html
• https://support.oracle.com/knowledge/Oracle%20Database%20Products/1509795_1.html

ADDITIONAL INFORMATION

Errors in file /u001/app/oracle/diag/rdbms/wataprj/WATAPRJ1/trace/WATAPRJ1_pz98_27557.trc (incident=365340):
ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","KKSSP^645","kglseshtTable")
Incident details in: /u001/app/oracle/diag/rdbms/wataprj/WATAPRJ1/incident/incdir_365340/WATAPRJ1_pz98_27557_i365340.trc
Wed Feb 10 21:17:07 2021
Dumping diagnostic data in directory=[cdmp_20210210211707], requested by (instance=1, osid=27557 (PZ98)), summary=[incident=365340].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Feb 10 21:17:07 2021
Errors in file /u001/app/oracle/diag/rdbms/wataprj/WATAPRJ1/trace/WATAPRJ1_dm00_27555.trc (incident=365333):
ORA-04031: unable to allocate bytes of shared memory ("","","","")
Incident details in: /u001/app/oracle/diag/rdbms/wataprj/WATAPRJ1/incident/incdir_365333/WATAPRJ1_dm00_27555_i365333.trc
Wed Feb 10 21:17:08 2021
WARNING: Oracle executable binary mismatch detected.
Binary of new process does not match binary which started instance
issue alter system set "_disable_image_check" = true to disable these messages
Wed Feb 10 21:17:08 2021
Sweep [inc][365340]: completed
Sweep [inc][365333]: completed
Sweep [inc2][365340]: completed
Wed Feb 10 21:17:08 2021
WARNING: Oracle executable binary mismatch detected.