ORA-20001: Latest xml inventory is not loaded into table

刘泽宇

场景：19.24的数据库软件，但是上面的备库与19.3版本的主库进行同步
操作：将备库激活，并从19.3升级到19.24

由于数据库软件已经是19.24，所以只需要执行命令：
cd $ORACLE_HOME/OPatch
./datapatch -verbose


结果执行报错：
2024-08-08T10:54:33.165022+08: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-04095: preprocessor command /u01/app/oracle/product/19.0.0/db_1/QOpatch/qopiprep.bat encountered error "locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Can"
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


查找官方文档，显示问题是：
$ locale LC_CTYPE | head
If you do not see ISO-8859-15 listed in the output, that means the ISO-8859-15 Locale is not installed.
Refer to KM article - The Correct NLS_LANG Setting in Unix Environments (Doc ID 264157.1) to determine the correct Locales installed.

也就是操作系统上面缺少语言包
检查发现操作系统确实只有中文

解决办法：yum install glibc-langpack-en
安装再次执行，无报错，升级成功