interMedia ORDSYS Objects Invalid In The SYS Schema After Upgrade When ORDSYS Schema Does Not Exist
Last updated on JANUARY 09, 2013
Applies to:Oracle Multimedia - Version 10.2.0.3 and later
Information in this document applies to any platform.
After upgrading from a previous version to 10.2, there may be invalid (and valid) objects in the SYS schema that do not belong there. ORD% objects belong in the ORDSYS schema, which is the designated schema which contains the objects for interMedia.
select owner, object_name from dba_objects where owner='SYS' and status='INVALID' and object_name like 'ORD%';
Review the upgrade log files for alter session statements failing, but subsequent create object statements succeeding. For example:
SQL> alter session set current_schema="ORDSYS";
ORA-01435: user does not exist
SQL> REM Create Libraries
SQL> create or replace library ORDIMLIBS as 'e:\h\COTS\Oracle\Ora102\bin\oraordim10.dll';
..... and so on
An upgrade or patch was recently applied to the DB.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms