R12.2 Apps DBA. Powered by Blogger.

Adop Prepare Phase Fails While Calling ad_zd.prepare With Error "ORA-04031: unable to allocate 256 bytes of shared memory

, , No comments :
Log file:
/u11/home/ebspat/fs_ne/EBSapps/log/adop/99/prepare_20160107_004353/ebspat_ebsx01appd03/remote_execution_result_20160107_004905.xml
Error:
[ERROR]     Error Message :
    [ERROR]     ORA-20001: Error while calling ad_zd.prepare.ORA-04031: unable to allocate 256 bytes of shared memory ("shared pool","unknown object","KKSSP^548","KQR ENQ")
    [ERROR]     ORA-06512: at line 10 (DBD ERROR: OCIStmtExecute)
    [UNEXPECTED]Error occurred while creating Patch Edition
    [UNEXPECTED]Error while runCheckAndCreatePatchEdition sub-routine is called
In the log file adzdshowlog, we can see below error
5834983 13:45:12          ad.plsql.ad_zd.create_edition              ERROR      ERROR: ORA-04031: unable to allocate 256 bytes of shared memory ("shared pool","select                                                                                                                        obj#,type#,ctime,mtim...","KKSSP^
  5834983 13:45:12 00:00:00 ad.bin.adop                                ERROR      Failed to execute SQL statement :
                                                                                       declare
                                                                                        result varchar2(10);
                                                                                      begin
                                                                                        ad_zd.PREPARE('Y');
                                                                                      except
Solution:
1.Set sga_target = 6g and pga_aggregate_target = 6g for adop.
2.Restart the database.
3.run adop phase=prepare again.

No comments :

Post a Comment

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

Subscribe to: Post Comments ( Atom )