This content has been marked as final. Show 5 replies
There can be a variety of reasons for this, and it would be difficult to diagnose in a discussion forum.
I strongly suggest that you initiate a service ticket through Oracle support.
Thank you for your reply.
I actually have started a SR with Oracle support. I just thought maybe someone would have had the same problem. Let's see who can figure it out first :)
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