lang=c 引发的 ora-凯发app官方网站

新装的库，启动时报错了
startup没问题，看了一眼alert.log，居然有错误：

2021-02-08t11:17:48.862582 08:00
starting background process cjq0
completed: alter database open
2021-02-08t11:17:48.883131 08:00
cjq0 started with pid=46, os id=15821
2021-02-08t11:17:50.046058 08:00
qpi: opatch file present, opatch
qpi: qopiprep.bat file present
2021-02-08t11:17:55.073785 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 /home/ora/product/19.3.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
这是什么？

一开始以为是业务用户有外部表没导入过来导致的，查了查数据库中没有lc_ctype这个对象。

提示的 dbms_qopatch 看着跟oracle的补丁有关系，这套环境是模板克隆出来的，不应该有什么“问题”，有的文章说是inventory需要重建，那就检查一下，试着执行了一下opatch lspatches 没报错，执行opatch lsinv 有些异常，连蒙带猜将lang=c，然后重启库alert.log就不报错了。

这个模板上不知为何将lang=c，其实如果linux知识比较全面的话，一眼就应该看明白问题所在了。

参考：
queryable patch inventory - issues/solutions for ora-20001: latest xml inventory is not loaded into table (doc id 1602089.1)
https://www.cnblogs.com/badboy200800/p/11215981.html

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

上一篇：ora-00600 [kfrvalacd30]

下一篇：需要恶补一下asm元数据知识

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

| | | | |

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