B Managing Oracle Multimedia Installations

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:

Installing Oracle Multimedia
Upgrading an Installed Version of Oracle Multimedia
Verifying an Installed Version of Oracle Multimedia
Downgrading an Installed Version of Oracle Multimedia
Removing Oracle Multimedia

Note:

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

B.1 Installing Oracle Multimedia

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:

Installation decisions
Preinstallation steps
Installation steps

WARNING:

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.

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 Oracle Multimedia users (ORDSYS, ORDPLUGINS, and 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 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 Oracle Multimedia packages and objects installed in the ORDSYS, ORDPLUGINS, and SI_INFORMTN_SCHEMA schemas.

B.1.2 Preinstallation Tasks

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 VALID.

B.1.3 Installation Steps

Perform the following mandatory installation steps to configure Oracle Multimedia manually. These steps are not required 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 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 interMedia 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 extproc.

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.

B.2 Upgrading an Installed Version of Oracle Multimedia

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.

B.3 Verifying an Installed Version of Oracle Multimedia

After installing or upgrading Oracle Multimedia, you can verify the Oracle Multimedia installation by invoking the Oracle Multimedia verification procedure.

To run the Oracle Multimedia verification procedure, connect as SYSDBA and invoke validate_ordim as follows:

Start SQL*Plus.
```
% sqlplus
```
Connect as SYSDBA.
```
SQL> CONNECT / as sysdba
```

Execute validate_ordim.

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 INVALID.

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 VALID.

B.4 Downgrading an Installed Version of Oracle Multimedia

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

B.5 Removing Oracle Multimedia

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.

Note:

The imremchk.sql script 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 or 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).

Call the imremov.sql script.

SQL> @<ORACLE_HOME>/ord/im/admin/imremov.sql (on Linux and UNIX)
     @<ORACLE_HOME>\ord\im\admin\imremov.sql (on Windows)