ORA-00600 [qccprg:ocistmtprepare2] on SYS.DBMS_CDC_PUBLISH (Doc ID 2048832.1)

Last updated on APRIL 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Database instance encountered the below error

Thu Jul 16 15:56:32 2015
Errors in file /u01/app/oracle/diag/rdbms/ape1dv/ape1dv2/trace/ape1dv2_j000_3611.trc (incident=132625):
ORA-00600: internal error code, arguments: [qccprg:ocistmtprepare2], [1031], [ORA-01031: insufficient privileges
], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/ape1dv/ape1dv2/incident/incdir_132625/ape1dv2_j000_3611_i132625.trc

Incident trace shows the below issue in executing SYS.DBMS_CDC_PUBLISH package



DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TIME ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2(30) := :job_name;  job_subname VARCHAR2(30) := :job_subname;  job_owner VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH TIME ZONE := :job_start;  job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start;  window_start TIMESTAMP WITH TIME ZONE := :window_start;  window_end TIMESTAMP WITH TIME ZONE := :window_end;  chain_id VARCHAR2(14) :=  :chainid;  credential_owner varchar2(30) := :credown;  credential_name  varchar2(30) := :crednam;  destination_owner varchar2(30) := :destown;  destination_name varchar2(30) := :destnam;  job_dest_id varchar2(14) := :jdestid;  log_id number := :log_id;  BEGIN  SYS.DBMS_CDC_PUBLISH.PURGE();  :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object      line  object
handle    number  name
11563d07a8       843  package body SYS.DBMS_CDC_PUBLISH
11470cfc70         1  anonymous block

 

Call Stack

..............

 

[00]: dbgexProcessError [diag_dde]
[01]: dbgePostErrorKGE [diag_dde]
[02]: dbkePostKGE_kgsf [rdbms_dde]
[03]: kgerinv_internal []
[04]: kgerinv []
[05]: kgesinv []
[06]: ksesin [KSE]
[07]: OCIKSIN []<-- Signaling
[08]: qccprg_purgeSplitAndDropPartiti []
[09]: qccprg_physicalPurgeTable []
[10]: qccprg_purgeChangeSet []
[11]: qccprg_purgeAllSets []
[12]: qccpub_purgeEP []
[13]: spefcmpa []
[14]: spefmccallstd []
[15]: peftrusted [PLSQL_External_Proc]

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms