My Oracle Support Banner

ORA-00600: [kzxcInitLoadLocal-7], [942] (Doc ID 1481624.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Procedure "SYS.DBMS_NETWORK_ACL_ADMIN.CREATE_ACL". fails with ORA-00600: internal error code, arguments: [kzxcInitLoadLocal-7], [942],

Sample pl/sql code is as provided below:

BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl         => 'ACL_OERP.xml',
                                   description => 'OERP APPLICATION ACL ',
                                      principal   => 'OERPPMP',
                                      is_grant    => true,
                                      privilege   => 'connect',
                                      start_date  => null,
                                      end_date    => null );
    COMMIT;
  END;
 /

BEGIN
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzxcInitLoadLocal-7], [942],
[ORA-00942: table or view does not exist]

Changes

 This error could occur sometimes due to database upgrade or migration. but main reason is Table XDB.XS$SECURITYCLASS does not exist

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 Method #1 - run xsdbmig
 
Method #2 - run xdbrelod
 Method #3 - run catqm
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.