Skip Headers
Oracle® Multimedia User's Guide
11g Release 2 (11.2)

Part Number E10777-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

B Managing Oracle Multimedia Installations

This appendix describes the management of Oracle Multimedia in these sections:

Note:

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

B.1 Oracle Multimedia Installed Users and Privileges

The Oracle Multimedia installation procedure performs these functions:

B.2 Installing and Configuring Oracle Multimedia

Oracle Multimedia is automatically installed and configured with Oracle Database.

This section includes the steps to perform before manual installation and configuration of Oracle Multimedia, and the steps for manually installing and configuring it.

Caution:

Performing any of these prohibited actions could cause internal errors and security violations in the database management system.

These users are created during database installation, and might change in future releases:

  • Users in which Oracle-supplied Oracle Multimedia is installed: ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, and ORDDATA

  • User in which Oracle Multimedia Locator is installed if Oracle Spatial is not installed: MDSYS

Do not delete any of these users.

Do not connect to or modify any of these users or their contents (which are supplied by Oracle Multimedia and reserved by Oracle), with these exceptions:

  • You can add user-defined packages to the user ORDPLUGINS. See Chapter 7 for more information about extending Oracle Multimedia.

  • DICOM administrators store user-defined DICOM data model configuration documents in the user ORDDATA, using the DICOM data model repository API. See Oracle Multimedia DICOM Developer's Guide for more information about inserting documents into the data model repository.

B.2.1 Preinstallation Steps

Before installing and configuring Oracle Multimedia manually, perform these steps:

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

  2. Create the database.

  3. Start the database.

  4. Verify that the required software is correctly installed and valid, as follows:

    1. Run SQL*Plus, connect as SYSDBA, and enter these queries:

      SQL> select version, status from dba_registry where comp_id='JAVAVM';
      SQL> select version, status from dba_registry where comp_id='XDB';
      SQL> select version, status from dba_registry where comp_id='XML';
      
    2. Examine the results of the queries to ensure that each version value is identical to the version of Oracle Multimedia that you are installing and each status value is VALID.

For more detailed information, see the Oracle Database Installation Guide for your operating system.

B.2.2 Installation and Configuration Steps

These steps are not required if you use the Database Configuration Assistant.

To install and configure Oracle Multimedia manually, perform these steps (<ORACLE_HOME> represents the Oracle home directory):

  1. Use Oracle Universal Installer to install the files that comprise Oracle Multimedia on your system.

  2. Decide which tablespace to use for the Oracle Multimedia users, and which tablespace to use for the Oracle Spatial/Oracle Multimedia Location Services user (see Table B-1). Oracle recommends using the SYSAUX tablespace for all of these users.

  3. Create the users and grant the appropriate privileges, as follows:

    1. Start SQL*Plus and connect as SYSDBA:

      % sqlplus
      
      SQL> CONNECT sys as sysdba
      
    2. Call the script ordinst.sql, with two parameters for the Oracle Multimedia tablespace and the Oracle Spatial/Oracle Multimedia Location Services tablespace:

      On Linux and UNIX:

      SQL> @<ORACLE_HOME>/ord/admin/ordinst.sql SYSAUX SYSAUX
      

      On Windows:

      SQL> @<ORACLE_HOME>\ord\admin\ordinst.sql SYSAUX SYSAUX 
      
  4. Install the Oracle Multimedia types and packages, as follows:

    Call the script catim.sql, while you are connected as SYSDBA:

    On Linux and UNIX:

    SQL> @<ORACLE_HOME>/ord/im/admin/catim.sql
    

    On Windows:

    SQL> @<ORACLE_HOME>\ord\im\admin\catim.sql
    

Now Oracle Multimedia is ready for use.

B.3 Verifying an Installed Version of Oracle Multimedia

After installing or upgrading Oracle Multimedia, you can verify the Oracle Multimedia installation by calling the Oracle Multimedia validation procedure.

To run the Oracle Multimedia validation procedure, perform these steps:

  1. Start SQL*Plus and connect as SYSDBA:

    % sqlplus
    
    SQL> CONNECT sys as sysdba
    
  2. Execute the procedure sys.validate_ordim:

    SQL> execute sys.validate_ordim;
    

    If the validation procedure detects invalid objects, it lists the first few invalid objects and sets the registry entry to INVALID; otherwise, it silently sets the Oracle Multimedia registry entry to VALID.

  3. Verify that the registry entry for Oracle Multimedia is correct, as follows:

    1. Enter this query from SQL*Plus, while you are connected as SYSDBA:

      SQL> select version, status from dba_registry where comp_id='ORDIM';
      
    2. Examine the result of the query to ensure that the version value is correct and the status value is VALID.

B.4 Upgrading an Installed Version of Oracle Multimedia

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

B.5 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.

Caution:

Do not modify your DICOM data model repository until you are sure that you are not going to downgrade from Oracle Database 11g Release 2 (11.2) back to the source release.

Changes to the Oracle Multimedia DICOM data model repository (such as document insertions or deletions) that you make after a database upgrade are lost after a database downgrade.

B.6 Removing Oracle Multimedia

To remove Oracle Multimedia manually, perform these steps:

  1. Start SQL*Plus, and connect as SYSDBA:

    % sqlplus
    
    SQL> CONNECT sys as sysdba
    
  2. Call the script catcmprm.sql, with the parameter ORDIM:

    On Linux and UNIX:

    SQL> @<ORACLE_HOME>/rdbms/admin/catcmprm.sql ORDIM
    

    On Windows:

    SQL> @<ORACLE_HOME>\rdbms\admin\catcmprm.sql ORDIM
    

    If one or more components that depend on Oracle Multimedia (such as Oracle Spatial) are installed, this message appears:

    ORDIM cannot be removed as it has the following dependencies:
        Component: SDO Namespace: SERVER
    

    If no dependent components are installed, a message appears, indicating either that Oracle Multimedia is or is not in use.

    Then, a prompt asks if you really want to remove Oracle Multimedia.

  3. Reply to the prompt with Y or y to remove Oracle Multimedia.

    Oracle Multimedia is removed with force (regardless of whether it is in use).