12c R2打补丁遇到的Bug 26203745

在打完补丁,做最后将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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值