最近查看alert日志,发现了ORA-600的报错,一看到600,整个神经都触碰了,立马上MOS查看是否有相同的问题
我的环境是solaris 10 sparc 64bit oracle 11.2.0.3,下面是报错信息
ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], []
MOS查看后发现这是一个oracle bug ,因为我们没有打PSU,所以原始版本11.2.0.3正好中招:
Bug 12919564 - ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace (文档 ID 12919564.8)
Affects:
MOS上给出了如下的处理方法:
我的环境是solaris 10 sparc 64bit oracle 11.2.0.3,下面是报错信息
ORA-00600: internal error code, arguments: [ktbesc_plugged], [], [], [], [], [], [], [], [], [], [], []
MOS查看后发现这是一个oracle bug ,因为我们没有打PSU,所以原始版本11.2.0.3正好中招:
Bug 12919564 - ORA-600 [ktbesc_plugged] executing SQL against a Plugged in (transported) tablespace (文档 ID 12919564.8)
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions >= 11.2.0.3 but BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
It is believed to be a regression in default behaviour thus:
Regression introduced in 11.2.0.3
Fixed:
后来我查看了报错的相关trace,发现是在对一个表进行插入的时候报错,原来这个表是我之前用传输表空间的方式迁移用户数据时的一个表,那么如何修复这个问题呢?
The fix for 12919564 is first included in
MOS上给出了如下的处理方法:
Workaround
If this is causing a lot of problems then you can set "_fastpin_enable"=0 to prevent the error but this may have a performance impact on some systems.
当我看到会对性能有影响,我就不敢在正式环境操作了(当然任何操作都需要在测试测试过后才能上正式环境),虽然可以打patch解决,但是如果要shutdown,那又是一件麻烦的事,所以临时的解决办法就是先把这个表在线迁走。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21560888/viewspace-1717010/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21560888/viewspace-1717010/