6
Post-Installation Configuration Tasks

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

The chapter focuses on the post-installation configuration of a variety of Oracle products.

What Products Must You Configure?

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.

What Products Must You Configure?

The configuration tasks that you must perform are determined by the products that you install and the network configuration files that you use.

Some products (such as Oracle Enterprise Manager) must always be manually configured. The configuration requirements for other products (such as Oracle options) are determined by how you install the product and the network configuration files that you use.

Review the following table and the sections/documents referenced to identify the configuration that you must perform after product installation and before using them.

Product	Configuration automatic?	See the following for Instructions...
Net8 network software	For server configuration files, configuration is usually automatic. For client configuration files, configuration must typically be manually performed (unless you use the Host Adapter)	Oracle Net8 Administrator's Guide and "Migration Issues for Net8 and SQL*Net" on of the current guide.
Oracle interMedia:	Depends on how product was installed and on the network configuration files used	"Oracle interMedia"
Oracle options:
Oracle Spatial	Dependent on how product was installed	"Oracle Options"
Oracle Time Series	Dependent on how product was installed and network configuration files used	"Oracle Time Series"
Oracle Visual Information Retrieval	Dependent on how product was installed and network configuration files used	"Oracle Visual Information Retrieval"
Oracle COM Automation	Dependent on how product was installed and network configuration files used	Oracle COM Automation Developer's Guide
Oracle Objects	Yes.	No manual configuration is required.
Java	Yes	No manual configuration is required.
Oracle Partitioning	Yes	No manual configuration is required.
Oracle Parallel Server	Dependent on how option was installed.  If Oracle Parallel Server option is installed through the Oracle8i Enterprise Edition Typical installation type path, configuration is automatic.  If Oracle Parallel Server option and the Oracle database are installed together through the Oracle8i Enterprise Edition Custom installation type path, Oracle Database Configuration Assistant is started and prompts you for information before automatically configuring Oracle Parallel Server.  See Oracle Parallel Server Getting Started for Windows NT for more information.	Oracle Parallel Server Getting Started for Windows NT
Multi-threaded server support	Dependent on how support was installed.	"Multi-Threaded Server Support"
Advanced Replication support	Dependent on how support was installed.	"Advanced Replication"
PL/SQL External Procedures	Dependent on network configuration files used.	"Building External Procedures"
Multi-threaded External Clouts	No.	"Enabling Multi-Threaded Callout Support"
Oracle Services for Microsoft Transaction Server	No.	Using Microsoft Transaction Server with Oracle8i

Oracle interMedia

Oracle enables file management in a variety of media, from text, to audio, to video. Files in each medium are managed through a specific "option" such as Oracle interMedia. This section describes interMedia configuration and describes each medium management component.

Audio

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

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

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 interMedia also comes with a sample demonstration that shows how an image is extracted from an Oracle database.

Locator

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

Configuration Responsibility and Syntax

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

If you...	Then...
Installed the Oracle interMedia through the Oracle8i Enterprise Edition Typical installation type path,	No manual configuration is required. All tasks described are automatically performed.
Installed both Oracle interMedia and Oracle 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 interMedia to be automatically configured.
Installed Oracle interMedia during a separate installation from Oracle8i Enterprise Edition	You must manually configure Oracle interMedia by either:  Performing the tasks. 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 6 of Oracle Net8 Administrator's Guide.
Want multi-threaded external callout functionality	Perform the tasks in "Enabling Multi-Threaded Callout Support".
Want to use the demos	Perform the tasks described for the configuration of interMedia sample demos below.
Want to build the interMedia Image sample demonstration	Install a C compiler.
Want to use Oracle Visual Information Retrieval with Oracle interMedia	Install Oracle interMedia first. If you selected both options for installation at the same time, Oracle interMedia was installed first.

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

1. Start SVRMGR:

C:\> SVRMGRL
 
2. Connect to the database with the SYS account:

SVRMGRL> connect SYS/<SYS_PASSWORD> as SYSDBA
 
3. Start the database (if necessary):

SVRMGRL> STARTUP
 
4. Run the ordinst.sql script:

SVRMGRL> @ORACLE_BASE\ORACLE_HOME\ORD\ADMIN\ORDINST.SQL
 
5. Run the iminst.sql script:

SVRMGRL> @ORACLE_BASE\ORACLE_HOME\ORD\IM\ADMIN\IMINST.SQL
 
6. Exit SVRMGRL:

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

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

By installing 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, interMedia Text automatically manages the change.

Configuration Responsibilities and Syntax

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

If you...	Then...
Installed Oracle interMedia Text from the Oracle8i Enterprise Edition CD-ROM and you do not have a previous release of interMedia Text installed (formerly called ConText)	See description below this table.
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 guides Oracle8i interMedia Text Migration and Oracle8i interMedia Text Reference.
If you 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 Oracle 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 installing Oracle8i Enterprise Edition with the Minimal installation type and selecting Yes in the Select Starter Database dialog box.
• The database is a starter database that you created by performing the following sequence of steps:

1. Install Oracle8i Enterprise Edition with the Custom installation type.

 
2. In the Available Product Components dialog box, select Oracle Server.

 
3. When prompted to run Oracle Database Configuration Assistant, click Yes.

 
4. Select the Typical database creation type.

 
5. Select "Copy existing database files from the CD".

 

Additional Information: See Chapter 7, "Starter and Custom Databases" for more information about creating a starter database.

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

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 Oracle database for use with Oracle interMedia Text either at the time you create the database or later.

To configure...	Do this...
At the time you create the database	Select interMedia Text in the Database Cartridges and Options page.
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 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 interMedia Text data dictionary tables and then creating the CTXSYS user name and the interMedia Text data dictionary tables themselves.

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

1. Start SQL*Plus:

C:\> SQLPLUS
 
2. Connect as SYS:

 
3. Enter user-name: SYS/PASSWORD

 
4. Create a tablespace for the 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 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 PASSWORDDEFAULT_
  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 interMedia Text data dictionary tables. Set the default tablespace to the value of TABLESPACE_NAME in step 3 of "Create a tablespace for the interMedia Text data dictionary tables."

 
• TEMPORARY_TABLESPACE_NAME is the temporary tablespace for the interMedia Text data dictionary tables. Set the temporary tablespace to the value of TABLESPACE_NAME in step 3 "Create a tablespace for the interMedia Text data dictionary tables."

 
3. Connect as CTXSYS:

SQL> CONNECT CTXSYS/PASSWORD
 
4. Run the DR0INST.SQL script to create and populate the 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:

 
7. SQL> EXIT

Oracle Options

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 the following table to determine your configuration responsibilities:

If you...	Then...
Installed Oracle Spatial through the Oracle8i Enterprise Edition Typical installation type path	No manual configuration is required. All Oracle Spatial configuration tasks described are automatically performed.
Installed both Oracle Spatial and Oracle 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 prompts you about whether or not you want Oracle Spatial to be automatically configured.
Installed Oracle Spatialduring a separate installation from Oracle8i Enterprise Edition	You must manually configure Oracle Spatialby either:  Performing the Oracle Spatial configuration tasks described Starting Oracle Database Configuration Assistant and selecting Modify a database. Then following the onscreen instructions

Configuring Oracle Spatial:

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

C:\> SQLPLUS
 
2. Connect to the database with the INTERNAL account:

 
3. Enter user-name: INTERNAL

 
4. Start the database (if necessary):

SQL> STARTUP
 
5. Run the ORDINST.SQL script:

SQL> @ORACLE_BASE\ORACLE_HOME\ORD\ADMIN\ORDINST.SQL
Connect to the database as the SYSTEM user:
SQL> CONNECT SYSTEM/PASSWORD
where PASSWORD is MANAGER for the SYSTEM user account by default. If you have changed this password, substitute MANAGER with the correct 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 the 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.

Oracle Time Series

Oracle Time Series stores and retrieves time-stamped data through object data types (ODTs).

Oracle Time Seriesis a building block for applications, rather than being an end-user application. For example, applications can use this option to process historical data derived from financial market transactions, such as trades of stocks, bonds, and mutual fund shares. From this you can find the opening, closing, low, and high prices for a stock on a specific date; calculate monthly volumes for a stock for a specific year; and derive the 30-day moving average for a stock over a year.

Oracle Time Series also comes as a set of demos that provide a sample demonstration of how the product works.

Review the following table to determine your configuration responsibilities.

If you...	Then...
Installed Oracle Time Series through the Oracle8i Enterprise Edition Typical installation type path	No manual configuration is required. All configuration tasks described are automatically performed.
Installed both Oracle Time Series and Oracle 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 prompts you about whether or not you want Oracle Time Seriesto be automatically configured.
Installed Oracle Time Series during a separate installation from Oracle8i Enterprise Edition	You must manually configure Oracle Time Series by either:  Performing the tasks on . Starting Oracle Database Configuration Assistant and selecting Modify a database. Then following the onscreen instructions.
Want to use the demos	Perform the tasks described.
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 Time Series to function properly. Follow the tasks in "Configuring Net8 for External Procedures" in Chapter 6 of Oracle Net8 Administrator's Guide.
Want multi-threaded external callout functionality	Perform the tasks in "Enabling Multi-Threaded Callout Support".

To configure Oracle Time Series:

1. Start SQL*Plus:

C:\> SQLPLUS
 
2. Connect to the database with the INTERNAL account:

 
3. Enter user-name: INTERNAL|

 
4. Start the database (if necessary):

SQL> STARTUP
 
5. Run the ORDINST.SQL script:

SQL> @ORACLE_BASE\ORACLE_HOME\ORD\ADMIN\ORDINST.SQL
 
6. Run the TSINST.SQL script:

SQL> @ORACLE_BASE\ORACLE_HOME\ORD\TS\ADMIN\TSINST.SQL
 
7. Exit SQL*Plus:

SQL> EXIT

The following Oracle Time Series demos are provided in subdirectories of ORACLE_BASE\ORACLE_HOME\ORD\TS.

Demonstration	Directory	What the Demonstration Does
Basic usage	USAGE	Creates a sample database for use with Oracle Time Series and demonstrates several basic queries. This demo is used as the basis for all demos.
Option extension	EXTEND	Includes sample PL/SQL code to extend the functionality of Oracle Time Series with new functions. Oracle Objects option is required to extend Oracle Time Series.
OCI	OCI	Provides C examples of client-side time series access.
Pro*C/C++ Precompiler	PROC	Provides examples of several approaches to client-side time series access. Users must have Pro*C/C++ to build this demo.
Developer 2000	DEV2K	Includes a Developer 2000 Form that incorporates a Developer 2000 Graphic, both of which access data using Oracle Time Series. This demo requires Developer 2000 release 2.0 or later.
Quick Start	TSQUICK	Provides a quick start. This demo uses TSTools to automate the generation of the Oracle Time Series schema for a stock pricing database, then demonstrates several basic queries.
Specialized usage	USAGEUTL	Targets electrical utility applications. Demonstrates how to compute peak and off-peak summaries of 15-minute data.

To configure Oracle Time Series demos:

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

 
2. Read the README file in this directory for an overview of the Oracle Time Series demos.

 
3. Go to the appropriate subdirectory of ORACLE_BASE\ORACLE_HOME\ORD\TS\DEMO for instructions on configuring the demo that you want to use (for example, directory PROC for Pro*C/C++).

 
4. Follow the README file instructions in the subdirectory to configure the demo.

Note: Each of the subdirectories contains a README that provides configuration instructions.

Oracle Visual Information Retrieval

Oracle Visual Information Retrieval stores, retrieves, and manipulates image data managed by an Oracle 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, for example.

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 Enterprise Edition Typical installation type path	No manual configuration is required. All configuration tasks described are automatically performed.
Installed both Oracle Visual Information Retrieval and Oracle 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 Enterprise Edition	You must manually configure Oracle Visual Information Retrieval by either:  Performing the configuration tasks described. Starting Oracle Database Configuration Assistant and selecting "Modify a database". Then, follow the on-screen instructions.
Want to use the demonstrations	Perform the configuration tasks described.
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 "Configuring Net8 for External Procedures" in Chapter 6 of Oracle Net8 Administrator's Guide
Want multi-threaded external callout functionality	Perform the tasks in "Enabling Multi-Threaded Callout Support".

To configure Oracle Visual Information Retrieval:

Ensure that Oracle interMedia is already configured. Oracle interMedia must be configured before Oracle Visual Information Retrieval. See the configuration instructions for Oracle interMedia on for information about running the ordinst.sql and iminst.sql scripts.

1. Start SVRMGRL:

C:\> SVRMGRL
 
2. Connect to the database with the SYS account:

SVRMGRL> connect SYS/<SYS_PASSWORD> as SYSDBA
 
3. Start the database (if necessary):

SVRMGRL> STARTUP
 
4. Run the virinst.sql script:

SVRMGRL> @ORACLE_BASE\ORACLE_HOME\ORD\VIR\ADMIN\VIRINST.SQL
 
5. Run the iminst.sql script:

SVRMGRL> @ORACLE_BASE\ORACLE_HOME\ORD\IM\ADMIN\IMINST.SQL
 
6. Exit SVRMGRL:

SVRMGRL> 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

Multi-Threaded Server Support

Oracle Database Configuration Assistant lets you enable or disable multi-threaded server support in your Oracle database.

Multi-threaded server mode is also called shared server mode.

If your Oracle database is not configured for multi-threaded server mode, then it is configured for dedicated server mode.

The following table describes the differences between dedicated server mode and multi-threaded server mode.

Mode	Description
Dedicated server mode	The Oracle database allocates a resource dedicated to serving only that one client connection.  This mode is best used in the following environments:  Decision support system (DSS) environment. A small number of users will connect to your Oracle database.
Multi-threaded server mode (also called shared 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 Net8 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 a very important criterion for Web applications.) Note: This mode is required for Oracle Java option to function properly.

Additional Information: See the Oracle Net8 Administrator's Guide for more information about multi-threaded server mode.

There are two types of multi-threaded server support:

• Internet Inter-ORB Protocol (IIOP) clients
• Two-task Net8 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
• Both types of support are disabled
• One type of support is enabled, and the other type of support is disabled

The current configuration of your Oracle database depends on how the database was installed.

If installed through...	Then the configuration is...
Oracle8i Enterprise Edition Typical option of Oracle Universal Installer	Multi-threaded server mode for IIOP clients and dedicated server mode for two-task Net8 clients
Oracle8i Enterprise Edition Minimal option of Oracle Universal Installer	Dedicated server mode for both types of clients
Typical option of Oracle Database Configuration Assistant	If you selected Java VM Option, the mode is multi-threaded server mode for IIOP clients.  Dedicated server mode for two-task Net8 clients, unless you perform the following sequence of steps:  Run Oracle Database Configuration Assistant   Select Create a database.    Select Typical.   Select the Create new database files suboption.    Select Online Transaction Processing (OLTP) as your database environment.    Enter 20 or more for the number of concurrent database connections. This creates a database in multi-threaded server mode for two-task Net8 clients.
Custom option of Oracle Database Configuration Assistant	Dedicated server mode or multi-threaded server mode, depending on what you select when prompted by Oracle Database Configuration Assistant.

Enabling Multi-Threaded Server Support for IIOP Clients

Multi-threaded server support for IIOP clients is automatically enabled when you install Oracle Java option.

Enabling Multi-Threaded Server Support for Two-Task Net8 Clients

Multi-threaded support for two-task Net8 clients must be enabled manually.

To enable multi-threaded server support for two-task Net8 clients:

1. Choose Start > Programs > Oracle - HOME_NAME > Oracle Enterprise Management > Database Administration Applications > Oracle Database Configuration Assistant.

The Oracle Database Configuration Assistant welcome page appears.
 
2. Select Modify a database and click Next.

 
3. Select the Oracle database to modify and, if prompted, enter the INTERNAL password.

 
4. Click Next.

 
5. Select Shared Server Mode and click Next.

 
6. Click Next in the options page.

 
7. Make any necessary changes to the multi-threaded server parameters. Click Help for more information about the parameters.

 
8. Click Next.

 
9. Make any necessary changes to the multi-threaded server parameters. Click Help for more information about the parameters.

 
10. Click Finish.

A dialog box prompts you to select the initialization parameter file to use.
 
11. Select the appropriate file and click OK.

Your initialization parameter file is modified.
 
12. Shut down and restart your Oracle database for the changes to take effect.

Disabling Multi-Threaded Server Support for Two-Task Net8 Clients

Multi-threaded support for two-task Net8 clients must be disabled manually.

To disable multi-threaded server support for two-task Net8 clients:

1. Choose Start > Programs > Oracle - HOME_NAME > Oracle Enterprise Management > Database Administration Applications > Oracle Database Configuration Assistant.

The Oracle Database Configuration Assistant welcome page appears.
 
2. Select Modify a database and click Next.

 
3. Select the Oracle database to modify and, if prompted, enter the INTERNAL password.

 
4. Click Next.

 
5. Select Dedicated Server Mode and click Finish.

A dialog box prompts you to select the initialization parameter file to use.
 
6. Select the appropriate file and click OK.

Your initialization parameter file is modified.
 
7. Shut down and restart your Oracle database for the changes to take effect.

Advanced Replication

This section describes how to manually configure Advanced Replication in your Oracle database.

Typically, Advanced Replication is automatically configured during installation. The following figure describes the situations under which Advanced Replication is configured or not configured.

If Advanced Replication is automatically configured, do not follow the instructions in this section. Follow the instructions only if you want to add Advanced Replication to an Oracle database that was not previously configured with this feature.

Configuring advanced replication consists of the following steps:

• Checking Tablespace Requirements
• Checking Initialization Parameters
• Performing Configuration Tasks
• Monitoring Data Dictionary Tables
• Upgrading Advanced Replication

See the Oracle8i Enterprise Edition Installation for Windows NT CD-ROM insert for Advanced Replication installation requirements.

Additional Information: There are many configuration and usage possibilities with Advanced Replication. For more information about advanced replication and for definitions of master sites and snapshot sites, see  Oracle8i Distributed Database Systems Oracle8i Replication Oracle8i Concepts Oracle8i Administrator's Guide

Checking Tablespace Requirements

The following are recommended tablespace requirements for Advanced Replication:

Tablespace	Requirement
SYSTEM	At least 20 MB of free space is required for replication packages. Replication triggers and procedures are stored here.
ROLLBACK SEGMENTS	Rollback Initial Extent = 50 KB Rollback Next Extent = 50 KB
ROLLBACK	At least 5 MB of free space.
TEMPORARY	At least 10 MB of free space.
USER	No specific requirement.

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
SHARED_POOL_SIZE	At least 10 MB; 15 MB if Java was installed, using the Typical installation option, 50 MB if Java was installed, using the Custom installation option.1
DISTRIBUTED_LOCK_TIMEOUT	300 s
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)
JOB_QUEUE_INTERVAL	10 s

1 Java itself requires a POOL_SIZE parameter of 10 MB.

Snapshot Sites

Add these initialization parameters for snapshot sites.

Parameter Name	Recommended Value
JOB_QUEUE_PROCESSES	2
JOB_QUEUE_INTERVAL	60 s

Performing Configuration Tasks

After setting up the INIT.ORA file with the initialization parameters for Advanced Replication, perform the following steps.

To configure Advanced Replication:

1. Start SQL*Plus:

C:\> SQLPLUS
 
2. Connect to the database with the INTERNAL account:

 
3. Enter user-name: INTERNAL

 
4. Start the database if it is not currently running:

SQL> STARTUP
Run the CATREP.SQL script once the database has started.
The script is found in the ORACLE_BASE\ORACLE_HOME\RDBMS\ADMIN directory, and takes approximately one hour to run.
 
5. Spool output to a log file first before running CATREP.SQL.

 
6. Enter the following command:

SQL> SPOOL OUTPUT.LOG
This creates a file called OUTPUT.LOG to which to output all on-screen activity while the SPOOL session is open.
 
7. Run CATREP.SQL:

SQL> @ORACLE_BASE\ORACLE_HOME\RDBMS\ADMIN\CATREP.SQL
 
8. Close the SPOOL file when the script completes running:

SQL> SPOOL OFF
OUTPUT.LOG is saved to your current directory.
 
9. Confirm that CATREP.SQL ran correctly by running a query on ALL_OBJECTS where STATUS = 'INVALID':

SQL> SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID';
If all package bodies compiled successfully, the following message displays:0 rows selected.
 
10. If you find that any of the package bodies compiled incorrectly, recompile them manually. The syntax for running them manually follows:

SQL> ALTER PACKAGE PACKAGE NAME COMPILE BODY;
 
11. If CATREP.SQL ran successfully, a number of replication tables are created in the SYSTEM tablespace. The database is now set up for Advanced Replication support.

 
12. Exit SQL*Plus:

SQL> EXIT
 
13. See Oracle8i Replication for details on setting up the following:
• Master definition site
• Master sites
• Updatable snapshot sites
• Conflict resolution

 

Note: Run the following statement on the master site when setting up updatable snapshot sites:  SVRMGR> GRANT EXECUTE ON DBMSOBJGWRAPPER TO PUBLIC;

Monitoring Data Dictionary Tables

The practical limit to the number of master sites an environment can have is 36. The processes SNP0 to SNP9 (total of 10) and SNPA to SNPZ (total of 26) each handle one destination master at a time.

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.

Upgrading Advanced Replication

If you are upgrading from a previous version of the Oracle database and want to use advanced replication, you must first complete the upgrade. (See Chapter 5, "Installing, Migrating, and Upgrading Databases" in this guide.)

Because advance replication is an advanced feature, see "Oracle8 Replication" for a presentation of its basic concepts before proceeding. For information about available training, contact Oracle Education.

 

---