1.查看600错误的trc文件如下:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17069], [0x700000979A47E38], [], [], [], [], [], []
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
ORA-00928: missing SELECT keyword
Current SQL statement for this session:
ALTER VIEW "DB_YW"."V_FIRST" COMPILE
O/S info: user: lenovo4876, term: LENOVO, ospid: 4508:332, machine: WORKGROUP\LENOVO
program: plsqldev.exe
client info: 192.168.1.5
2.通过metalink搜索,发现符合以下ORA-00600 17069的描述:
DESCRIPTION:
Failed to pin a library cache object after 50 attempts.
ARGUMENTS:
Arg [a] Library Cache Object Handle.
FUNCTIONALITY:
GENERIC LAYER
IMPACT:
PROCESS FAILURE
NO DATA CORRUPTION
3.检查被锁定对象,发现视图DB_YW.V_FIRST涉及到的表一直有被中间件锁定:
SQL> select session_id,oracle_username,os_user_name,d.object_name from v$locked_object l,dba_objects d
2 where l.OBJECT_ID=d.object_id and d.object_name in ('T_ZS_YZMX','T_DM_GY_ZSXM','T_DM_GY_ZSPM','V_KT_DWJFDJXX_ZLTEST','T_SB_YZPZ','V_SEC');
SESSION_ID ORACLE_USERNAME OS_USER_NAME OBJECT_NAME
---------- ------------------------------ ------------------------------ --------------------------------------------------------------------------------
2578 DB_ZGXT weblogic T_ZS_YZMX
2578 DB_ZGXT weblogic T_SB_YZPZ
2578 DB_ZGXT weblogic T_ZS_YZMX
2578 DB_ZGXT weblogic T_DM_GY_ZSPM
2578 DB_ZGXT weblogic T_SB_YZPZ
890 DB_ZGXT weblogic T_ZS_YZMX
890 DB_ZGXT weblogic T_SB_YZPZ
890 DB_ZGXT weblogic T_DM_GY_ZSPM
890 DB_ZGXT weblogic T_SB_YZPZ
890 DB_ZGXT weblogic T_ZS_YZMX
4.通过与IP为192.168.1.5的开发人员沟通,得知整个事情的经过。该开发人员执行SQL语句中包含或触发以下编译语句:
ALTER VIEW "DB_YW"."V_FIRST" COMPILE
而同时由于视图DB_TUNNING.V_FIRST中包含对象一直被中间件锁定,导致编译语句锁定内存对象失败50次以上,从而导致
ORA-00600 17069错误。已和该开发人员联系,建议其在非工作时间运行该语句。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29468144/viewspace-1076716/
,如需转载,请注明出处,否则将追究法律责任。