ORA-6509, ORA-6512. RAN CATALOG.SQL AND CATPROC.SQL AS NON-SYS USER (Doc ID 1015902.4)

Last updated on DECEMBER 11, 2023

Applies to:

Symptoms

Problem Description:
====================

After having run CATALOG.SQL and CATPROC.SQL in a schema other than
SYS you may experience problems.  You may find invalid packages that
do not compile, or other inconsistencies in the database. 

You may also receive the following error when trying to run a script
from SQL*Plus:

    ORA-06509 "PL/SQL: ICD VECTOR MISSING FOR THIS PACKAGE" 
    ORA-06512  "Error accessing package DBMS_APPLICATION_INFO"

These errors don't occur if you log on as SYS.  
 
You may need to install the Oracle Procedural option. 
SET APPINFO requires Oracle Server Release 7.2 or later. 
 
You have tried the following with no success: 
 
    1. Reran CATPROC.SQL. 
    2. Reran DBMSUTIL.SQL. 
    3. ALTER PACKAGE DBMS_APPLICATION_INFO COMPILE. 
    4. Relinked procedural option (mk -f ins_rdbms.mk procopt)  
       and install (mk -f ins_rdbms.mk install). 
 
For the purpose of this article it is assumed that CATALOG.SQL
and CATPROC.SQL have been run as SYSTEM, although the same symptoms
would occur if they had been run in another schema.

Changes

Cause