window下12.2.0.1版本数据库应用补丁报错Could not open logfile

C:\app\Administrator\virtual\product\12.2.0\dbhome_1\OPatch>datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Tue Aug  4 20:12:26 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: C:\app\Administrator\virtual\cfgtoollogs\sqlpatchsqlpatch_2448_2020_08_04_20_12_26\sqlpatch_invocation.log

Connecting to database...OK
Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series PSU:
  ID 200414 in the binary registry and not installed in any PDB

Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED ORCLPDB
    Nothing to roll back
    The following patches will be applied:
      30861472 (WINDOWS DB BUNDLE PATCH 12.2.0.1.200414(64bit):30861472)

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

Validating logfiles...
Patch 30861472 apply (pdb CDB$ROOT): WITH ERRORS
  logfile: C:\app\Administrator\virtual\cfgtoollogs\sqlpatch\30861472\23491978/3
0861472_apply_ORCL_CDBROOT_20208月 04_20_13_13.log (errors)
    Error at line 0: Could not open logfile C:\app\Administrator\virtual\cfgtool
logs\sqlpatch\30861472\23491978/30861472_apply_ORCL_CDBROOT_20208月 04_20_13_13.
log
Patch 30861472 apply (pdb PDB$SEED): WITH ERRORS
  logfile: C:\app\Administrator\virtual\cfgtoollogs\sqlpatch\30861472\23491978/3
0861472_apply_ORCL_PDBSEED_20208月 04_20_15_51.log (errors)
    Error at line 0: Could not open logfile C:\app\Administrator\virtual\cfgtool
logs\sqlpatch\30861472\23491978/30861472_apply_ORCL_PDBSEED_20208月 04_20_15_51.
log
Patch 30861472 apply (pdb ORCLPDB): WITH ERRORS
  logfile: C:\app\Administrator\virtual\cfgtoollogs\sqlpatch\30861472\23491978/3
0861472_apply_ORCL_ORCLPDB_20208月 04_20_17_18.log (errors)
    Error at line 0: Could not open logfile C:\app\Administrator\virtual\cfgtool
logs\sqlpatch\30861472\23491978/30861472_apply_ORCL_ORCLPDB_20208月 04_20_17_18.
log

Please refer to MOS Note 1609718.1 and/or the invocation log
C:\app\Administrator\virtual\cfgtoollogs\sqlpatch\sqlpatch_2448_2020_08_04_20_12
_26\sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Tue Aug  4 20:18:49 2020

一:mos文章提供的解决办法 Doc ID 2243580.1

window下12.2.0.1版本数据库应用补丁报错Could not open logfile

 

二:设置nls_language为american,并重新执行

C:\Users\Administrator>set NLS_LANG=American_America
C:\Users\Administrator>set nls_lang
NLS_LANG=American_America
C:\app\Administrator\virtual\product\12.2.0\dbhome_1\OPatch>datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Wed Aug  5 07:59:56 2020
Copyright (c) 2012, 2020, Oracle.  All rights reserved.

Log file for this invocation: C:\app\Administrator\virtual\cfgtoollogs\sqlpatchsqlpatch_2724_2020_08_05_07_59_56\sqlpatch_invocation.log

Connecting to database...OK
Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series PSU:
  ID 200414 in the binary registry and ID 200414 with errors in PDB CDB$ROOT, ID
 200414 with errors in PDB PDB$SEED, ID 200414 with errors in PDB ORCLPDB

Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED ORCLPDB
    Nothing to roll back
    The following patches will be applied:
      30861472 (WINDOWS DB BUNDLE PATCH 12.2.0.1.200414(64bit):30861472)

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

Validating logfiles...
Patch 30861472 apply (pdb CDB$ROOT): SUCCESS
  logfile: C:\app\Administrator\virtual\cfgtoollogs\sqlpatch\30861472\23491978/3
0861472_apply_ORCL_CDBROOT_2020Aug05_08_00_35.log (no errors)
Patch 30861472 apply (pdb PDB$SEED): SUCCESS
  logfile: C:\app\Administrator\virtual\cfgtoollogs\sqlpatch\30861472\23491978/3
0861472_apply_ORCL_PDBSEED_2020Aug05_08_02_11.log (no errors)
Patch 30861472 apply (pdb ORCLPDB): SUCCESS
  logfile: C:\app\Administrator\virtual\cfgtoollogs\sqlpatch\30861472\23491978/3
0861472_apply_ORCL_ORCLPDB_2020Aug05_08_03_23.log (no errors)
SQL Patching tool complete on Wed Aug  5 08:04:59 2020
C:\app\Administrator\virtual\product\12.2.0\dbhome_1\OPatch>

 

window下12.2.0.1版本数据库应用补丁报错Could not open logfile

上一篇:解决Access文件越来越大的问题


下一篇:django is_safe_url方法使用说明