10.2.0.5.1 PSU patchset会损坏Message File
客户的库，alert日志中全是
ORA-12012: Message 12012 not found; No message file for product=RDBMS, facility=ORA; arguments: [3]
ORA-06502: Message 6502 not found; No message file for product=RDBMS, facility=ORA; arguments: [: character string buffer too small]
ORA-06512: Message 6512 not found; No message file for product=RDBMS, facility=ORA; arguments: ["JWZH_NJ_ZSB.PKG_WG", ] [1441]
这样的报错，感觉是msg文件出问题了
查了下MOS：
AIX: Corrupt Message File After Applying The 10.2.0.5.1 PSU patchset [ID 1272715.1]
Bug 10235783 - AIX: "no message file for product=rdbms" after installing PSU 10.2.0.5.1 on AIX [ID 10235783.8]
No message file for product=RDBMS after applying 10.2.0.5.1 PSU on AIX [ID 1266321.1]
No message file for product=RDBMS,facility=ORA after upgrade to 10.2.0.5.1 [ID 1281786.1]
用diff对比下
diff $ORACLE_HOME/rdbms/mesg/oraus.msb $ORACLE_HOME/.patch_storage/9952230_Aug_16_2010_22_10_35/backup/rdbms/mesg/oraus.msb
diff $ORACLE_HOME/rdbms/mesg/oraus.msg $ORACLE_HOME/.patch_storage/9952230_Aug_16_2010_22_10_35/backup/rdbms/mesg/oraus.msg
果然不同。
Patch 10235783: NO MESSAGE FILE FOR PRODUCT=RDBMS AFTER OCT 2010 PSU PATCH APPLICATION
ORA-12012: Message 12012 not found; No message file for product=RDBMS, facility=ORA; arguments: [3]
ORA-06502: Message 6502 not found; No message file for product=RDBMS, facility=ORA; arguments: [: character string buffer too small]
ORA-06512: Message 6512 not found; No message file for product=RDBMS, facility=ORA; arguments: ["JWZH_NJ_ZSB.PKG_WG", ] [1441]
这样的报错，感觉是msg文件出问题了
查了下MOS：
AIX: Corrupt Message File After Applying The 10.2.0.5.1 PSU patchset [ID 1272715.1]
Bug 10235783 - AIX: "no message file for product=rdbms" after installing PSU 10.2.0.5.1 on AIX [ID 10235783.8]
No message file for product=RDBMS after applying 10.2.0.5.1 PSU on AIX [ID 1266321.1]
No message file for product=RDBMS,facility=ORA after upgrade to 10.2.0.5.1 [ID 1281786.1]
用diff对比下
diff $ORACLE_HOME/rdbms/mesg/oraus.msb $ORACLE_HOME/.patch_storage/9952230_Aug_16_2010_22_10_35/backup/rdbms/mesg/oraus.msb
diff $ORACLE_HOME/rdbms/mesg/oraus.msg $ORACLE_HOME/.patch_storage/9952230_Aug_16_2010_22_10_35/backup/rdbms/mesg/oraus.msg
果然不同。
Patch 10235783: NO MESSAGE FILE FOR PRODUCT=RDBMS AFTER OCT 2010 PSU PATCH APPLICATION
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8242091/viewspace-697455/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
