ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600:[qcsgpvc3], [], [], [], [], [], [], []

ORA-00600:[qcsgpvc3], [], [], [], [], [], [], []

原创 Linux操作系统 作者:jimmy13202 时间:2011-06-24 08:49:14 0 删除 编辑
SCENARIO:
In the alert*.log:
Errors in file /orabin/product/admin/whtsdb/udump/whtsdb_ora_20994.trc:
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

In the /orabin/product/admin/whtsdb/udump/whtsdb_ora_20994.trc:
Unix process pid: 20994, image: oracle@cim12web0

*** ACTION NAME:() 2010-09-13 11:12:30.640
*** MODULE NAME:(SQLTools.exe) 2010-09-13 11:12:30.640
*** SERVICE NAME:(whtsdb) 2010-09-13 11:12:30.640
*** SESSION ID:(197.9086) 2010-09-13 11:12:30.640
*** 2010-09-13 11:12:30.640
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

Query the session:
SQL> select sid,serial#,username,machine from v$session
  2> where sid = 197;

       SID    SERIAL# USERNAME                        MACHINE
———-     ———-  ——————————  ————————–
      197       9086   TP01                               SMIC-WH\12ITE00330

ROOT CAUSE:
The development user has complied a procedure, but by mistake he wrote the table’s column name wrong to "V_PCTIME" which is the 

procedure’s argument name rather than "PCTIME" when building the procedure:
Procedure GET_PWPH_AMAT_REFLEXION_LK (V_STARTDATE IN VARCHAR2, V_ENDDATE IN VARCHAR2)
  IS
      V_PROCESSTIME          NUMBER; 
      V_NITTTIME           NUMBER;  
      V_PNTIME             NUMBER; 
      V_UNITNO               VARCHAR2 (10);
      V_UNITNAME           VARCHAR2(60);     
      V_BEGINTIME          VARCHAR2(8);
      V_CONDITIONTIME      NUMBER;  
      V_PCTIME             NUMBER;  
  BEGIN
……
    INSERT INTO SDB_TB_PWPH_AMAT_REFLEXION_LK (HISTDATE,FAB,EQPID,RECIPE,UNITNO,UNITNAME,NITTTIME,V_PCTIME,PWPH,SAMPLE)
       VALUES (V_ENDDATE,CF_REC.FABID,CF_REC.EQPID,CF_REC.RECIPE,V_UNITNO,V_UNITNAME,V_NITTTIME,V_PCTIME,ROUND(3600/

(V_PCTIME+V_NITTTIME),5),CF_REC.SAMPLE);
……
  END;
/

REFERENCE:
Bug 7172752 – OERI[qcsgpvc3] recompiling a package body [ID 7172752

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

请登录后发表评论 登录
全部评论

注册时间:2010-06-26

最新文章