Managing Oracle Multimedia Installations

A.1 Oracle Multimedia Installed Users and Privileges

This topic summarizes the database user accounts created by the Oracle Multimedia installation procedure.

The Oracle Multimedia installation procedure performs these functions:

Creates the database users shown in Table A-1 with the privileges required by Oracle Multimedia.

Table A-1 Installed Database Users

Name of User	Type of User
`ORDSYS`	Oracle Multimedia
`ORDPLUGINS`	Oracle Multimedia
`SI_INFORMTN_SCHEMA`	Oracle Multimedia
`ORDDATA`	Oracle Multimedia
`MDSYS`	Oracle Spatial and Graph/Oracle Locator

Creates the default passwords shown in Table A-2 for the Oracle Multimedia and MDSYS user accounts, and then locks the accounts and marks their default passwords as expired.

Table A-2 User Accounts and Default Passwords

User Account	Installation Password
`ORDSYS`	`ORDSYS`
`ORDPLUGINS`	`ORDPLUGINS`
`SI_INFORMTN_SCHEMA`	`SI_INFORMTN_SCHEMA`
`ORDDATA`	`ORDDATA`
`MDSYS`	`MDSYS`

Caution:

Oracle does not recommend logging in directly to the user accounts shown in Table A-2.

Grants the EXECUTE privilege to the user group PUBLIC for the Oracle Multimedia packages and objects installed in these schemas:
- ORDSYS
- ORDPLUGINS
- SI_INFORMTN_SCHEMA
- MDSYS

A.2 Installing and Configuring Oracle Multimedia

Oracle Multimedia is automatically installed and configured with Oracle Database.

The following subsections describe 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 unsupported and 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 and Graph is not installed: MDSYS

Do not delete any of these users.

Do not connect to, modify, or change the privileges of 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.
DICOM administrators can store user-defined DICOM data model configuration documents in the user ORDDATA, using the DICOM data model repository API.

Related Topics

Extending Oracle Multimedia

See Also:

Oracle Multimedia DICOM Developer's Guide for more information about inserting documents into the data model repository

A.2.1 Preinstallation Steps

Installing Oracle Multimedia manually requires a few preliminary tasks.

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

Install Oracle Database, including PL/SQL, Oracle JVM, Oracle XML Database, and Oracle XDK.
Create the database.
Start the database.
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.

See Also:

Oracle Database Installation Guide for your operating system for more detailed information

A.2.2 Installation and Configuration Steps

Installing and configuring Oracle Multimedia manually requires a few setup tasks.

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

To install and configure Oracle Multimedia manually, perform these steps:

Note:

In these steps, <ORACLE_HOME> is replaced with the location of the Oracle home directory.

Use Oracle Universal Installer to install the files that comprise Oracle Multimedia on your system.
Decide which tablespace to use for the Oracle Multimedia users, and which tablespace to use for the Oracle Spatial and Graph/Oracle Multimedia Location Services user (see Table A-1). Oracle recommends using the SYSAUX tablespace for all these users.
Use the Perl script catcon.pl to run the Oracle Multimedia installation scripts. The catcon.pl script is in the directory <ORACLE_HOME>/rdbms/admin.
1. Run the script to create the users and grant the appropriate privileges.
  
  If you are using a tablespace other than SYSAUX, replace the SYSAUX parameters with the tablespaces you have chosen. The first parameter is the tablespace for Oracle Multimedia; the second parameter is the tablespace for Oracle Spatial and Graph.
```
perl catcon.pl -u SYS -d <ORACLE_HOME>/ord/admin -b ordinst ordinst.sql '--pSYSAUX' '--pSYSAUX'
```
2. Run the script to install the Oracle Multimedia types and packages.
```
perl catcon.pl -u SYS -d <ORACLE_HOME>/ord/im/admin -b catim catim.sql
```

Now Oracle Multimedia is ready for use.

A.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:

Start SQL*Plus and connect as SYSDBA.
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.
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.

A.4 Upgrading an Installed Version of Oracle Multimedia

Oracle Multimedia is automatically upgraded when you upgrade a database with the Oracle Multimedia feature installed.

See Also:

Oracle Database Upgrade Guide for detailed upgrading instructions

A.5 Downgrading an Installed Version of Oracle Multimedia

Oracle Multimedia is automatically downgraded when you downgrade a database with the Oracle Multimedia feature installed.

Caution:

Do not modify your DICOM data model repository until you are sure that you are not going to downgrade from the new release of Oracle Database 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.

See Also:

Oracle Database Upgrade Guide for detailed downgrading instructions