Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB_ACTION_STATNEW - Error - How to increase shared memory in shadow instanc

Hi all,

We are facing the below error in the DB_ACTION_STATNEW phase:


TRACE-INFO: 82: 13 4.822960

TRACE-INFO: 83: [developertra,00000] WHERE TABNAME = :A0; 8 4.822968

TRACE-INFO: 84: [dbntab ,06694] ***LOG BY4=>sql error 604 performing SEL on table DDNTT

TRACE-INFO: 85: 222 4.823190

TRACE-INFO: 86: [dbntab ,06694] ***LOG BY0=>ORA-00604: error occurred at recursive SQL level 1

TRACE-INFO: 87: ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select t.ts#,t.file#,t.block...","Typecheck","seg:kggfaAllocSeg")

TRACE-INFO: 88: 21 4.823211

TRACE-INFO: 89: [dbeh.c ,00000] *** ERROR => missing return code handler 13 4.823224

TRACE-INFO: 90: caller does not handle code 1 from dbntab.c[3718]

TRACE-INFO: 91: ==> calling sap_dext to abort transaction

HALT 20080410111303


We have a physical RAM of 64 GB.

dcecqv1:root > dmesg | more

Apr 10 11:24


$Revision: vmunix: B11.23_LR FLAVOR=perf Fri Aug 29 22:35:38 PDT 2003 $

Memory Information:

physical page size = 4096 bytes, logical page size = 4096 bytes

Physical: 66399504 Kbytes, lockable: 51408244 Kbytes, available: 59648572 Kbytes

From the error message, I feel that I need to increase the shared memory, can you help me how to increase the shared memory now, bcos system is now running in the shadow instance.

Thanks & Regards



Can you please help me with the procedure how to stop upgrade/sap/oracle at this stage and start the same?

To Stop Upgrade & SAP Instance

1) Exit out of your Upgrade Assistant

2) go to directory <DIR_PUT>/bin and execute the command

./SAPup stopshd

3) stopsap (to shutdown SAP and DB)

4)Kill all tp, R3load, SAPup, JAVA proceess

cleanipc <instance no> remove

cleanipc <shadow instance no> remove

To Start SAP & Upgrade

1) startsap

2) go to directory <DIR_PUT>/bin and execute the command

./SAPup startshd (to start the system)

2) start the Upgrade Assistance and Repeat the phase

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question