R12.2 Apps DBA. Powered by Blogger.

ORA-04031: unable to allocate 4160 bytes of shared memory Cutover Phase Fails R12.2

No comments :
ERROR
-----------------------
ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -4031:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","modification ") has been detected in FND_GSM_UTIL.upload_context_file.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -4031: ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","modification ") has been detected in FND_GSM_UTIL.upload_context_file.
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:332)
*******FATAL ERROR*******
PROGRAM : (/oracle/CLONE/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPCutOverPhaseCtrlScript.pl)
Sol:
1. Please review Note:146599.1 Diagnosing and Resolving Error ORA-04031.
2. Flush shared pool. This should take care of the issue as it has come once.
ALTER SYSTEM FLUSH SHARED_POOL;
If step 2 does not work:
3. Increase the shared memory or a simple DB bounce could resolve the issue.
Ref: ORA-04031: Unable to Allocate 83232 Bytes of Shared Memory (Doc ID 374329.1)

No comments :

Post a Comment

Note: only a member of this blog may post a comment.