Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Saturday, June 21, 2008

Invalid ORDSYS types after 10g upgrade

An offshoot of the issue in DBUA which I reported in my previous post was invalid objects in ORDSYS schema. Two objects ORDAUDIO and ORDVIDEO were reported as invalid. Even after running catupgrd.sql manually, these did not get resolved. A search in metalink revealed bug 6830609:

DESCRIPTION
===========

When an initial attempt to upgrade intermedia from 9.2 to 10.2 fails, subsequent upgrade attempts will fail due to the ORDIMAGE, ORDAUDIO and ORDVIDEO types being invalid. Attempts to compile these types individually also fail.

DIAGNOSTIC ANALYSIS
===================

Could not duplicate the initial failure. After Catupgrd.sql completes interMedia is listed as invalid.

After running imchk.sql there are the following invalid interMedia objects.

ORDAUDIO Type Body INVALID

ORDIMAGE Type Body INVALID

ORDVIDEO Type Body INVALID


WORKAROUND
==========

Since intermedia was not used in this case, a drop and rebuild of the objects was sufficient.

Connected as a sysdba user:

drop type ordsys.ordaudio force;

drop type ordsys.ordvideo force;

drop type ordsys.ordimage force;

connect sys as sysdba

alter session set current_schema=ORDSYS;

@$ORACLE_HOME/ord/im/admin/iminst.sql

The above steps resolved those invalids.

No comments: