2
Postinstallation Configuration Tasks

This chapter describes some of the 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 Spatial

• Shared Server Support

• Advanced Replication

  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 Multiple Oracle Homes and Optimal Flexible Architecture in the Oracle9i Database Getting Started for Windows for more information.

Oracle interMedia

This section describes the components of Oracle interMedia.

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.

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.

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

Review Table 2-1 to determine how to configure Oracle interMedia Audio, Video, Image, and Locator.

Table 2-1 How to Configure Oracle Intermedia Products

If You...	Then...
Installed the Oracle9i Enterprise Edition Typical installation	No manual configuration is required. All tasks described in "Configuring Oracle interMedia Audio, Video, Image, and Locator" are automatically performed.
Installed the Oracle9i Enterprise Edition	Oracle Database Configuration Assistant starts at the end of installation. If you select the following option: Custom installation, then select the Create new database option
Manually copy your Oracle8i listener.ora and tnsnames.ora files into your Oracle9i network directory	You must modify the tnsnames.ora and listener.ora network configuration files on your server to enable external routine calls to work and interMedia to function properly. Follow the tasks in Oracle9i Net Services Administrator's Guide.
Want to use the demos	Perform the tasks described for the configuration of the Oracle interMedia sample demos below.
Want to build the Oracle interMedia Image sample demonstration	Install a C compiler.

Configuring Oracle interMedia Audio, Video, Image, and Locator

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

1. Start SQL*Plus:

   C:\> SQLPLUS / NOLOG
   

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 demos:

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 Oracle9i. geohttp.sql and geolocat.sql are examples that show the use of Locator functionality. geoindex.sql contains examples of data indexes created by using the Locator.

Oracle Text Configuration Responsibilities

Review Table 2-2 to determine your Oracle Text postinstallation tasks.

Table 2-2 Oracle Text postinstallation tasks

If You...	Then...
Installed Oracle Text from the CD-ROM, and you do not have a previous release of Oracle Text (formerly called interMedia Text) installed	See the description below this table.
Installed Oracle Text from the CD-ROM, and you do have a previous release of Oracle Text (formerly called interMedia Text) installed	See Oracle Text Application Developer's Guide.
Migrated your database, you may need to configure Oracle Net for external routines. Otherwise, Oracle Text may not work. In any case other than migration, Oracle Net should be configured correctly by default to work with Oracle Text.	See Oracle Text Application Developer's Guide and Oracle 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 Oracle Text Reference.

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

• The database is a starter database that you created by installing Oracle9i Enterprise Edition, Oracle9i Standard Edition or Oracle9i Personal Edition.

• The database is a starter database that you created by performing the following sequence of steps:
  1. Installed Oracle9i Enterprise Edition, Oracle9i Standard Edition, or Oracle9i Personal Edition.

  2. Selected Oracle9i Server in the Available Product Components window.

  3. Selected the General Purpose creation type.

     See Also: See Chapter 1, "Postinstallation Database Creation" and the Oracle9i Database installation guide for Windows for more information about creating a starter database.

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

If none of these are true, you must configure the Oracle database for use with Oracle 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 Oracle9i database for use with Oracle Text at the time you create the database or later. Table 2-3 describes how to configure an Oracle9i database

Table 2-3 Configure an Oracle9i database for Use with Oracle Text

To configure...	Do this...
At a later time	Select Configure database options in a database. Select the database that you want to modify when prompted. 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 the Oracle Text data dictionary tables and then creating the ctxsys username and the Oracle Text data dictionary tables themselves.

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

1. Start SQL*Plus:

   C:\> sqlplus / nolog
   

2. Connect as SYS:

   Enter user-name: SYS/password AS SYSDBA
   

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

   SQL> CREATE TABLESPACE tablespace_name DATAFILE 'ORACLE_BASE\oradata\
   
   db_name\dr01.dbf' SIZE 80m;
   

To create the ctxsys username and the Oracle Text data dictionary tables:

1. Connect AS SYSDBA:

   SQL> CONNECT USERNAME/PASSWORD AS SYSDBA
   

2. Run the dr0csys.sql script to create the ctxsys username:

   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 username.

   • default_tablespace_name is the default tablespace for the Oracle 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 Text data dictionary tables:".

   • temporary_tablespace_name is the temporary tablespace for the Oracle 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 Text data dictionary tables:".

3. Connect as ctxsys:

   SQL> CONNECT ctxsys/password
   

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

   SQL> @ORACLE_BASE\ORACLE_HOME\bin\oractxx9.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
   

Oracle Spatial

Oracle Spatial makes the 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. The locations of cities, roads, and political boundaries are projected onto a two-dimensional display or piece of paper, preserving the relative positions and relative distances of the objects.

Review Table 2-4 to determine your configuration responsibilities:

Table 2-4 Configuration Responsibilities

If You...	Then...
Installed Oracle Spatial through the Oracle9i Enterprise Edition	No manual configuration is required. All Oracle Spatial configuration tasks described under "Configuring Oracle Spatial" are automatically performed.
Installed both Oracle Spatial and Oracle9i Server together through the Oracle9i Enterprise Edition or Oracle9i Standard Edition Custom installation	Oracle Database Configuration Assistant starts at the end of installation. If you select the following: Custom installation, and then select Create new database Oracle Database Configuration Assistant prompts you about whether or not you want Oracle Spatial to be automatically configured.
Installed Oracle Spatial during a separate installation from Oracle9i Enterprise Edition	You must manually configure Oracle Spatial by either: Performing the Oracle Spatial configuration tasks described under "Configuring Oracle Spatial" Starting Oracle Database Configuration Assistant and selecting Configure database options in a database.

Configuring Oracle Spatial

1. Start SQL*Plus at the MS-DOS command prompt:

   C:\> sqlplus / nolog
   

2. Connect to the database with the SYSDBA account:

   Enter user-name: 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. Connect to the database as the SYSTEM user:

   SQL> CONNECT SYSTEM/password
   

6. Run the mdinst.sql script:

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

7. Exit SQL*Plus:

   SQL> EXIT
   

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

Shared Server Support

Oracle 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.

Table 2-5 describes the differences between dedicated server mode and shared server mode.

Table 2-5 Dedicated Server Mode and Shared Server Mode Differences

Mode	Description
Dedicated server mode	The Oracle9i database allocates a resource dedicated to serving only that one client connection. This mode is best used in the following environments: Warehousing environment. A small number of users will connect to your Oracle9i 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. This mode is best used in the following environments: Online transaction processing (OLTP) environment A large number of users will simultaneously connect to your database You want to use Oracle Net features such as connection pooling, connection multiplexing, and load balancing Managing and using system resources to a high degree is important Predictable and fast database connection times are very important. This may be very important for Web applications. Note: This mode is required for Oracle9i JVM to function properly.

See Also: Oracle9i Net Services Administrator's Guide for more information about the shared server mode

There are two types of shared server support:

• Internet Inter-ORB Protocol (IIOP) clients

• Two-task Oracle Net clients

These types are independent of each other. In other words, you can have any of the following combinations:

• Both types of support are enabled

• One type of support is enabled, and the other type of support is disabled

Table 2-6 describes how the current configuration of your Oracle9i database depends on how the database was installed.

Table 2-6 Configuration of the Database Based on Installation Method

If installed through...	Then the configuration is...
Oracle9i Enterprise Edition installation	Shared server mode for IIOP clients and dedicated server mode for two-task Oracle Net clients
Typical option of Oracle Database Configuration Assistant	If you selected Oracle9i JVM, the mode is shared server mode for IIOP clients. Dedicated server mode for two-task Oracle Net clients, unless you perform the following sequence of steps: Run Oracle Database Configuration Assistant. Select Create a database. Select New database. Select Shared Server Mode. Choose the Edit Shared Connections Parameters button. On the Basic tab of the Shared Server Mode page enter 20 or more for the maximum number of server processes. This creates a database in shared server mode for two-task Oracle Net clients.
Custom option of Oracle Database Configuration Assistant	Dedicated server mode or shared server mode, depending on what you select when prompted by Oracle Database Configuration Assistant.

Enabling Shared Server Support for IIOP Clients

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

Enabling Shared Server Support for Two-Task Oracle Net Clients

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

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

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

   The Oracle Database Configuration Assistant Welcome page appears. Choose Next.

2. Select Configure database options in a database. Choose Next.

3. Select the Oracle9i database to modify and, if prompted, enter the SYSDBA password.

4. Choose Next.

5. Select Shared Server Mode and choose the Edit Shared Connections Parameters button.

6. On the Basic tab of the Shared Server Mode page make any necessary changes to the shared server parameters. Choose Help for more information about the parameters.

7. Choose OK.

8. Choose Finish.

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

9. Select the appropriate file and choose OK.

   Your initialization parameter file is modified.

10. 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 Oracle 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. Choose 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 the 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 want to add Advanced Replication to an Oracle9i database that was not previously configured with this feature.

Configuring Advanced Replication consists of the following steps:

• Task 1: Checking Tablespace and Rollback Segment Requirements

• Task 2: Checking Initialization Parameters

• Task 3: 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

Task 1: Checking Tablespace and Rollback Segment Requirements

The following are recommended tablespace and rollback segment requirements for Advanced Replication:

Tablespace/Rollback Segment	Requirement
SYSTEM	At least 20 MB of free space is required for replication packages. Replication triggers and procedures are stored here.
UNDO TABLESPACE	At least 10 MB of free space.
RBS	At least 5 MB of free space.
TEMP	At least 10 MB of free space.
USERS	No specific requirement.

Task 2: Checking Initialization Parameters

Certain initialization parameter values must be set or added to the init.ora file (recommended values are included) if you use Advanced Replication.

Master Site

Add these initialization parameters to the master site.

Parameter Name	Recommended Value
JAVA_POOL_SIZE	50 MB
DISTRIBUTED_LOCK_TIMEOUT	300 seconds
DISTRIBUTED_TRANSACTIONS	5
GLOBAL_NAMES	TRUE
OPEN_LINKS	4
PROCESSES	Add 9 to current value
JOB_QUEUE_PROCESSES	2 (depends on number of n-way sites)

Materialized View Sites

Add this initialization parameter for materialized view sites.

Parameter Name	Recommended Value
JOB_QUEUE_PROCESSES	2

Task 3: Monitoring Data Dictionary Tables

If you use Advanced Replication and intend to set up a large number of replicated objects, 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 the storage parameters to accommodate the storage requirements of large numbers of replicated objects.