Sunday, February 5, 2012

Oracle Multimedia invalid after upgrade from 10.2.0.4 to 11.2.0.3

Oracle Multimedia  invalid after upgrade from 10.2.0.4 to 11.2.0.3

fix:

sqlplus / as sysdba

startup upgrade
/*replace the version 10.2.0.4 in the dbms_registry.loaded
command with the version from which the database has been upgraded
*/

EXECUTE dbms_registry.loaded('ORDIM','10.2.0.4');

spool Oracle_Multimedia.log

@<Oracle_11g_Home>/ord/im/admin/imdbmig.sql 

shutdown immediate

startup
?/rdbms/admin/utlrp.sql

check now status should be valid

No comments: