ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []处理

上周五快下班的时候，同事接到某公司错误日志如下：

通过PL/SQL Devloper连接61.131.*.*数据库，以IIOSV用户登录，执行以下SQL语言：

Connected to Oracle9i Enterprise Edition Release 9.2.0.8.0
Connected as iiosv

SQL> alter table IIOSV.USER_VPDN_LNS disable constraint FK_USER_VPDN_LNS

ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []

SQL> INSERT INTO IIOSV.USER_VPDN_AUTH SELECT * FROM IIOSP.USER_VPDN_AUTH@DB197

ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

SQL> INSERT INTO IIOSV.USER_VPDN_DETAIL SELECT * FROM IIOSP.USER_VPDN_DETAIL@DB197

ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []

SQL> INSERT INTO IIOSV.USER_VPDN_MAC SELECT * FROM IIOSP.USER_VPDN_MAC@DB197

ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []

SQL> INSERT INTO IIOSV.USER_VPDN_TELEPHONE SELECT * FROM IIOSP.USER_VPDN_TELEPHONE@DB197

ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []

SQL> INSERT INTO IIOSV.USER_VPDN_VLANID
SELECT USER_ID, DOMAIN_NAME, NAS_IP, SLOT, PORT, START_VLAN, STOP_VLAN, LIMIT_MODE, LIMIT_DIR, NULL, NULL FROM IIOSP.USER_VPDN_VLANID@DB197

ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []

SQL> INSERT INTO IIOSV.USER_VPDN_VPIVCI SELECT * FROM IIOSP.USER_VPDN_VPIVCI@DB197

ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

SQL> alter table IIOSV.USER_VPDN_LNS enable constraint FK_USER_VPDN_LNS

ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []

SQL> alter table IIOSV.USER_VPDN_MAC enable constraint FK_USER_VPDN_MAC

ORA-00600: internal error code, arguments: [ktsxaffs1], [], [], [], [], [], [], []

经分析，是undo_retention值设得过大，建议其减小该值。周六上午见到同事，说确实如此。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35686/viewspace-984918/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35686/viewspace-984918/