签到成功

知道了

CNDBA社区CNDBA社区

12c R2打补丁遇到的Bug 26203745

2017-12-19 15:21 4389 0 原创 Oracle 12C
作者: Expect-乐
#在打完补丁,做最后将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

http://www.cndba.cn/Expect-le/article/2502http://www.cndba.cn/Expect-le/article/2502http://www.cndba.cn/Expect-le/article/2502

MOS文档:

http://www.cndba.cn/Expect-le/article/2502

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

解决方法
patch 25074866

http://www.cndba.cn/Expect-le/article/2502

http://www.cndba.cn/Expect-le/article/2502

http://www.cndba.cn/Expect-le/article/2502http://www.cndba.cn/Expect-le/article/2502

http://www.cndba.cn/Expect-le/article/2502
http://www.cndba.cn/Expect-le/article/2502

版权声明:本文为博主原创文章,未经博主允许不得转载。

Bug 26203745

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
Expect-乐

Expect-乐

关注

Without the continuous bitter cold, there can be no fragrant plum blossom

  • 336
    原创
  • 6
    翻译
  • 100
    转载
  • 41
    评论
  • 访问:1601964次
  • 积分:1957
  • 等级:核心会员
  • 排名:第4名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ