Adop Finalize Phase Is Failing with ORA-01652: unable to extend temp segment (Doc ID 2596281.1)

Last updated on FEBRUARY 16, 2023

Applies to:

Symptoms

On : 12.2.4 version, Patch Application Issues: adop finalize phase is failing with ORA-01652: unable to extend temp segment


ERROR
-----------------------

Error From the Console:

Statement Handler Error Code: 20001
Statement Handler Error Message: ORA-20001: Error: while calling ad_zd.finalize .ORA-01652: unable to extend temp segment by 16 in tablespace M_TEMP>>>>> Error on Console.
ORA-06512: at line 7 (DBD ERROR: OCIStmtExecute)
Reference of statement-handler is valid, not attempting database reconnect.
Failed to execute SQL statement:
  begin
  ad_zd.finalize('QUICK');
  exception
  when others then
  ad_zd_adop.update_session_status_failed(55);
  commit;
  raise_application_error(-20001,'Error: while calling ad_zd.finalize .' || sqlerrm);
  end;

Error Message:
ORA-20001: Error: while calling ad_zd.finalize .ORA-01652: unable to extend temp segment by 16 in tablespace M_TEMP
ORA-06512: at line 7 (DBD ERROR: OCIStmtExecute) [UNEXPECTED]Error occurred calling finalize PL/SQL API
  [UNEXPECTED]Finalize phase has failed.

**************adop.log****************

EVENT]     Running finalize phase database actions.
   [EVENT]     Log: @ADZDSHOWLOG.sql "2019/10/01 03:49:38"
   [UNEXPECTED]Error occurred calling finalize PL/SQL API
   [UNEXPECTED]Finalize phase has failed.>>>>>>>>>>>>>>>>>>>>>>>>>>>>Finalize Failed.
   [PROCEDURE] [START 2019/10/01 03:52:12] Updating adop session status
   [STATEMENT] SQL statement : "  update ad_adop_sessions
 set status='F'
  where adop_session_id = 52 and appltop_id = 196 and node_name='atl0lerps002'
"
   [PROCEDURE] [END   2019/10/01 03:52:13] Updating adop session status
   [PROCEDURE] [START 2019/10/01 03:52:13] Unlocking sessions table
   [STATEMENT] Unlocking ad_adop_sessions table for atl0lerps002 with wait interval of 60 seconds and number of tries 2

   [PROCEDURE] [END   2019/10/01 03:52:13] Unlocking sessions table
   [PROCEDURE] [START 2019/10/01 03:52:13] Updating adop session status
   [STATEMENT] SQL statement : "  update ad_adop_sessions
 set status='F'
  where adop_session_id = 52 and appltop_id = 196 and node_name='atl0lerps002'
"
   [PROCEDURE] [END   2019/10/01 03:52:14] Updating adop session status

**************************************


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. adop phase = finalize

BUSINESS IMPACT
-----------------------

Due to this issue, users cannot run adop finalize, and complete patching cycle.

Changes

Cause

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