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\sqlpatch\ sqlpatch_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
二：设置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\sqlpatch\ sqlpatch_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>
