5
Post-Installation Configuration Tasks

This chapter focuses on the post-installation configuration of Oracle interMedia and the Oracle Visual Information Retrieval Client. Where appropriate, the chapter provides references to other guides for those configuration tasks.

Specific topics discussed are:

• Oracle interMedia Client

• Oracle Visual Information Retrieval Client

  Note: The directory path examples in this chapter follow Optimal Flexible Architecture (OFA) guidelines (for example, ORACLE_BASE\ORACLE_HOME\RDBMS\ADMIN). If you specified non-OFA compliant directories during installation, your directory paths will differ. See "OFA and Multiple Oracle Home Configurations" for more information.

Oracle interMedia Client

Oracle interMedia Client provides an Oracle8i Java interface that lets you use local (client-side) applications to manipulate and/or modify multimedia data stored in network-accessible (server-side) database. It also provides a simple image sample (SIMPIMG.EXE) that was developed, using Microsoft Visual C++. SIMPIMG.EXE locates and updates images, using interMedia in an Oracle8i database.

Audio

Oracle interMedia Audio manages audio data in multiple file formats in an Oracle database. Types of audio data supported include conversations, songs, and other sounds in popular audio file formats. This makes it possible to integrate audio data with other application-specific object-relational data.

Video

Oracle interMedia Video manages video data in multiple video file formats. This makes it possible to integrate video data with other application-specific object-relational data.

Image

Oracle interMedia Image provides image storage, retrieval, and format conversion capabilities through an object data type (ODT). It also supports image storage, using Binary Large Objects (BLOBs), and references to image data residing in external files (BFILEs).

The Image component of Oracle interMedia also comes with a sample demonstration that shows how an image is extracted from an Oracle database.

Locator

Oracle interMedia Locator enables Oracle8i to support online internet-based geocoding facilities for locator applications and proximity queries.

Text

Oracle interMedia Text (formerly called ConText) enables text queries through SQL and PL/SQL from most Oracle interfaces.

By installing Oracle interMedia Text with an Oracle database server, client tools such as SQL*Plus, Oracle Forms, and Pro*C/C++ are able to retrieve and manipulate text in an Oracle database.

Oracle interMedia Text manages textual data in concert with traditional data types in an Oracle database. When text is inserted, updated, or deleted, Oracle interMedia Text automatically manages the change.

Oracle interMedia Audio, Video, Image, and Locator Configuration Responsibilities

Review the following table to determine how to configure Oracle interMedia Audio, Video, Image, and Locator.

If You...	Then...
Installed Oracle interMedia through the Oracle8i Client Typical installation type path	No manual configuration is required. All tasks described in "Configuring Oracle interMedia Audio, Video, Image, and Locator" are automatically performed.
Installed both Oracle interMedia and Oracle8i Client together through the Oracle8i Client installation type path	Oracle Database Configuration Assistant starts at the end of installation. If you select either of the following options: Custom Typical, and then select the new database files suboption Oracle Database Configuration Assistant asks if you want Oracle interMedia to be automatically configured.
Installed Oracle interMedia during a separate installation from Oracle8i Client	You must manually configure Oracle interMedia by either: Performing the tasks under "Configuring Oracle interMedia Audio, Video, Image, and Locator". Starting Oracle Database Configuration Assistant and selecting Modify a database. Then following the on-screen instructions.
Manually copy your Oracle7 LISTENER.ORA and TNSNAMES.ORA files into your Oracle8i network directory	You must modify the TNSNAMES.ORA and LISTENER.ORA network configuration files on your server to enable external procedure calls to work and interMedia to function properly. Follow the tasks in "Configuring Net8 for External Procedures" in Chapter 8 of Net8 Administrator's Guide.
Want to use the demos	Perform the tasks described for the configuration of Oracle interMedia sample demos below.
Want to build the Oracle interMedia Image sample demonstration	Install a C compiler.
Want to use Oracle Visual Information Retrieval with Oracle interMedia	Install Oracle interMedia first. If you used the Custom Installation type and selected both components for installation at the same time, Oracle interMedia was installed first.

Configuring Oracle interMedia Audio, Video, Image, and Locator

To configure Oracle interMedia Audio, Video, Image, and Locator:

1. Start SQL*Plus:

   C:\> SQLPLUS
   

2. Connect to the database with the SYS account:

   SQL> CONNECT SYS/PASSWORD AS SYSDBA
   

3. Start the database (if necessary):

   SQL> STARTUP
   

4. Run the ORDINST.SQL script:

   SQL> @ORACLE_BASE\ORACLE_HOME\ORD\ADMIN\ORDINST.SQL
   

5. Run the IMINST.SQL script:

   SQL> @ORACLE_BASE\ORACLE_HOME\ORD\IM\ADMIN\IMINST.SQL
   

6. Exit SQL*Plus:

   SQL> EXIT
   

Configuring Oracle interMedia, Audio, Video, Image, and Locator Demos

To configure Oracle interMedia Audio demonstrations:

1. Go to the ORACLE_BASE\ORACLE_HOME\ORD\AUD\DEMO directory.

2. Follow the instructions in the README.TXT file.

To configure Oracle interMedia Video demonstrations:

1. Go to the ORACLE_BASE\ORACLE_HOME\ORD\VID\DEMO directory.

2. Follow the instructions in the README.TXT file.

To configure Oracle interMedia Image demonstrations:

1. Go to the ORACLE_BASE\ORACLE_HOME\ORD\IMG\ADMIN directory.

2. Read the README file in this directory for instructions on configuring the demo.

3. Make the interMedia Image demos for a Microsoft C compiler by entering:

   C:\> MAKE
   

An additional demonstration resides in the following location:

ORACLE_BASE\ORACLE_HOME\ORD\IMG\DEMO\VC\IMGSAMP\SIMPIMG

In order to build and run the demonstration, you must first modify the MAKEFILE to adapt it to your environment.

To configure Oracle interMedia Locator demonstrations:

1. Go to the ORACLE_BASE\ORACLE_HOME\MD\DEMO\GEOCODER directory.

2. The NH_CS.SQL file contains the sample data that can be loaded into Oracle8i. GEOHTTP.SQL and GEOLOCAT.SQL are examples that show the use of Locator functionality. GEOINDEX.SQL contains examples of data indices created by using the Locator.

Oracle interMedia Text Configuration Responsibilities

Review the following table to determine your Oracle interMedia Text post-installation tasks.

If You...	Then...
Installed Oracle interMedia Text from the CD-ROM and you do not have a previous release of interMedia Text installed (formerly called ConText)	See the description below this table.
Installed Oracle interMedia Text from the CD-ROM and you do have a previous release of interMedia Text installed (formerly called ConText)	See Oracle8i interMedia Text Migration.
Migrated your database, you may need to configure Net8 for external procedures. Otherwise, Oracle interMedia Text may not work. In any case other than migration, Net8 should be configured correctly by default to work with Oracle interMedia Text.	See the Oracle8i interMedia Text Migration and Oracle8i interMedia Text Reference.
Are indexing formatted documents such as Microsoft Word	You must set your environment to use the INSO filter before you can index your documentation set. For more information on setting up your environment for INSO filtering, see Appendix C of the Oracle8i interMedia Text Reference.

If one of the following is true, the Oracle8i database is already configured for use with Oracle interMedia Text:

• The database is a starter database that you created by installing Oracle8i Enterprise Edition with the Typical installation type.

• The database is a starter database that you created by performing the following sequence of steps:
  1. Installed Oracle8i Enterprise Edition or Oracle8i with the Custom installation type.

  2. Selected Oracle8i Server in the Available Product Components dialog box.

  3. Clicked Yes when prompted to run Oracle Database Configuration Assistant.

  4. Selected the Typical database creation type.

  5. Selected Copy existing database files from the CD-ROM.

• You created the database by using Oracle Database Configuration Assistant in standalone mode, selecting the Typical database creation type, and selecting Copy existing database files from the CD-ROM.

If none of these are true, you must configure the Oracle database for use with Oracle interMedia Text by doing one of the following:

• Using Oracle Database Configuration Assistant

• Configuring Manually

Using Oracle Database Configuration Assistant

You can use Oracle Database Configuration Assistant to configure an Oracle8i database for use with Oracle interMedia Text either at the time you create the database or later.

To configure...	Do this...
At a later time	Select Modify a database in the Welcome page. Select the database that you want to modify in the Modify Instance page. Select Oracle interMedia Text in the Modify Database Cartridges and Options page.

Configuring Manually

Manually configuring an Oracle database for use with Oracle interMedia Text consists of creating a tablespace for the Oracle interMedia Text data dictionary tables and then creating the CTXSYS user name and the Oracle interMedia Text data dictionary tables themselves.

To create a tablespace for the Oracle interMedia Text data dictionary tables:

1. Start SQL*Plus:

   C:\> SQLPLUS
   

2. Connect as SYS:

   Enter user-name: SYS/PASSWORD
   

3. Create a tablespace for the Oracle interMedia Text data dictionary tables:

   SQL> CREATE TABLESPACE TABLESPACE_NAME DATAFILE 'ORACLE_BASE\ORADATA\
   
   DB_NAME\DR01.DBF' SIZE 80M;
   

To create the CTXSYS user name and the Oracle interMedia Text data dictionary tables:

1. Connect as INTERNAL:

   SQL> CONNECT INTERNAL/PASSWORD
   

2. Run the DR0CSYS.SQL script to create the CTXSYS user name:

   SQL> @ORACLE_BASE\ORACLE_HOME\CTX\ADMIN\DR0CSYS.SQL PASSWORD 
   
   DEFAULT_TABLESPACE_NAME TEMPORARY_TABLESPACE_NAME;
   

   where:

   • PASSWORD is the password that you want to use for the CTXSYS user name.

   • DEFAULT_TABLESPACE_NAME is the default tablespace for the Oracle interMedia Text data dictionary tables. Set the default tablespace to the value of TABLESPACE_NAME in step 3 of the instructions "To create a tablespace for the Oracle interMedia Text data dictionary tables:".

   • TEMPORARY_TABLESPACE_NAME is the temporary tablespace for the Oracle interMedia Text data dictionary tables. Set the temporary tablespace to the value of TABLESPACE_NAME in step 3 of the instructions "To create a tablespace for the Oracle interMedia Text data dictionary tables:".

3. Connect as CTXSYS:

   SQL> CONNECT CTXSYS/PASSWORD
   

4. Run the DR0INST.SQL script to create and populate the Oracle interMedia Text data dictionary tables:

   SQL> @ORACLE_BASE\ORACLE_HOME\CTX\ADMIN\DR0INST.SQL ORACLE_BASE\
   
   ORACLE_HOME\CTX\LIB\ORACTXX8.DLL;
   

5. Run the language-specific default script, where XX is the language code (for example, US):

   SQL> @ORACLE_BASE\ORACLE_HOME\CTX\ADMIN\DEFAULTS\DRDEFXX.SQL;
   

6. Exit SQL*Plus:

   SQL> EXIT
   

Configuration Required to Use the Java Client:

To use the Java library:

1. Set the environment variable CLASSPATH so that it contains the Oracle interMedia library. The library resides in the following location:

   ORACLE_BASE\ORACLE_HOME\ORD\JLIB\ORDEIM.ZIP

   The JDBC OCI driver (classes111.zip) must also be in CLASSPATH.

2. Include the JDBC OCI shared library in the PATH.

To run the SIMPIMG demonstration:

1. Refer to the README file that resides at the following location for information on setting up and running the SIMPIMG demonstration:

   ORACLE_BASE\ORACLE_HOME\ORD\IMG\DEMO\VC\IMGSAMP\README.TXT

Oracle Visual Information Retrieval Client

Oracle Visual Information Retrieval Client provides an Oracle8i Java interface that lets you use local (client-side) applications to manipulate and/or modify image data stored in a network-accessible (server-side) database.

This option provides image storage, content-based retrieval, and format conversion capabilities through an object data type. This option is a building block for various imaging applications, rather than being an end-user application. Some common applications for this option consist of digital art galleries and museums, real estate marketing, document imaging, and stock photo collections for fashion designers and architects.

Oracle Visual Information Retrieval also provides a sample demonstration, showing how an image is extracted from an Oracle database.

Review the following table to determine your configuration responsibilities.

Note: When you select installation of Oracle Visual Information Retrieval, Oracle interMedia is installed automatically since Oracle Visual Information Retrieval cannot function properly without it.

If You...	Then...
Installed Oracle Visual Information Retrieval through the Oracle8i Client Typical installation type	No manual configuration is required. All configuration tasks described under "To configure Oracle Visual Information Retrieval:" are automatically performed.
Installed both Oracle Visual Information Retrieval and Oracle8i Server together through the Oracle8i Enterprise Edition Custom installation type path	Oracle Database Configuration Assistant starts at the end of installation. If you select either of the following options: Custom Typical, and then select the Create new database files suboption Oracle Database Configuration Assistant asks if you want Oracle Visual Information Retrieval to be automatically configured.
Installed Oracle Visual Information Retrieval during a separate installation from Oracle8i Client	You must manually configure Oracle Visual Information Retrieval by either: Performing the configuration tasks described under "Configuring Oracle Visual Information Retrieval Client". Starting Oracle Database Configuration Assistant and selecting "Modify a database". Then, following the on-screen instructions.
Want to use the demonstration	Perform the configuration tasks described under "Configuring Oracle Visual Information Retrieval Client".
Want to build an Oracle Visual Information Retrieval sample demonstration.	Install a C compiler.
Manually copy your Oracle7 LISTENER.ORA and TNSNAMES.ORA files into your Oracle8i network directory	You must modify the TNSNAMES.ORA and LISTENER.ORA network configuration files on your server to enable external procedure calls to work and Oracle Visual Information Retrieval to function properly. Follow the tasks in the Net8 Administrator's Guide.

Configuring Oracle Visual Information Retrieval Client

To configure Oracle Visual Information Retrieval:

1. Ensure that Oracle interMedia is already configured. Oracle interMedia must be configured before Oracle Visual Information Retrieval. See the configuration instructions for Oracle interMedia under "Configuring Oracle interMedia, Audio, Video, Image, and Locator Demos" for information about running the ordinst.sql and iminst.sql scripts.

2. Start SQL*Plus:

   C:\> SQLPLUS
   

3. Connect to the database with the SYS account:

   SQL> CONNECT SYS/PASSWORD AS SYSDBA
   

4. Start the database (if necessary):

   SQL> STARTUP
   

5. Run the VIRINST.SQL script:

   SQL> @ORACLE_BASE\ORACLE_HOME\ORD\VIR\ADMIN\VIRINST.SQL
   

6. Run the IMINST.SQL script:

   SQL> @ORACLE_BASE\ORACLE_HOME\ORD\IM\ADMIN\IMINST.SQL
   

7. Exit SQL*Plus:

   SQL> EXIT
   

To configure the Oracle Visual Information Retrieval demonstration:

1. Go to the ORACLE_BASE\ORACLE_HOME\ORD\VIR\ADMIN directory.

2. Read the README file in this directory for instructions on configuring the demonstration.

3. Make the Oracle Visual Information Retrieval demonstration for a Microsoft C compiler by entering:

   C:\> MAKE
   

Configuration Required to Use the Java Client

To use the Java library:

1. Set the environment variable CLASSPATH so that it contains the Oracle Visual Information Retrieval library. The library resides in the following location:

   ORACLE_BASE\ORACLE_HOME\ORD\JLIB\ORDVIR.ZIP

   The Oracle interMedia Java Client Library (ORDIM.ZIP) and JDBC OCI driver (CLASSES111.ZIP) must also be in CLASSPATH.

2. Include the JDBC OCI shared library in the PATH.