|Oracle® interMedia User's Guide
10g Release 1 (10.1)
Part Number B10840-01
Note:See the interMedia
Oracle interMedia is installed and configured with Oracle Database 10g. If, for some reason, you need to install interMedia manually, you can follow the instructions in this section, according to the following topics:
The installation procedure creates the
MDSYS users. These user IDs are the standard Oracle Database account with special privileges.
Decision: Decide which tablespace to use for interMedia users (
SI_INFORMTN_SCHEMA), and which tablespace to use for the Spatial/interMedia Location Services user (
MDSYS). Oracle Corporation suggests you use the SYSAUX tablespace for both.
Decision: Decide on passwords for the
MDSYS users. The installation uses default passwords for
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 into these accounts directly.
The default password for the
ORDSYS user during automatic installation is
SI_INFORMTN_SCHEMA, and for
The installation process grants the EXECUTE privilege to the user group PUBLIC for the interMedia packages and objects installed in the
Perform the following preinstallation tasks prior to manually installing and configuring interMedia. For instructions, see Oracle Installation Guide for your operating system:
Install Oracle Database 10g Release 1 (10.1), including PL/SQL and Oracle JVM.
Create the database.
Start the database.
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
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.
<ORACLE_HOME> in these instructions represent the Oracle home directory.
Use Oracle Universal Installer to install the files that make up interMedia on your system.
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)
Install interMedia types and packages.
SQL> @<ORACLE_HOME>/ord/im/admin/iminst.sql (on UNIX) @<ORACLE_HOME>\ord\im\admin\iminst.sql (on Windows)
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
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.
If you upgrade a database from an earlier release of Oracle Database to Oracle Database 10g, interMedia will be upgraded automatically if detected in the source database. See Oracle Database Upgrade Guide for detailed instructions.
To run the interMedia check script, connect as SYSDBA and invoke
imchk.sql as follows:
Connect as SYSDBA.
SQL> connect / as SYSDBA
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
Oracle interMedia is automatically downgraded when you downgrade a database with the interMedia feature installed. See Oracle Database Upgrade Guide for detailed instructions.