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).
Note: See the interMediaREADME.txt file located in <ORACLE_HOME> /ord/im/admin for the latest information. |
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
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.
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, including PL/SQL, Oracle JVM, and Oracle XML DB.
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 VALID
.
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.
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 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.
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.
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:
Start SQL*Plus.
% sqlplus
Connect as SYSDBA.
SQL> connect / as SYSDBA
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
.
Oracle interMedia is automatically downgraded when you downgrade a database with the interMedia feature installed. See Oracle Database Upgrade Guide for detailed instructions.