SAP Knowledge Base Article - Preview

3428765 - ECO: ORA-04031: unable to allocate xxxx bytes of shared memory - SRS

Symptom

  • Heterogeneous replication to Oracle 9i through ExpressConnect for Oracle (ECO)
  • ECO DSI connection got shutdown with the following Oracle errors:

    • Message from server: Message: 4031, State 0, Severity 5 -- '[ statement ]
      [ <ECO> ] ociStmt::Execute ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","SELECT SUM(BYTES/1048576) FR...","SQLP","tmp")

  • After shutting down Oracle(to flush memory) and cycling Replication Server, the transactions begin to process until the errors occurs again.


Read more...

Environment

  • SAP Replication Server Heterogeneous Edition (RSHE) 16.0
  • SAP Replication Server 16.0 SP04
  • Oracle 19c Patch 21

Keywords

ORA-04031; Oracle shared memory , KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.