Copyright (c) 1998, 2018, Oracle and/or its affiliates. All rights reserved. NAME README.txt - ORACLE Multimedia IS NOW DESUPPORTED RELEASE 19c README FILE ======================= Contents ======== Oracle Multimedia Release 19c Warning Oracle Multimedia Installed Users and Privileges Important Install and Upgrade Considerations Upgrade Notes Installing Oracle Multimedia Verfying the Oracle Multimedia Installation Downgrade Notes Deinstall Notes Oracle Multimedia Release 19c ============================= Oracle Multimedia (formerly known as interMedia) is desupported in this release. In release 19c the ORDIM component remains in DBA_REGISTRY with a status of VALID. Oracle Locator continues to be installed with Oracle Multimedia, and Oracle Locator continues to be supported. A new database installation installs Oracle Multimedia and creates Oracle Multimedia object types. However, all Oracle Multimedia procedures and methods now raise an exception. An upgrade from an earlier database release in which Oracle Multimedia was installed modifies Oracle Multimedia object methods and procedures to raise an exception. If you have a database with tables containing multimedia data stored in Oracle Multimedia object types, you are encouraged to move this data to SecurFiles Lobs columns. Oracle Locator provides location-based services for Oracle. For information about Oracle Locator see "Oracle Spatial And Graph Developer's Guide". WARNING: ========= Ignoring this warning and performing any of these prohibited actions could cause internal errors and security violations in the database management system. Oracle Multimedia is installed under the database users ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, and ORDDATA. These users are created during database installation and are subject to change in future releases. Oracle Locator is installed under the database user MDSYS if Oracle Spatial is not installed. This user is created during database installation and is subject to change in future releases. This user must not be deleted. Customers must not connect to these users or modify these users or their contents. The functions, packages, types, views, and documents supplied by Oracle Multimedia are reserved by Oracle and are subject to change in future releases. Oracle Multimedia Installed Users and Privileges ================================================ The Oracle Multimedia installation creates the users ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, ORDDATA, and MDSYS with the privileges required for Oracle Multimedia. These users are created with no authentication. NOTE: Oracle does not support logging into these user accounts directly. The installation process also grants the EXECUTE privilege to the user group PUBLIC for the Oracle Multimedia packages and objects installed in the ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, and MDSYS schemas. Important Install and Upgrade Considerations ============================================ After upgrading to the 19c release, Oracle Multimedia will no longer function. The object types will remain, but object methods and procedures will raise an exception. Upgrade Notes: ============== If you upgrade a database from an earlier release of Oracle Database, Oracle Multimedia will be upgraded automatically if it is detected in the source database. See "Oracle Database Upgrade Guide" for detailed instructions. Installing Oracle Multimedia ============================ Oracle Multimedia is installed and configured with Oracle Database. If you need to configure Oracle Multimedia manually, follow the instructions in this section. 1 Installation Decisions 2 Pre-Installation Steps 3 Installation Steps 1 Installation Decisions ------------------------ The installation procedure creates the users ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, ORDDATA, and MDSYS. These user are created with the privileges required for Oracle Multimedia. Decision 1: Decide which tablespace to use for Oracle Multimedia users (ORDSYS, ORDPLUGINS, SI_INFORMTN_SCHEMA, and ORDDATA), and which tablespace to use for the Oracle Spatial/Oracle Locator user (MDSYS). Oracle recommends using the SYSAUX tablespace for both. 2 Pre-Installation Steps ------------------------ For more instructions on installing on your system and setting up your environment, see "Oracle Installation Guide" for your operating system. Perform the following pre-installation tasks prior to manually installing and configuring Oracle Multimedia: 2.1 Install Oracle Database, including PL/SQL 2.2 Create the database. 2.3 Start the database. 3 Installation Steps -------------------- Perform the following mandatory configuration steps. These steps are required ONLY if you are configuring Oracle Multimedia manually. You do NOT need to perform these steps if you use the Database Configuration Assistant. References to in these instructions represent the Oracle home directory. 3.1 Use the Oracle Universal Installer to install the files that make up Oracle Multimedia on your system. 3.2 Use the catcon.pl Perl script to run the Oracle Multimedia installation scripts. The catcon.pl Perl script is in the $ORACLE_HOME/rdbms/admin directory. 1) Create the users and grant the appropriate privileges. If you are using a tablespace other than SYSAUX, replace the '--pSYSAUX' parameters with the tablespace you have chosen. The first parameter is the tablespace to be used for Oracle Multimedia, the second is the tablespace to be used for Oracle Spatial and Graph. (On Linux/UNIX) perl catcon.pl -u SYS -d $ORACLE_HOME/ord/admin -b ordinst ordinst.sql '--pSYSAUX' '--pSYSAUX' (On Windows) perl catcon.pl -u SYS -d %ORACLE_HOME%\ord\admin -b ordinst ordinst.sql '--pSYSAUX' '--pSYSAUX' 2) Install the Oracle Multimedia and Oracle Locator types and packages. (On Linux/UNIX) perl catcon.pl -u SYS -d $ORACLE_HOME/ord/im/admin -b catim catim.sql (On Windows) perl catcon.pl -u SYS -d %ORACLE_HOME%\ord\im\admin -b catim catim.sql After these mandatory installation steps have been completed, Oracle Locator is ready for use. ======================= Verifying the Oracle Multimedia Installation ============================================ After you have installed or upgraded Oracle Multimedia, you can verify the Oracle Multimedia and Oracle Locator installation by invoking the Oracle Multimedia validation procedure. To run the Oracle Multimedia validation procedure, connect as SYSDBA and execute the procedure validate_ordim as follows: 1) Start SQL*Plus and connect AS SYSDBA. 2) Execute SYS.validate_ordim SQL> execute SYS.validate_ordim; The validation procedure silently sets the Oracle Multimedia registry entry to 'VALID' if Oracle Multimedia is valid. If there are invalid objects detected, the validation procedure lists the first few invalid objects and sets the registry entry to 'INVALID'. To query the registry entry for Oracle Multimedia, run SQL*Plus, connect AS SYSDBA, and 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'. Downgrade Notes =============== Oracle Multimedia and Oracle Locator are automatically downgraded when you downgrade Oracle Database with the Oracle Multimedia feature installed. See "Oracle Database Upgrade Guide" for detailed instructions. Deinstall Notes =============== Oracle Multimedia ships an installation removal script. This script removes Oracle Multimedia only, it does not remove Oracle Locator. After removing Oracle Multimedia, the ORDIM component will remain in DBA_REGISTRY to represent the Oracle Locator component. Follow these steps to deinstall Oracle Multimedia: 1) Start SQL*Plus and connect as SYSDBA. 2) Invoke the Oracle Multimedia remove check script to verify that Oracle Multimedia object types and xml schemas are not being used. The remove check script should be invoked using the catcon.pl Perl script. This script is in the $ORACLE_HOME/rdbms/admin directory: perl catcon.pl -u SYS -d $ORACLE_HOME/ord/admin -b imremchk imremchk.sql The Oracle Multimedia remove check script will check whether Oracle Multimedia is being used. A message will be displayed indicating whether or not Oracle Multimedia is being used. For example: Oracle Multimedia is not being used or Oracle Multimedia object types are being used 3) Invoke the Oracle Multimedia removal script using the catcon.pl Perl script. This script is in the $ORACLE_HOME/rdbms/admin directory: perl catcon.pl -u SYS -r -d $ORACLE_HOME/ord/admin -b imremdo imremdo.sql The Oracle Multimedia removal script will remove Oracle Multimedia without force. If Oracle Multimedia object types are being used, they will not be removed.