英文:
Oracle Please look into PDB_PLUG_IN_VIOLATIONS view for more details
问题
在创建Oracle 19.16数据库中的一个PDB时，我在日志中收到一个警告：
TEST_DB(4):警告：可插入数据库TEST_DB的pdb id - 4已发生错误或警告。请查看PDB_PLUG_IN_VIOLATIONS视图以获取更多详细信息。
由于执行"select * from PDB_PLUG_IN_VIOLATIONS"查询，我得到以下结果：
OPTION WARNING 0 1 数据库选项JAVAVM不匹配：PDB安装版本为空。CDB安装版本为19.0.0.0.0。已解决 在PDB或CDB中修复数据库选项 7
OPTION WARNING 0 1 数据库选项JAVAVM不匹配：PDB安装版本为空。CDB安装版本为19.0.0.0.0。挂起 在PDB或CDB中修复数据库选项 2
OPTION WARNING 0 1 数据库选项JAVAVM不匹配：PDB安装版本为空。CDB安装版本为19.0.0.0.0。挂起 在PDB或CDB中修复数据库选项 5
OPTION WARNING 0 1 数据库选项JAVAVM不匹配：PDB安装版本为空。CDB安装版本为19.0.0.0.0。挂起 在PDB或CDB中修复数据库选项 3
OPTION WARNING 0 1 数据库选项JAVAVM不匹配：PDB安装版本为空。CDB安装版本为19.0.0.0.0。挂起 在PDB或CDB中修复数据库选项 6
OPTION ERROR 0 2 数据库选项CATJAVA不匹配：PDB安装版本为19.0.0.0.0。CDB安装版本为空。挂起 在PDB或CDB中修复数据库选项 7
OPTION ERROR 0 3 数据库选项XML不匹配：PDB安装版本为19.0.0.0.0。CDB安装版本为空。挂起 在PDB或CDB中修复数据库选项 7
OPTION WARNING 0 1 数据库选项JAVAVM不匹配：PDB安装版本为空。CDB安装版本为19.0.0.0.0。挂起 在PDB或CDB中修复数据库选项 4
我没有找到如何处理这个警告的答案。在CDB上，JavaVM和XML选项确实是活动的。
告诉我如何删除这些警告？（我是否应该关注它们？）
我不需要在所有可插入数据库上指定的选项。
英文:
When creating a PDB in an Oracle 19.16 database, I get a warning in the logs:
TEST_DB(4):WARNING: Pluggable Database TEST_DB with pdb id - 4 is
TEST_DB(4): altered with errors or warnings. Please look into
TEST_DB(4): PDB_PLUG_IN_VIOLATIONS view for more details.
As a result of the select * from PDB_PLUG_IN_VIOLATIONS query, I get:
OPTION WARNING 0 1 Database option JAVAVM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. RESOLVED Fix the database option in the PDB or the CDB 7
OPTION WARNING 0 1 Database option JAVAVM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. PENDING Fix the database option in the PDB or the CDB 2
OPTION WARNING 0 1 Database option JAVAVM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. PENDING Fix the database option in the PDB or the CDB 5
OPTION WARNING 0 1 Database option JAVAVM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. PENDING Fix the database option in the PDB or the CDB 3
OPTION WARNING 0 1 Database option JAVAVM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. PENDING Fix the database option in the PDB or the CDB 6
OPTION ERROR 0 2 Database option CATJAVA mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL. PENDING Fix the database option in the PDB or the CDB 7
OPTION ERROR 0 3 Database option XML mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL. PENDING Fix the database option in the PDB or the CDB 7
OPTION WARNING 0 1 Database option JAVAVM mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0. PENDING Fix the database option in the PDB or the CDB 4
I did not find an answer to the question of what to do with this warning. On the СDB, JavaVM, XML options are really active.
Tell me how to remove these warnings? (Should I pay attention to them?).
I do not need the specified options on all pluggable databases.
答案1
得分: 1
根据MOS注释2020172.1：
允许PDB安装的选项比其插入的CDB少
对于这种情况，您仍然会在PDB_PLUG_IN_VIOLATIONS中收到警告消息，但可以忽略它。
然而，错误条目则不同，因为这看起来像是在PDB中安装了CDB中没有的选项。您需要在CDB中安装这些选项才能解决这些问题。
英文:
As per MOS note 2020172.1
It is okay for a PDB to have a subset (fewer) options installed than the CDB into which it is plugged
for which you still get a WARNING message in PDB_PLUG_IN_VIOLATIONS, but its OK to ignore it.
However, ERROR entries are different, because that looks like you have options installed in the PDB that are not present in the CDB. You'd need to install those options in the CDB to get these resolved.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论