My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle Applications DBA - Version 12.2.2 to 12.2.4 [Release 12.2Cloud]
Information in this document applies to any platform.


On : 12.2.2 version, Upgrade related issues

When attempting to run adop phase=prepare the following error occurs.

 [ERROR] Failed to execute SQL statement :
  result varchar2(10);
  when others then
  update ad_adop_sessions set status='F'
  where adop_session_id=16;
  raise_application_error(-20001,'Error while calling ad_zd.prepare.' || sqlerrm);

  [ERROR] Error Message :
  [UNEXPECTED]Error occurred while creating Patch Edition
  [UNEXPECTED]Error while runCheckAndCreatePatchEdition sub-routine is called
  [ERROR] Prepare phase completed with errors or warnings. Please check logfiles.

In the log adzdshowlog, the following error is shown: 



 No known changes. 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.