Installing Oracle Multimedia on 11g

   Send article as PDF   

Installing Oracle Multimedia, which is required for Spatial and/or Locator is quite simple.

All of the following must be carried out while logged in as a SYSDBA user.

SQL> spool ordinst.log
SQL> @?/ord/admin/ordinst SYSAUX SYSAUX
...
...
SQL> spool off

SQL> spool catim.log
SQL> @?/ord/im/admin/catim
...
...
SQL> spool off

Lots of stuff will scroll up the screen but will also be copied to the spool files named. Check those for obvious errors, then check to see if it worked as follows:

SQL> select comp_id, version, status
  2  from dba_registry
  3  where comp_id = 'ORDIM';

COMP_ID    VERSION        STATUS
---------- ----------     ---------
ORDIM      11.2.0.3.0     VALID

You can also force check the validity as follows, should you ever need to:

SQL> set serveroutput on

SQL> execute sys.validate_ordim;
PL/SQL procedure successfully completed.

If there are any invalid objects in the ORDIM component, the above procedure will display a message about them and set the status column in the DBA_REGISTRY to INVALID. You should check the status after running the above.

One thought on “Installing Oracle Multimedia on 11g”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.