2
Postinstallation Configuration Tasks

This chapter describes some configuration tasks you must perform before using Oracle interMedia and other Oracle options. Where appropriate, the chapter provides references to other guides for those configuration tasks.

This chapter contains these topics:

• Oracle interMedia
  
  
• Oracle Text
  
  
• Oracle Spatial
  
  
• Shared Server Support
  
  
• Advanced Replication

  Note: 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, then your directory paths will differ. See "Multiple Oracle Homes and Optimal Flexible Architecture" in Oracle9i Database Getting Started for Windows for more information.

Oracle interMedia

Oracle interMedia includes the following components.

Client

Oracle interMedia Client provides an Oracle9i interMedia Audio, Image, and Video Java interface that lets you use local (client-side) applications to manipulate or modify multimedia data stored in a network-accessible (server-side) database. To use the Java library, set environment variable CLASSPATH so that it contains the Oracle interMedia library.

Client also provides a simple interMedia Image sample (SimpImg.exe) that was developed using Microsoft Visual C++. SimpImg.exe locates and updates images, using interMedia Image in an Oracle9i 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 Oracle9i to support online internet-based geocoding facilities for locator applications and proximity queries.

Configuring Oracle interMedia Audio, Video, Image, and Locator

If you install Enterprise Edition, then Database Configuration Assistant starts automatically at the end of installation. If you choose any Database Configuration Assistant installation type other than Customized, then interMedia does not require manual configuration. All tasks described in this section are performed automatically.

If you select Customized installation, then Database Configuration Assistant will guide you through configuration of Oracle interMedia.

If you are creating and configuring a database manually, then you can configure Oracle interMedia Audio, Video, Image, and Locator as follows:

1. Start SQL*Plus:
   
   

   C:\> sqlplus / NOLOG
   
   

2. Connect to Oracle9i database with account SYS:
   
   

   SQL> CONNECT / AS SYSDBA
   
   

3. Start the database (if necessary):
   
   

   SQL> STARTUP
   
   

4. Run script ordinst.sql:
   
   

   SQL> @ORACLE_BASE\ORACLE_HOME\ord\admin\ordinst.sql
   
   

5. Run script iminst.sql:
   
   

   SQL> @ORACLE_BASE\ORACLE_HOME\ord\im\admin\iminst.sql
   
   

6. Exit SQL*Plus:
   
   

   SQL> EXIT
   
   

   Note: If you manually copy your Oracle8i listener.ora and tnsnames.ora files into your Oracle9i network directory, then you must modify network configuration files tnsnames.ora and listener.ora on your server to enable external routine calls to work and interMedia to function properly. Follow the procedure in Oracle9i Net Services Administrator's Guide.

Configuring Oracle interMedia Demos

To configure Oracle interMedia Audio, Video, and Image demos, follow instructions in readme.txt files at locations shown in Table 2-1.

Table 2-1 interMedia Demo Instructions

Demo	File Location
Audio	ORACLE_BASE\ORACLE_HOME\ord\aud\demo
Video	ORACLE_BASE\ORACLE_HOME\ord\vid\demo
Image	ORACLE_BASE\ORACLE_HOME\ord\img\admin

To make interMedia Image demos for a Microsoft C compiler enter:

C:\> make

An additional demonstration resides in the following location:

ORACLE_BASE\ORACLE_HOME\ord\img\demo\vc\imgsamp\simpimg

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

To configure Oracle interMedia Locator demonstrations, go to the following directory:

ORACLE_BASE\ORACLE_HOME\md\demo\geocoder

Sample data that can be loaded into Oracle9i is in nh_cs.sql. Examples that show use of Locator functionality are in geohttp.sql and geolocat.sql. Examples of data indexes created by using Locator are in geoindex.sql.

Oracle Text

Oracle Text enables text queries through SQL and PL/SQL from most Oracle interfaces. By installing Oracle 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 Text manages textual data in concert with traditional data types in an Oracle database. When text is inserted, updated, or deleted, Oracle Text automatically manages the change.

Configuring Oracle Text

Your Oracle Text postinstallation tasks depend on your situation.

If you install Oracle Text from the CD-ROM and have a previous release of Oracle Text (formerly called interMedia Text) already installed, then see Oracle Text Application Developer's Guide.

If you upgrade your database, then you may be required to configure Oracle Net for external procedures. Otherwise, Oracle Text may not work. In any case other than upgrade, Oracle Net should be configured correctly by default to work with Oracle Text. See Oracle Text Application Developer's Guide and Oracle Text Reference.

If you are indexing formatted documents such as Microsoft Word, then 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 Oracle Text Reference.

Finally, if you install Oracle Text from the CD-ROM and do not have a previous release of Oracle Text installed, then Oracle9i database is already configured for use with Oracle Text if one of the following is true:

• The database is a starter database that you created by installing Enterprise Edition, Standard Edition or Personal Edition.
  
  
• The database is a starter database that you created by performing the following sequence of steps:
  
  
  1. Select Oracle9i Database in the Available Products window.
     
     
  2. Install Enterprise Edition, Standard Edition, or Personal Edition in the Installation Types window.
     
     
  3. Select General Purpose in the Database Configuration window.

     See Also: Chapter 1, "Postinstallation Database Creation" and Oracle9i Database Installation Guide for Windows for more information about creating a starter database

• You created the database by using Database Configuration Assistant in standalone mode, and selected Typical database creation type.

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

• Using Database Configuration Assistant
  
  
• Configuring Manually

Using Database Configuration Assistant

To use Database Configuration Assistant to configure an Oracle9i database for use with Oracle Text at the time you create the database, simply select Oracle Text as the option to configure when prompted. To configure the database at a later time:

1. Start Database Configuration Assistant.

   Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Configuration Assistant.

2. Select Configure database options in a database.
   
   
3. Select the database to modify when prompted.
   
   
4. Select Oracle Text as the option to configure when prompted.

Configuring Manually

Manually configuring an Oracle database for use with Oracle Text consists of creating a tablespace for Oracle Text data dictionary tables and then creating username ctxsys and Oracle Text data dictionary tables.

1. Start SQL*Plus:
   
   

   C:\> sqlplus / NOLOG
   
   

2. Connect Oracle9i database with account SYSDBA:
   
   

   SQL: CONNECT / AS SYSDBA
   
   

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

   SQL> CREATE TABLESPACE tablespace_name DATAFILE 'ORACLE_BASE\oradata\db_
   name\drsys01.dbf' SIZE 80m;
   
   

4. Connect AS SYSDBA:
   
   

   SQL> CONNECT USERNAME/PASSWORD AS SYSDBA
   
   

5. Run script dr0csys.sql to create username ctxsys:
   
   

   SQL> @ORACLE_BASE\ORACLE_HOME\ctx\admin\dr0csys.sql password default_
   tablespace_name temporary_tablespace_name;
   
   

   where:

   • password is the password that you intend to use for username ctxsys.
     
     
   • default_tablespace_name is the default tablespace for Oracle Text data dictionary tables. Set the default tablespace to the value of tablespace_name in step 3.
     
     
   • temporary_tablespace_name is the temporary tablespace for Oracle Text data dictionary tables. Set the temporary tablespace to the value of tablespace_name in step 3.
6. Connect as ctxsys:
   
   

   SQL> CONNECT ctxsys/password
   
   

7. Run script dr0inst.sql to create and populate Oracle Text data dictionary tables:
   
   

   SQL> @ORACLE_BASE\ORACLE_HOME\bin\oractxx9.dll;
   
   

8. 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;
   
   

9. Exit SQL*Plus:
   
   

   SQL> EXIT
   

Oracle Spatial

Oracle Spatial makes storage, retrieval, and manipulation of spatial data easier and more intuitive to users.

One example of spatial data is a road map. A road map is a two-dimensional object that contains points, lines, and polygons representing cities, roads, and political boundaries such as states. A road map represents geographic information. Locations of cities, roads, and political boundaries are projected onto a two-dimensional display or piece of paper, preserving relative positions and relative distances of objects.

If you install Oracle Spatial through Enterprise Edition, then no manual configuration is required. All Oracle Spatial configuration tasks are performed automatically.

If you install both Oracle Spatial and Oracle9i database together through Enterprise Edition or Standard Edition Custom installation, then Database Configuration Assistant starts automatically at the end of installation. If you choose Custom installation and select Create new database, then the assistant asks if Oracle Spatial is to be configured automatically.

If you install Oracle Spatial during a separate installation from Enterprise Edition, then you must either start Database Configuration Assistant and select Configure database options in a database or configure Oracle Spatial manually.

Manually Configuring Oracle Spatial

1. Start SQL*Plus at the command prompt:
   
   

   C:\> sqlplus / NOLOG
   
   

2. Connect to Oracle9i database with account SYSDBA:
   
   

   SQL> CONNECT / AS SYSDBA
   
   

3. Start the database (if necessary):
   
   

   SQL> STARTUP
   
   

4. Run script ordinst.sql:
   
   

   SQL> @ORACLE_BASE\ORACLE_HOME\ord\admin\ordinst.sql
   
   

5. Connect to the database as user SYSTEM:
   
   

   SQL> CONNECT SYSTEM/password
   
   

6. Run script mdinst.sql:
   
   

   SQL> @ORACLE_BASE\ORACLE_HOME\md\admin\mdinst.sql
   
   

7. Exit SQL*Plus:
   
   

   SQL> EXIT
   

   Note: Script mdinst.sql has a variable %MD_SYS_PASSWORD% that Oracle Universal Installer will instantiate at installation time. Therefore, if you have changed the mdsys user's password, then be sure during a manual installation to remember also to update script mdinst.sql with that password.

Shared Server Support

Database Configuration Assistant lets you enable or disable shared server support in your Oracle9i database. If your Oracle9i database is not configured for shared server mode, then it is configured for dedicated server mode.

When Oracle9i database is in dedicated server mode, each client connection is allocated a resource dedicated to serving that client. Dedicated server mode is recommended if:

• The database is used for data warehousing
  
  
• A small number of users will connect to the database

Shared server mode (formerly called multithreaded server mode) enables many client user processes to share a small number of server processes. Many client users can connect to a dispatcher process. The dispatcher process then routes client requests to the next available shared server process. No dedicated server process exists for each client user process for the duration of the connection. Instead, inactive server processes are recycled and used as needed. This reduces system overhead and enables you to increase the number of supported users.

Shared server mode is recommended if

• The database is used for online transaction processing (OLTP)
  
  
• A large number of users will simultaneously connect to the database
  
  
• You intend to use Oracle Net features such as connection pooling, connection multiplexing, and load balancing
  
  
• Careful management and use of system resources is important
  
  
• Predictable and fast database connection times are important (as in Web applications)

  Note: Shared server mode is required for proper functioning of Oracle9i Java Virtual Machine.

By your choice of install options and use of Database Configuration Assistant, you can set shared server support for Java clients, two-task Oracle Net clients, or both.

If you install a database through Enterprise Edition, then the database is automatically configured for shared server mode for Java clients and dedicated server mode for two-task Oracle Net clients.

If you install a database through the typical option of Database Configuration Assistant and select Oracle9i JVM, then the database is configured for shared server mode for Java clients and dedicated server mode for two-task Oracle Net clients.

If you install a database through the Custom option of Database Configuration Assistant, then the database is configured for dedicated server mode or shared server mode, depending on what you select when prompted by the assistant.

Enabling Shared Server Support for Java Clients

Shared server support for Java clients is automatically enabled when you install Oracle9i JVM.

Enabling Shared Server Support for Two-Task Oracle Net Clients

To create a new database and enable shared server mode for two-task Oracle Net clients:

1. Start Database Configuration Assistant.

   Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Configuration Assistant.

   The Database Configuration Assistant Welcome page appears.

2. Select Create a database.
   
   
3. Select New database.
   
   
4. Select Shared Server Mode. Click Edit Shared Connections Parameters.
   
   
5. On the Basic tab of the Shared Server Mode page enter 20 or more for maximum number of server processes.

To enable shared server support for two-task Oracle Net clients on an existing database:

1. Start Database Configuration Assistant.

   Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Configuration Assistant.

   The Database Configuration Assistant Welcome page appears.

2. Click Next.

   A window appears prompting you to select an operation to perform.

3. Select Configure database options in a database. Click Next.
   
   
4. Select the Oracle9i database to modify and, if prompted, enter the SYS password.
   
   
5. Click Next.
   
   
6. Select Shared Server Mode and click Edit Shared Connections Parameters.
   
   
7. On the Basic tab of the Shared Server Mode page make any necessary changes to shared server parameters. Click Help for more information about the parameters.
   
   
8. Click OK.
   
   
9. Click Finish.

   A dialog box prompts you to select the initialization parameter file to use.

10. Select the appropriate file and choose OK.

    Your initialization parameter file is modified.

11. Shut down and restart your Oracle9i database for the changes to take effect.

Disabling Shared Server Support for Two-Task Oracle Net Clients

Shared server support for two-task Oracle Net clients must be disabled manually.

To disable shared server support for two-task Oracle Net clients:

1. Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Configuration Assistant.

   The Database Configuration Assistant Welcome page appears.

2. Select Configure database options in a database and choose Next.
   
   
3. Select the Oracle9i database to modify.
   
   
4. Click Next.
   
   
5. Select Dedicated Server Mode and choose Finish.

   A dialog box prompts you to select the initialization parameter file to use.

6. Select the appropriate file and choose OK.

   Your initialization parameter file is modified.

7. Shut down and restart your Oracle9i database for the changes to take effect.

Advanced Replication

Oracle9i installs replication packages and procedures automatically rather than as a separate manual process. This section describes how to manually configure Advanced Replication in your Oracle9i database.

Follow the instructions only if you add Advanced Replication to an Oracle9i database that was not previously configured with this feature.

Configuring Advanced Replication consists of the following steps:

• Checking Tablespace and Rollback Segment Requirements
  
  
• Adding and Modifying Initialization Parameters
  
  
• Monitoring Data Dictionary Tables

  See Also: There are many configuration and usage possibilities with Advanced Replication. For more information about Advanced Replication and for definitions of master sites and materialized view sites, see the following guides: Oracle9i Replication Oracle9i Database Concepts Oracle9i Database Administrator's Guide

Checking Tablespace and Rollback Segment Requirements

Recommended tablespace and rollback segment requirements for Advanced Replication are shown in Table 2-2.

Table 2-2  Advanced Replication Tablespace/Rollback Segment Requirements

Tablespace/Rollback Segment	Minimum Free Space
SYSTEMFoot 1	20 MB
UNDO TABLESPACE	10 MB
RBS	5 MB
TEMP	10 MB
USERS	No specific requirement

1 Replication triggers and procedures are stored here.

Adding and Modifying Initialization Parameters

If you use Advanced Replication, then certain parameter values must be added to the initialization parameter file, and others must be set to recommended values. Parameter names and values for the master site and materialized view sites are shown in Table 2-3.

Table 2-3  Advanced Replication Initialization Parameters

Parameter Name	Recommended Value	Site
JAVA_POOL_SIZE	50 MB	master
DISTRIBUTED_LOCK_TIMEOUT	300 seconds	master
GLOBAL_NAMES	TRUE	master
OPEN_LINKS	4	master
PROCESSES	Add 9 to current value	master
JOB_QUEUE-PROCESSES	2Foot 1	master
JOB_QUEUE_PROCESSES	2	materialized view

1 Depends on number of n-way sites.

Monitoring Data Dictionary Tables

If you use Advanced Replication and intend to set up a large number of replicated objects, then you are required to monitor the following data dictionary tables with the SQL SELECT command:

• ARGUMENT$
  
  
• IDL_CHAR$
  
  
• IDL_UB1$
  
  
• IDL_UB2$
  
  
• IDL_SB4$
  
  
• I_ARGUMENT1
  
  
• I_SOURCE1I$
  
  
• SOURCE$
  
  
• TRIGGER

If necessary, increase storage parameters to accommodate storage requirements of large numbers of replicated objects.