Contents

Title and Copyright Information

List of Figures

List of Tables

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

What's New in Oracle Net Services?

Oracle9i Release 2 (9.2) New Features in Oracle Net Services

Oracle9i Release 1 (9.0.1) New Features in Oracle Net Services

Oracle8i New Features in Oracle Net Services

Part I Getting Started with Oracle Net Services

1 Networking Challenges in the Internet Age

What Is the Big Picture for Networking?

Oracle's Solution to Networking Issues

Connectivity

Manageability

Internet and Intranet Scalability

Network Security

A Suite of Networking Components

Oracle Net Services

Oracle Advanced Security

2 Connectivity Concepts

Database Service and Database Instance Identification

Database Services

Database Instances

Service Accessibility

Enhanced Service Accessibility with Multiple Listeners

Service Handlers

Naming

3 Configuration Management Concepts

Configuration Models

Localized Configuration File Support

Directory Server Support

Directory Naming Overview

Naming Configuration Storage in a Directory Server

Net Service Alias Entries

Directory Entries

Adding or Modifying Entries in the Directory Server

Client Connections Using Directory Naming

Oracle Net Configuration and Directory Server Design

Oracle Names Support

Oracle Names Overview

Administrative Regions

Domains

Oracle Names As Data Repository

Data Stored in an Oracle Names Server

Organization of Network Components

Multiple Regions to Decentralize Administrative Responsibilities

Differences Between Versions of Oracle Names

About Discovery

4 Architecture of Oracle Net Services

Oracle Net Stack Communication Architecture

Stack Communication for Client/Server Application Connections

Stack Communication for Java Application Connections

Stack Communication for Web Client Connections

Listener Architecture

Database Server Process Architecture

Shared Server Processes

Dedicated Server Processes

Oracle Connection Manager Architecture

A Complete Architecture

5 Configuration and Administration Tools Overview

Oracle Net Manager

Starting Oracle Net Manager

Navigating Oracle Net Manager

Toolbar

Menus

Oracle Net Manager Wizards

Oracle Net Configuration Assistant

Oracle Net Control Utilities

Listener Control Utility

Oracle Connection Manager Control Utility

Oracle Names Control Utility

Duties of a Network Administrator

6 Quick Start to Oracle Net Connections

Prerequisites to Establishing Connectivity

Task 1: Confirm Network Availability

Task 2: Start the Listener and the Database Server

Task 3: Configure the Client to Use a Net Service Name

Task 4: Connect to the Database

Part II Configuration and Administration of Oracle Net Services

7 Planning the Network

Deploying a Network Inside an Organization

Scalability

Availability

Naming Methods

JDBC Drivers

Security

Tuning and Performance

Deploying a Network for the Internet

Scalability

Availability

Naming Methods

JDBC Drivers

Security

Naming Considerations

Performance Considerations

Listener Queue Size

Session Data Unit Size for Data Transfer Optimization

Persistent Buffer Flushing for TCP/IP

Planning Summary

8 Setting Up Directory Server Usage

Directory Configuration Overview

Configuring Directory Usage During Installation

Directory Usage Configuration During a Custom Installation on the Database Server

Directory Usage Configuration During a Client Installation

Configuring Directory Usage After Installation

Administering the OracleNetAdmins Group

Establishing Access For the OracleNetAdmins Group

Adding Users To the OracleNetAdmins Group

Removing Users From the OracleNetAdmins Group

9 Configuring Naming Methods

Naming Method Configuration Overview

About Connect Descriptors

Naming Methods

Configuring the Local Naming Method

Configuring the tnsnames.ora File During Installation

Configuring the tnsnames.ora File After Installation

Configuring the Directory Naming Method

Directory Naming Method Configuration Steps

Modifying Connectivity Information for Database Service Entries

Creating Net Service Aliases

Configuring the Oracle Names Method

Task 1: Consider Oracle Names Options

Task 2: Install Necessary Components

Task 3: Create an Oracle Names Server

Task 4: Configure Clients and Database Servers To Use Oracle Names Servers

Task 5: (Optional) Configure Client Caches

Task 6: Configure the Listener

Task 7: Register Data with the Oracle Names Server

Task 8: Delegate Domains to Delegated Administrative Regions

Task 9: Specify Domain Hints to Forward Requests to Remote Oracle Names Servers

Task 10: Connect to the Database

Removing an Oracle Names Server

Configuring the Host Naming Method

Task 1: Configure the Listener with the Database Service Information

Task 2: Configure HOSTNAME as the First Naming Method

Task 3: Set Up Host Name Resolution Environment

Task 4: Connect to the Database

Configuring External Naming Methods

Network Information Service (NIS)

Distributed Computing Environment (DCE) Cell Directory Service (CDS)

10 Exporting Naming Data to a Directory Server

Exporting Net Service Names from a tnsnames.ora File

Task 1: Create Structure in Directory Server

Task 2: Create Oracle Contexts

Task 3: Configure Directory Server Usage

Task 4: Export Objects To a Directory Server

Exporting Network Objects from an Oracle Names Server

Client Release Restriction

Database Server Release Restrictions

Exporting Data to a Directory Server

Configuring Oracle Names LDAP Proxy Servers

Considerations for Dissimilar DIT Structures

Considerations for Net Service Aliases

11 Configuring Profiles

Profile Configuration Overview

Profile Configuration During Installation

Configuring Client Attributes for Names Resolution

Configuring a Default Domain for Clients

Prioritizing Naming Methods

Routing Connection Requests

Configuring Database Access Control

Configuring Advanced Profile Information

Configuring Preferred Oracle Names Servers

Configuring External Naming Methods

Configuring Oracle Advanced Security

12 Configuring and Administering the Listener

Listener Configuration Overview

Listener Configuration During Installation

Customizing Listener Configuration

Configuring Listening Protocol Addresses

Configuring Access to Oracle JServer

Handling Large Volumes of Concurrent Connection Requests

Configuring Static Service Information

Configuring Password Authentication for the Listener

Configuring Service Registration

Configuring Service Registration

Registering Information with the Default, Local Listener

Registering Information with a Nondefault Listener

Registering Information with a Remote Listener

Configuring a Naming Method

Listener Administration

Starting and Stopping the Listener

Monitoring Runtime Behavior

Monitoring Log Files

13 Configuring Oracle Connection Manager

Oracle Connection Manager Configuration Overview

Configuring Oracle Connection Manager

Configuring the Oracle Connection Manager Computer

Configuring Clients for Oracle Connection Manager

Configuring the Oracle Database Server for Oracle Connection Manager

Enabling Oracle Connection Manager Features

Enabling Session Multiplexing

Enabling Access Control

Enabling Protocol Conversion Support

14 Configuring Shared Server

Configuring Shared Server with the DISPATCHERS Parameter

Setting the Initial Number of Dispatchers

Enabling Connection Pooling

Allocating Resources

Using Shared Server on Clients

Overriding Shared Server on Clients

15 Enabling Advanced Features of Oracle Net Services

Configuring Advanced Network Address and Connect Data Information

Creating a List of Listener Protocol Addresses

Configuring Address List Parameters

Configuring Advanced Connect Data Parameters

Configuring Connection Load Balancing

Example: Connection Load Balancing for Shared Server Configuration

Example: Connection Load Balancing for Dedicated Server Configuration

Configuring Transparent Application Failover

What TAF Restores

TAF Database Configurations

FAILOVER_MODE Parameters

TAF Implementation

Specifying the Instance Role for Primary and Secondary Instance Configurations

Configuring Session Data Unit

Client Configuration

Database Server Configuration

Configuring Connections to Non-Oracle Database Services

Configuring Oracle Net Services for External Procedures

Configuring Oracle Net Services for Oracle Heterogeneous Services

Configuring Oracle Net Services for an Oracle Rdb Database

Configuring the Listener and the Oracle Database To Limit Resource Consumption By Unauthorized Users

Part III Testing and Troubleshooting Oracle Net Services

16 Establishing a Connection and Testing the Network

Connecting to a Database

Starting Oracle Net Services Components

Entering a Connect String

Initiating Connections

Testing the Network

Testing a Listener

Testing Oracle Connection Manager

Testing Configuration on the Database Server

Testing Network Connectivity from the Client

Testing an Oracle Names Server

Testing Network Objects with Oracle Net Manager or Oracle Names Control Utility

17 Troubleshooting Oracle Net Services

Diagnosing Oracle Net Services

Server Diagnostics

Client Diagnostics

Resolving the Most Common Error Messages for Oracle Net Services

Troubleshooting Directory Naming Errors

Oracle Names LDAP Proxy Server Error Reporting

Troubleshooting Tips from the Field for Oracle Net Services

Questions to Ask When Troubleshooting Oracle Net Services

Troubleshooting Network Problems Using Log and Trace Files

Logging Error Information for Oracle Net Services

Oracle Net Error Stacks

Oracle Net Services Log File Names

Setting Logging Parameters

Setting Oracle Net Log Settings During Runtime of Control Utilities

Using Log Files

Analyzing Listener Log Files

Analyzing Oracle Connection Manager Logs

Oracle Net Services Tracing Error Information

Oracle Net Services Trace File Names

Setting Tracing Parameters

Setting Tracing Settings During Runtime of Control Utilities

Evaluating Oracle Net Services Traces

Using the Trace Assistant to Examine Trace Files

Contacting Oracle Support Services

Glossary

Index