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
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:
Post a Comment