B Installing and Upgrading Oracle interMedia

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 interMedia users (ORDSYS, ORDPLUGINS, and SI_INFORMTN_SCHEMA), and which tablespace to use for the Spatial/interMedia Location Services user (MDSYS). Oracle Corporation 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 into 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 interMedia packages and objects installed in the ORDSYS, ORDPLUGINS, and SI_INFORMTN_SCHEMA schemas.

B.1.2 Preinstallation Steps

Perform the following preinstallation tasks prior to manually installing and configuring interMedia. For instructions, see Oracle Installation Guide for your operating system:

1. Install Oracle Database 10g Release 1 (10.1), including PL/SQL and Oracle JVM.

2. Create the database.

3. Start the database.

4. 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 configuration steps. Remember, you need to do this only if you are configuring interMedia manually. You do not need to do this if you use the Database Configuration Assistant.

References to <ORACLE_HOME> in these instructions represent the Oracle home directory.

1. Use Oracle Universal Installer to install the files that make up interMedia on your system.

2. 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 UNIX)
        @<ORACLE_HOME>\ord\admin\ordinst.sql SYSAUX SYSAUX (on Windows)
   
   

3. Install interMedia types and packages.

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

4. Start the listener.

   The listener must be configured to use external procedure calls. Check your tnsnames.ora file for an entry called extproc_connection_data and in the listener.ora file for an entry called extproc.

   See your network documentation for details. If this is not done properly, interMedia will not work for all supported formats.

Once these mandatory installation steps have been completed, interMedia is ready for use.