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.
Symptoms
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 :
declare
result varchar2(10);
begin
ad_zd.PREPARE('Y');
exception
when others then
update ad_adop_sessions set status='F'
where adop_session_id=16;
commit;
raise_application_error(-20001,'Error while calling ad_zd.prepare.' || sqlerrm);
end;
[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.
declare
result varchar2(10);
begin
ad_zd.PREPARE('Y');
exception
when others then
update ad_adop_sessions set status='F'
where adop_session_id=16;
commit;
raise_application_error(-20001,'Error while calling ad_zd.prepare.' || sqlerrm);
end;
[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:
Changes
No known changes.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |