B Installing and Upgrading Oracle interMedia

This appendix describes the manual installation of Oracle interMedia ("interMedia") (see Section B.1) as well as the manual upgrading of an installed version of Oracle interMedia (see Section B.2).


See the interMedia README.txt file located in <ORACLE_HOME>/ord/im/admin for the latest information.

B.1 Installing Oracle interMedia

Oracle interMedia is installed and configured with Oracle Database. If, for some reason, you need to install interMedia manually, you can follow the instructions in this section, according to the following topics:

  • Installation decisions

  • Preinstallation steps

  • Installation steps

B.1.1 Installation Decisions

The installation procedure creates the ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, and MDSYS users. These user IDs are the standard Oracle Database account with special privileges.

Decision: Decide which tablespace to use for interMedia users (ORDSYS, ORDPLUGINS, and SI_INFORMTN_SCHEMA), and which tablespace to use for the Spatial/interMedia Location Services user (MDSYS). Oracle suggests you use the SYSAUX tablespace for both.

Decision: Decide on passwords for the ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, and MDSYS users. The installation uses default passwords for ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, and MDSYS. Then, it locks the accounts and expires the passwords. You must change these passwords and unlock the accounts after the installation completes if you want to log in to these accounts directly.

The default password for the ORDSYS user during automatic installation is ORDSYS, for ORDPLUGINS is ORDPLUGINS, for SI_INFORMTN_SCHEMA is SI_INFORMTN_SCHEMA, and for MDSYS is MDSYS.

The installation process grants the EXECUTE privilege to the user group PUBLIC for the interMedia packages and objects installed in the ORDSYS, ORDPLUGINS, and SI_INFORMTN_SCHEMA schemas.

B.1.2 Preinstallation Steps

Perform the following preinstallation tasks prior to manually installing and configuring interMedia. For instructions, see Oracle Installation Guide for your operating system:

  1. Install Oracle Database, including PL/SQL, Oracle JVM, and Oracle XML DB.

  2. Create the database.

  3. Start the database.

  4. Verify that Oracle JVM is installed and is valid.

    You can verify that Oracle JVM is correctly installed by running SQL*Plus, connecting as SYSDBA, and issuing the following query:

    SQL> select version, status from dba_registry where comp_id='JAVAVM';

    Ensure that the version is correct and the status is VALID.

B.1.3 Installation Steps

Perform the following mandatory configuration steps. Remember, you need to do this only if you are configuring interMedia manually. You do not need to do this if you use the Database Configuration Assistant.

References to <ORACLE_HOME> in these instructions represent the Oracle home directory.

  1. Use Oracle Universal Installer to install the files that make up interMedia on your system.

  2. Create the users and grant the appropriate privileges.

    Start SQL*Plus.
    % sqlplus
    Connect as SYSDBA.
    SQL> connect / as SYSDBA
    Invoke ordinst.sql with two parameters for interMedia tablespace and
    Location Services tablespace.
    SQL> @<ORACLE_HOME>/ord/admin/ordinst.sql SYSAUX SYSAUX (on UNIX)
         @<ORACLE_HOME>\ord\admin\ordinst.sql SYSAUX SYSAUX (on Windows)
  3. Install interMedia types and packages.

    SQL> @<ORACLE_HOME>/ord/im/admin/iminst.sql (on UNIX)
         @<ORACLE_HOME>\ord\im\admin\iminst.sql (on Windows)
  4. Start the listener.

    The listener must be configured to use external procedure calls. Check your tnsnames.ora file for an entry called extproc_connection_data and in the listener.ora file for an entry called extproc.

    See your network documentation for details. If this is not done properly, interMedia will not work for all supported formats.

Once these mandatory installation steps have been completed, interMedia is ready for use.

B.2 Upgrading an Installed Version of Oracle interMedia

If you upgrade a database from an earlier release of Oracle Database, interMedia will be upgraded automatically if detected in the source database. See Oracle Database Upgrade Guide for detailed instructions.

B.3 Verifying an Installed Version of Oracle interMedia

After installing or upgrading interMedia, you can verify the interMedia installation by invoking the interMedia check script.

To run the interMedia check script, connect as SYSDBA and invoke imchk.sql as follows:

  1. Start SQL*Plus.

    % sqlplus
  2. Connect as SYSDBA.

    SQL> connect / as SYSDBA
  3. Invoke imchk.sql.

    On UNIX
    SQL> @<ORACLE_HOME>/ord/im/admin/imchk.sql
    On Windows
    SQL> @<ORACLE_HOME>\ord\im/admin\imchk.sql

The check script will produce the list of interMedia components and their status values, and a summary line indicating whether or not the interMedia installation is valid. All interMedia components are expected to have the status VALID.

B.4 Downgrading an Installed Version of Oracle interMedia

Oracle interMedia is automatically downgraded when you downgrade a database with the interMedia feature installed. See Oracle Database Upgrade Guide for detailed instructions.