This appendix describes the manual installation of Oracle Multimedia as well as the manual upgrading of an installed version of Oracle Multimedia. In addition, this appendix provides information about how to verify and downgrade an installed version of Oracle Multimedia.
These topics are presented in the following sections:
Note:See the Oracle Multimedia
README.txtfile located in
/ord/im/adminfor the latest information.
Oracle Multimedia is installed and configured with Oracle Database. If, for some reason, you need to install Oracle Multimedia manually, you can follow the instructions in this section, according to the following topics:
Oracle-supplied Oracle Multimedia data types are installed under the database users ORDSYS, ORDPLUGINS, and SI_INFORMTN_SCHEMA. These users are created during database installation, and they are subject to change in future releases.
The functions, packages, types, and views supplied by Oracle Multimedia are reserved by Oracle, and they are subject to change in future releases. The ORDSYS and SI_INFORMTN_SCHEMA users and their contents must not be modified by the customer. Do not connect to these users or add your own tables, functions, packages, types, or views to these users. In addition, the packages supplied by Oracle Multimedia in the ORDPLUGINS user must not be modified by the customer. Doing so could cause internal errors and security violations in the database management system.
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 Oracle Multimedia users (
SI_INFORMTN_SCHEMA), and which tablespace to use for the Spatial/Oracle Multimedia Location Services user (
MDSYS). Oracle 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 in to 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 Oracle Multimedia packages and objects installed in the
Perform the following preinstallation tasks before installing and configuring Oracle Multimedia manually. For instructions, see Oracle Database 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
Perform the following mandatory installation steps to configure Oracle Multimedia manually. These steps are not required 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 Oracle Multimedia 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 Oracle Multimedia tablespace and Location Services tablespace. SQL> @<ORACLE_HOME>/ord/admin/ordinst.sql SYSAUX SYSAUX (on Linux and UNIX) @<ORACLE_HOME>\ord\admin\ordinst.sql SYSAUX SYSAUX (on Windows)
Install Oracle Multimedia types and packages.
SQL> @<ORACLE_HOME>/ord/im/admin/catim.sql (on Linux and UNIX) @<ORACLE_HOME>\ord\im\admin\catim.sql (on Windows)
Start the listener.
The listener must be configured to use external procedure calls. Check the
tnsnames.ora file for an entry called
extproc_connection_data. Then check the
listener.ora file for an entry called
See your network documentation for details. If this step is not done correctly, Oracle Multimedia will not work for all supported formats.
Once these mandatory installation steps have been completed, Oracle Multimedia is ready for use.
If you upgrade a database from an earlier release of Oracle Database, Oracle Multimedia will be upgraded automatically if detected in the source database. See Oracle Database Upgrade Guide for detailed instructions.
To run the Oracle Multimedia verification procedure, connect as SYSDBA and invoke
validate_ordim as follows:
Connect as SYSDBA.
SQL> CONNECT / as sysdba
SQL> execute validate_ordim; On Windows SQL> @<ORACLE_HOME>\ord\im/admin\imchk.sql
The validation procedure will silently set the Oracle Multimedia registry entry to
VALID if Oracle Multimedia is valid. If invalid objects are detected, the validate procedure will list the first few invalid objects and set the registry entry to
To query the registry entry for Oracle Multimedia, run SQL*Plus and connect as SYSDBA again (follow steps 1 and 2 in the verification procedure). Then, enter the following query:
SQL> select version, status from dba_registry where comp_id='ORDIM';
Ensure that the version is correct and the status is
Oracle Multimedia is automatically downgraded when you downgrade a database with the Oracle Multimedia feature installed. See Oracle Database Upgrade Guide for detailed instructions.
Oracle Multimedia ships an installation removal script (
imremov.sql) that you can use to manually remove Oracle Multimedia. First, the removal script invokes a removal checking script (
imremchk.sql), which checks for tables that contain columns of one of the Oracle Multimedia object types, or columns that are bound to one of the Oracle Multimedia XML schemas. Next, the removal checking script displays a message that indicates whether or not Oracle Multimedia is in use.
imremchk.sqlscript does not check whether dependent products, such as Oracle Spatial, are installed.
Then, the installation removal script (
imremov.sql) prompts to ask if you really want to remove Oracle Multimedia. If the first character of your response is
y, Oracle Multimedia will be removed with
force, regardless of whether or not it is in use.
Follow these steps to manually remove Oracle Multimedia:
Start SQL*Plus, and connect as SYSDBA (see Steps 1 and 2 in Section B.3).
SQL> @<ORACLE_HOME>/ord/im/admin/imremov.sql (on Linux and UNIX) @<ORACLE_HOME>\ord\im\admin\imremov.sql (on Windows)