12c R2打补丁遇到的Bug 26203745
原创
©著作权归作者所有:来自51CTO博客作者Expect_lei的原创作品,请联系作者获取转载授权,否则将追究法律责任
在打完补丁,做最后将SQL文件加载到数据库过程中
错误信息:
[oracle@cndba OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Tue Dec 19 15:07:11 2017
Copyright (c) 2012, 2017, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_28921_2017_12_19_15_07_11/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 DBRU:
ID 171017 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 LEIPDB
Nothing to roll back
The following patches will be applied:
26710464 (DATABASE RELEASE UPDATE 12.2.0.1.171017)
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles... --验证日志文件是否有错误
Patch 26710464 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26710464/21632407/26710464_apply_ORCL_CDBROOT_2017Dec19_15_07_33.log (no errors)
Patch 26710464 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26710464/21632407/26710464_apply_ORCL_PDBSEED_2017Dec19_15_09_25.log (no errors)
Patch 26710464 apply (pdb LEIPDB): WITH ERRORS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26710464/21632407/26710464_apply_ORCL_LEIPDB_2017Dec19_15_09_27.log (errors)
Error at line 32: ORA-65254: invalid path specified for the directory --具体错误信息
Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_28921_2017_12_19_15_07_11/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Tue Dec 19 15:10:44 2017
MOS文档:
Datapatch Fails With “ORA-65254: invalid path specified for the directory” on PDB Where PATH_PREFIX is set (文档 ID 2296226.1)
This issue has been raised in below unpublished bug :
Bug 26203745 - DATAPATCH FAILS WITH ORA-65254 ON PDB WHERE PATH_PREFIX IS CONFIGURED
Above bug was closed as duplicate of below unpublished bug:
Bug 25074866 - REMOVE USE OF DIRECTORY OBJECT FROM DBMS_SQLPATCH
解决方法:
打补丁25074866