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