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
