Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Oracle 10.2.0.3 -> 10.2.0.4 upgrade: "ERRORS DURING RECOMPILATION"

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    I did the upgrade and applied the patch, but I got this error when I run the utlrp.sql
    Right now everything is up and running.
    Should I worry?
    "OBJECTS WITH ERRORS
    -------------------
    1
    1 row selected.
    DOC> The following query reports the number of errors caught during
    DOC> recompilation. If this number is non-zero, please query the error
    DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
    DOC> are due to misconfiguration or resource constraints that must be
    DOC> fixed before objects can compile successfully.
    DOC>#

    ERRORS DURING RECOMPILATION
    ---------------------------
    0
    1 row selected.
    PL/SQL procedure successfully completed.”

    I did
    idle> select obj#,owner#,name, namespace, type#,status from obj$ where status=3;
    OBJ# OWNER# NAME NAMESPACE TYPE# STATUS
    ---------- ---------- -------------------- ---------- ---------- ----------
    46115 46 SDO_3GL 2 11 3
    1 row selected.

    Does it mean that the package name is SDO_3GL and I have to run the sql?

    Sql>alter package schemaname.packagename compile;

    [Later:]

    this is what I tried and the messages that I got.
    1.
    idle> select owner, object_type, object_name from dba_objects where status <> 'VALID';
    OWNER OBJECT_TYPE OBJECT_NAME
    ------------------------------ ------------------- ------------------------------
    MDSYS PACKAGE BODY SDO_3GL

    2.
    idle> alter package MDSYS.SDO_3GL compile;
    Warning: Package altered with compilation errors.
    3.

    idle> alter package MDSYS.SDO_3GL compile body;
    Warning: Package Body altered with compilation errors.



    [Later:]

    aleph_admin@ALEPH18> aleph_admin@ALEPH18> connect mdsys/mdsys Connected.
    aleph_admin@ALEPH18> select name,text from user_errors;
    NAME TEXT
    SDO_3GL PLS-00302: component 'CONVERT_DISTANCE' must be declared
    SDO_3GL PLS-00302: component 'CONVERT_DISTANCE' must be declared
    SDO_3GL PLS-00302: component 'EXPAND_MULTI_POINT' must be declared

    Resolution:
    Ex Libris response: Failure in compilation of MDSYS.SDO_3GL can be ignored as it is not used.


    • Article last edited: 10/8/2013