ora-凯发app官方网站

2021-09-13t07:50:09.558237-07:00
unable to obtain current patch information due to error: 20001, ora-20001: latest xml inventory is not loaded into table
ora-06512: at "sys.dbms_qopatch", line 2327
ora-06512: at "sys.dbms_qopatch", line 854
ora-06512: at "sys.dbms_qopatch", line 937
ora-06510: pl/sql: unhandled user-defined exception
ora-06512: at "sys.dbms_qopatch", line 932
ora-29913: error in executing odciexttablefetch callout
ora-29400: data cartridge error
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)
ora-06512: at "sys.dbms_qopatch", line 919
ora-06512: at "sys.dbms_qopatch", line 2286
ora-06512: at "sys.dbms_qopatch", line 817
ora-06512: at "sys.dbms_qopatch", line 2309
===========================================================
dumping current patch information
===========================================================
unable to obtain current patch information due to error: 20001
===========================================================

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

sql*plus: release 19.0.0.0.0 - production on fri nov 5 06:31:16 2021
version 19.12.0.0.0
connected to:
oracle database 19c enterprise edition release 19.0.0.0.0 - production
version 19.12.0.0.0
sys@orcl:primary:38> select * from opatch_xml_inv;
error:
ora-29913: error in executing odciexttablefetch callout
ora-29400: data cartridge error
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)
no rows selected
sys@orcl:primary:38> desc sys.opatch_xml_inv ;
name null? type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
xml_inventory clob
sys@orcl:primary:38> drop table sys.opatch_xml_inv;
table dropped.
sys@orcl:primary:38> create table opatch_xml_inv
2 (
3 xml_inventory clob
4 )
5 organization external
6 (
7 type oracle_loader
8 default directory opatch_script_dir
9 access parameters
10 (
11 records delimited by newline
12 readsize 67108864
13 preprocessor opatch_script_dir:'qopiprep.bat'
14 badfile opatch_script_dir:'qopatch_bad.bad'
15 logfile opatch_log_dir:'qopatch_log.log'
16 fields terminated by 'uijsvtboeizbeffqbl'
17 missing field values are null
18 reject rows with all null fields
19 (
20 xml_inventory char(100000000)
21 )
22 )
23 location(opatch_script_dir:'qopiprep.bat')
24 )
25 parallel 1
26 reject limit unlimited;
table created.
sys@orcl:primary:38> alter package sys.dbms_qopatch compile body ;
package body altered.
sys@orcl:primary:38> select owner, object_name,object_type,status from dba_objects where object_name in ('dbms_qopatch' ,'opatch_xml_inv');
owner
--------------------
object_name
------------------------------------------------------------------------------------------------------------------------------------------------------
object_type status
---------------------------------------------- --------------
sys
dbms_qopatch
package valid
sys
dbms_qopatch
package body valid
sys
opatch_xml_inv
table valid
sys@orcl:primary:38> col object_name for a32
sys@orcl:primary:38> select comp_id, status, version from dba_registry;
comp_id status
------------------------------------------------------------ ----------------------------------------------------------------------------------------
version
------------------------------------------------------------
catalog valid
19.0.0.0.0
catproc valid
19.0.0.0.0
rac option off
19.0.0.0.0
javavm valid
19.0.0.0.0
xml valid
19.0.0.0.0
catjava valid
19.0.0.0.0
aps valid
19.0.0.0.0
xdb valid
19.0.0.0.0
owm valid
19.0.0.0.0
context valid
19.0.0.0.0
ordim valid
19.0.0.0.0
sdo valid
19.0.0.0.0
xoq valid
19.0.0.0.0
ols valid
19.0.0.0.0
dv valid
19.0.0.0.0
15 rows selected.
sys@orcl:primary:38> exit
disconnected from oracle database 19c enterprise edition release 19.0.0.0.0 - production
version 19.12.0.0.0
[oracle@bjdb boot]$ env|grep home
oracle_home=/u01/app/oracle/product/19.0.0/dbhome_1
home=/home/oracle
[oracle@bjdb boot]$ find /u01 -name datapatch*
/u01/app/oracle/product/19.0.0/dbhome_1/opatch_bak/datapatch
/u01/app/oracle/product/19.0.0/dbhome_1/opatch/datapatch
/u01/app/oracle/product/19.0.0/dbhome_1/opatch/datapatch.bat
[oracle@bjdb boot]$ cd /u01/app/oracle/product/19.0.0/dbhome_1/opatch/
[oracle@bjdb opatch]$ ./datapatch
sql patching tool version 19.12.0.0.0 production on fri nov 5 06:33:17 2021
log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3548_2021_11_05_06_33_17/sqlpatch_invocation.log
connecting to database...ok
gathering database info...done
bootstrapping registry and package to current versions...done
determining current state...done
current state of interim sql patches:
interim patch 32876380 (ojvm release update: 19.12.0.0.210720 (32876380)):
binary registry: installed
sql registry: not installed
current state of release update sql patches:
binary registry:
19.12.0.0.0 release_update 210716141810: installed
sql registry:
applied 19.3.0.0.0 release_update 190410122720 successfully on 13-sep-21 07.05.02.955102 am
adding patches to installation queue and performing prereq checks...done
installation queue:
no interim patches need to be rolled back
patch 32904851 (database release update : 19.12.0.0.210720 (32904851)):
apply from 19.3.0.0.0 release_update 190410122720 to 19.12.0.0.0 release_update 210716141810
the following interim patches will be applied:
32876380 (ojvm release update: 19.12.0.0.210720 (32876380))
installing patches...
patch installation complete. total patches installed: 2
validating logfiles...done
patch 32904851 apply: success
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32904851/24343243/32904851_apply_orcl_2021nov05_06_34_24.log (no errors)
patch 32876380 apply: success
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32876380/24269510/32876380_apply_orcl_2021nov05_06_33_45.log (no errors)
sql patching tool complete on fri nov 5 06:40:49 2021

再次重启实例，不再提示ora-20001错误。
kup-04020 这个报错说明是外部表相关的问题，类似的有ora- tns- crs- ，现在多见ins- asm-opatch- 等开头的报错。

阅读(1411) | 评论(0) | 转发(0) |

给主人留下些什么吧！~~

| | | | |

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