This content has been marked as final. Show 5 replies
This one is from left field, but I have seen it happen many times before, especially when a database has been copied.
Run this statement:
select library_name,file_spec from dba_libraries where file_spec is not null;
and check that the file_spec for the libraries points to the correct ORACLE_HOME. If its not right you will need to recreate the library definition.
Well, since none of the above mentioned actions fixed the problem, Oracle Support finally suggested that I set the registry entry back to 10.2.0.3 and then redo the Oracle Multimedia Upgrade. I did the following steps and this took care of the problem:
- connect sys as sysdba
- update registry$ set version='10.2.0.3' where cid='ORDIM';
- shutdown immediate
- startup migrate