Chinaunix首页 | 论坛 | 博客

沧海拾贝brjl.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

brjl

  • 博客访问： 3693067
  • 博文数量： 715
  • 博客积分： 1860
  • 博客等级： 上尉
  • 技术积分： 7745
  • 用 户 组： 普通用户
  • 注册时间： 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文（715）

文章存档

2023年（75）

2022年（134）

2021年（238）

2020年（115）

2019年（11）

2018年（9）

2017年（9）

2016年（17）

2015年（7）

2014年（4）

2013年（1）

2012年（11）

2011年（27）

2010年（35）

2009年（11）

2008年（11）

我的朋友
最近访客
推荐博文
相关博文
ORA-20001 再一例 KUP-04020

分类： Oracle

2021-11-05 21:49:20

前一阵测试oracle 19.12补丁，没注意后台日志还报了个错

  1. 2021-09-13T07:50:09.558237-07:00
  2. Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
  3. ORA-06512: at "SYS.DBMS_QOPATCH", line 2327
  4. ORA-06512: at "SYS.DBMS_QOPATCH", line 854
  5. ORA-06512: at "SYS.DBMS_QOPATCH", line 937
  6. ORA-06510: PL/SQL: unhandled user-defined exception
  7. ORA-06512: at "SYS.DBMS_QOPATCH", line 932
  8. ORA-29913: error in executing ODCIEXTTABLEFETCH callout
  9. ORA-29400: data cartridge error
  10. KUP-04020: found record longer than buffer size supported, 8388608, in /u01/app/oracle/product/19.0.0/dbhome_1/QOpatch/qopiprep.bat (offset=0)
  11. ORA-06512: at "SYS.DBMS_QOPATCH", line 919
  12. ORA-06512: at "SYS.DBMS_QOPATCH", line 2286
  13. ORA-06512: at "SYS.DBMS_QOPATCH", line 817
  14. ORA-06512: at "SYS.DBMS_QOPATCH", line 2309

  16. ===========================================================
  17. Dumping current patch information
  18. ===========================================================
  19. Unable to obtain current patch information due to error: 20001
  20. ===========================================================

根据具体提示，好像跟xml格式的inventory信息有关，与上次看到的LANG=c导致的问题现象不一样，后来看官方文档（Doc ID 1948198.1）说是外部表 OPATCH_XML_INV 被损坏或不存在，需要做如下处理：

  1. SQL*Plus: Release 19.0.0.0.0 - Production on Fri Nov 5 06:31:16 2021
  2. Version 19.12.0.0.0

  4. Copyright (c) 1982, 2021, Oracle. All rights reserved.


  7. Connected to:
  8. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  9. Version 19.12.0.0.0

  11. sys@orcl:PRIMARY:38> select * from OPATCH_XML_INV;
  12. ERROR:
  13. ORA-29913: error in executing ODCIEXTTABLEFETCH callout
  14. ORA-29400: data cartridge error
  15. KUP-04020: found record longer than buffer size supported, 8388608, in /u01/app/oracle/product/19.0.0/dbhome_1/QOpatch/qopiprep.bat (offset=0)



  19. no rows selected

  21. sys@orcl:PRIMARY:38> desc SYS.OPATCH_XML_INV ;
  22.  Name Null? Type
  23.  ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
  24.  XML_INVENTORY CLOB

  26. sys@orcl:PRIMARY:38> drop table SYS.OPATCH_XML_INV;

  28. Table dropped.

  30. sys@orcl:PRIMARY:38> CREATE TABLE opatch_xml_inv
  31.   2 (
  32.   3 xml_inventory CLOB
  33.   4 )
  34.   5 ORGANIZATION EXTERNAL
  35.   6 (
  36.   7 TYPE oracle_loader
  37.   8 DEFAULT DIRECTORY opatch_script_dir
  38.   9 ACCESS PARAMETERS
  39.  10 (
  40.  11 RECORDS DELIMITED BY NEWLINE
  41.  12 READSIZE 67108864
  42.  13 preprocessor opatch_script_dir:'qopiprep.bat'
  43.  14 BADFILE opatch_script_dir:'qopatch_bad.bad'
  44.  15 LOGFILE opatch_log_dir:'qopatch_log.log'
  45.  16 FIELDS TERMINATED BY 'UIJSVTBOEIZBEFFQBL'
  46.  17 MISSING FIELD VALUES ARE NULL
  47.  18 REJECT ROWS WITH ALL NULL FIELDS
  48.  19 (
  49.  20 xml_inventory CHAR(100000000)
  50.  21 )
  51.  22 )
  52.  23 LOCATION(opatch_script_dir:'qopiprep.bat')
  53.  24 )
  54.  25 PARALLEL 1
  55.  26 REJECT LIMIT UNLIMITED;

  57. Table created.

  59. sys@orcl:PRIMARY:38> alter package sys.DBMS_QOPATCH compile body ;

  61. Package body altered.

  63. sys@orcl:PRIMARY:38> select owner, object_name,object_type,status FROM dba_objects where object_name in ('DBMS_QOPATCH' ,'OPATCH_XML_INV');

  65. OWNER
  66. --------------------
  67. OBJECT_NAME
  68. ------------------------------------------------------------------------------------------------------------------------------------------------------
  69. OBJECT_TYPE STATUS
  70. ---------------------------------------------- --------------
  71. SYS
  72. DBMS_QOPATCH
  73. PACKAGE VALID

  75. SYS
  76. DBMS_QOPATCH
  77. PACKAGE BODY VALID

  79. SYS
  80. OPATCH_XML_INV
  81. TABLE VALID


  84. sys@orcl:PRIMARY:38> col object_name for a32
  85. sys@orcl:PRIMARY:38> select comp_id, status, version from dba_registry;

  87. COMP_ID STATUS
  88. ------------------------------------------------------------ ----------------------------------------------------------------------------------------
  89. VERSION
  90. ------------------------------------------------------------
  91. CATALOG VALID
  92. 19.0.0.0.0

  94. CATPROC VALID
  95. 19.0.0.0.0

  97. RAC OPTION OFF
  98. 19.0.0.0.0

  100. JAVAVM VALID
  101. 19.0.0.0.0

  103. XML VALID
  104. 19.0.0.0.0

  106. CATJAVA VALID
  107. 19.0.0.0.0

  109. APS VALID
  110. 19.0.0.0.0

  112. XDB VALID
  113. 19.0.0.0.0

  115. OWM VALID
  116. 19.0.0.0.0

  118. CONTEXT VALID
  119. 19.0.0.0.0

  121. ORDIM VALID
  122. 19.0.0.0.0

  124. SDO VALID
  125. 19.0.0.0.0

  127. XOQ VALID
  128. 19.0.0.0.0

  130. OLS VALID
  131. 19.0.0.0.0

  133. DV VALID
  134. 19.0.0.0.0


  137. 15 rows selected.

  139. sys@orcl:PRIMARY:38> exit
  140. Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  141. Version 19.12.0.0.0
  142. [oracle@bjdb boot]$ env|grep HOME
  143. ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
  144. HOME=/home/oracle
  145. [oracle@bjdb boot]$ find /u01 -name datapatch*
  146. /u01/app/oracle/product/19.0.0/dbhome_1/OPatch_bak/datapatch
  147. /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/datapatch
  148. /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/datapatch.bat
  149. [oracle@bjdb boot]$ cd /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/
  150. [oracle@bjdb OPatch]$ ./datapatch
  151. SQL Patching tool version 19.12.0.0.0 Production on Fri Nov 5 06:33:17 2021
  152. Copyright (c) 2012, 2021, Oracle. All rights reserved.

  154. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3548_2021_11_05_06_33_17/sqlpatch_invocation.log

  156. Connecting to database...OK
  157. Gathering database info...done
  158. Bootstrapping registry and package to current versions...done
  159. Determining current state...done

  161. Current state of interim SQL patches:
  162. Interim patch 32876380 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)):
  163.   Binary registry: Installed
  164.   SQL registry: Not installed

  166. Current state of release update SQL patches:
  167.   Binary registry:
  168.     19.12.0.0.0 Release_Update 210716141810: Installed
  169.   SQL registry:
  170.     Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 13-SEP-21 07.05.02.955102 AM

  172. Adding patches to installation queue and performing prereq checks...done
  173. Installation queue:
  174.   No interim patches need to be rolled back
  175.   Patch 32904851 (Database Release Update : 19.12.0.0.210720 (32904851)):
  176.     Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.12.0.0.0 Release_Update 210716141810
  177.   The following interim patches will be applied:
  178.     32876380 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380))

  180. Installing patches...
  181. Patch installation complete. Total patches installed: 2

  183. Validating logfiles...done
  184. Patch 32904851 apply: SUCCESS
  185.   logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32904851/24343243/32904851_apply_ORCL_2021Nov05_06_34_24.log (no errors)
  186. Patch 32876380 apply: SUCCESS
  187.   logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32876380/24269510/32876380_apply_ORCL_2021Nov05_06_33_45.log (no errors)
  188. SQL Patching tool complete on Fri Nov 5 06:40:49 2021
再次重启实例，不再提示ORA-20001错误。
KUP-04020 这个报错说明是外部表相关的问题，类似的有ORA-  TNS- CRS- ，现在多见INS- ASM-opatch- 等开头的报错。
阅读(1910) | 评论(0) | 转发(0) |
0

上一篇：recover 状态的数据文件，怎么办？

下一篇：dbca 小插曲

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6