エラー「ORA-04031：共有メモリのバイトを割り当てることができません」は何を意味しますか？ - WKB125380

環境

• Empower
• Linux
• Oracle
• Waters 組み込みライセンスを使用していない

回答

お客様が Oracle を Linux データベースに展開しました。したがって、独自の Oracle ライセンスおよび Oracle サポート契約があります。

Waters は、このエラーに関するアドバイスを提供できません。お客様は Oracle に直接問題を提起し、DBA にさらに調査を依頼する必要があります。

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

追加情報

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.