My Oracle Support Banner

datapatch Fails with Error :"patch NNNNNNNN: Archive::Zip->writeToFileNamed returned 4" (Doc ID 2950620.1)

Last updated on MAY 26, 2023

Applies to:

Oracle Database - Standard Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

datapatch fails with error:

Adding patches to installation queue and performing prereq checks...done
Installation queue:
    No interim patches need to be rolled back
    Patch 35042068 (Database Release Update : 19.19.0.0.230418 (35042068)):
      Apply from 19.1.0.0.0 Feature Release to 19.19.0.0.0 Release_Update 230322020406

Error: prereq checks failed!
  patch 35042068: Archive::Zip->writeToFileNamed returned 4
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
$ORACLE_BASE/cfgtoollogs/sqlpatch/sqlpatch_<timestamp>/sqlpatch_invocation.log
for information on how to resolve the above errors.



sqlpatch_invocation.log shows:

IO error: Can't open $ORACLE_HOME/sqlpatch/35042068/25183678/35042068.zip for write : Permission denied
 at $ORACLE_HOME/sqlpatch/lib/Archive/Zip/Archive.pm line 382.
    Archive::Zip::Archive::writeToFileNamed(Archive::Zip::Archive=HASH(0x34fde00), "$ORACLE_HOME/sqlpatch/35042068/25183678/3504206"...) called at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 9681
    eval {...} called at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 9680

sqlpatch::directory_zip("35042068/25183678", 1) called at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 6224
    sqlpatch::check_queue_prereqs() called at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 4879
    sqlpatch::add_to_queue() called at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 2624
    eval {...} called at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 2595
    sqlpatch::patch() called at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 223
Error: prereq checks failed!
patch 35042068: Archive::Zip->writeToFileNamed returned 4

 

 

 

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


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