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.