datapatch -verbose Fails with Error:" Error at line 0: Could not open logfile"

(Doc ID 2242227.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

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

Symptoms

Invoking datapatch -verbose  fails with the following error:

 Symptom 1

 

 Installation queue:
 For the following PDBs: CDB$ROOT PDB$SEED
 Nothing to roll back
 The following patches will be applied:
 24732088 (DATABASE BUNDLE PATCH 12.1.0.2.170117)
 22520268 ()

Installing patches...
Patch installation complete. Total patches installed: 4

Patch 24732088 apply (pdb CDB$ROOT): WITH ERRORS
logfile: /base/oracle/cfgtoollogs/sqlpatch/24732088/20933516/24732088_apply_DO_VIZ01_CDBROOT_2017Mars 01_11_38_20.log (errors)
Error at line 0: Could not open logfile /base/oracle/cfgtoollogs/sqlpatch/24732088/20933516/24732088_apply_DO_VIZ01_CDBROOT_2017Mars 01_11_38_20.log
Patch 22520268 apply (pdb CDB$ROOT): WITH ERRORS
logfile: /base/oracle/cfgtoollogs/sqlpatch/22520268/19753242/22520268_apply_DO_VIZ01_CDBROOT_2017Mars 01_11_39_32.log (errors)
Error at line 0: Could not open logfile /base/oracle/cfgtoollogs/sqlpatch/22520268/19753242/22520268_apply_DO_VIZ01_CDBROOT_2017Mars 01_11_39_32.log
Patch 24732088 apply (pdb PDB$SEED): WITH ERRORS
logfile: /base/oracle/cfgtoollogs/sqlpatch/24732088/20933516/24732088_apply_DO_VIZ01_PDBSEED_2017Mars 01_11_39_34.log (errors)
Error at line 0: Could not open logfile /base/oracle/cfgtoollogs/sqlpatch/24732088/20933516/24732088_apply_DO_VIZ01_PDBSEED_2017Mars 01_11_39_34.log
Patch 22520268 apply (pdb PDB$SEED): WITH ERRORS
logfile: /base/oracle/cfgtoollogs/sqlpatch/22520268/19753242/22520268_apply_DO_VIZ01_PDBSEED_2017Mars 01_11_40_39.log (errors)
Error at line 0: Could not open logfile /base/oracle/cfgtoollogs/sqlpatch/22520268/19753242/22520268_apply_DO_VIZ01_PDBSEED_2017Mars 01_11_40_39.log

 

There is a space between log file name :24732088_apply_DO_VIZ01_CDBROOT_2017Mars 01_11_38_20.log

After Mars there is space.

 

Symptom 2

sqlpatch_invocation.log shows :


Current state of SQL patches:
Bundle series PSU:
 ID 170418 in the binary registry and ID 160119 in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
 Nothing to roll back
 The following patches will be applied:
   25171037 (DATABASE PATCH SET UPDATE 12.1.0.2.170418)

A process terminated prior to completion.
   Review the /oracle/app/cfgtoollogs/sqlpatch/sqlpatch_23165_2017_08_13_08_03_06/sqlpatch_catcon_*.log files to identify the failure
Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...
Patch 25171037 apply: WITH ERRORS
 logfile: /oracle/app/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply_ORCL_2017Aug13_08_04_16.log (errors)
   Error at line 0: Could not open logfile /oracle/app/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply_ORCL_2017Aug13_08_04_16.log


   
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
sqlpatch_catcon_0.log  shows the error: SP2-0606: Cannot create SPOOL file
 
SQL> old   1: SELECT '&logfiledir' || '25171037_apply_' ||
new   1: SELECT '/oracle/app/cfgtoollogs/sqlpatch/25171037/21099266/' || '25171037_apply_' ||

SQLPATCH_LOGFILE
--------------------------------------------------------------------------------
/oracle/app/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply_ORCL_2017Aug13_08_04_16.log


SP2-0606: Cannot create SPOOL file "/oracle/BASE/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply_ORCL_2017Aug13_08_04_16.log"

 

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms