Config uration Models

Localized Configuration File Support

Directory Server Support

Directory Naming Ove rview

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

Using the Entry's Relative Name

Using the Entry's Absolute Name

Oracle Net Configuration and Directory Server Design

Performance

Security

Schema

Limitations of Directory Naming Support with Mic rosoft Active Directory

4 Architecture of Oracle Net Services

Oracle N et 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

Dedi cated Server Processes

Oracle Connection Manager Architecture
A Complete Architecture

5 Configuration and Administration Tools Overview

User Interface Tools

Oracle Enterprise Manager< /a>

Oracle Net Manager

Selecting When to Use Oracle Enterprise Manager and Oracle Net Manager

Oracle Net Configuration Assista nt

Oracle Net Control Utilities

Listener Control Utility

Oracle Connection Manager 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 Dat abase Server

Task 3: Configure the Client for Connection to a Database

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

Shared Server

Connection Pooling

Session Multiplexing

Availability

< dd>Connect-Time Failover

Client Load Balancing

Naming Methods

JDBC Drivers

Security

Tuning and Performance

Listener Queue Size

Session Data Unit (SDU) Size

Protocol Conversion

Deploying a Network for the Internet

Scalability

Availability

Naming Methods

JDBC Drivers

Security

Access Control

Listener and Database Server Connection Limits

Tuning and Performance

< a href="plan.htm#sthref666">Naming Considerations

Performance Considerations

Listener Queue Size

Session Data Unit Size for Data T ransfer Optimization

Persistent Buffer Flushing for TCP/IP

Planning Summary

8 Configuring Naming Methods

Naming Method Configuration Overview

About Connect Descriptors

Naming Methods

Configuring the Local Naming Method

Configuring the tnsnames.ora File During Installation

Administrator or Runtime Installation

Custom Installation

Configuring the tnsnames.ora File After Installation

T ask 1: Configure Net Service Names

Task 2: Configure TNSNAMES as the First Naming Method< /a>

Task 3: Distribute Configuration

Task 4: Conf igure the Listener

Task 5: Connect to the Database

Configuring the Directory Naming Method

Directory Nam ing Method Configuration Steps

Task 1: Verify Directory Version Compatibility

Task 2: Create or Modify Net Entries

Task 3: C onfigure LDAP as the First Naming Method for Client Lookups

Task 4: Configure the Listene r

Task 5: Connect to the Database

A dministering the OracleNetAdmins Group

Exporting Local Naming Entries to a Directory Nami ng Server

Exporting Net Service Names from a tnsnames.ora File

Creating Multiple Default Contexts in a Directory Naming Server

Exporting Directory Naming Entries to a tnsnames.ora File

Using th e Easy Connect Naming Method

Configuring External Naming Methods

< a href="naming.htm#sthref826">Network Information Service (NIS)

Task 1: Configu re NIS Servers to Support the NIS External Naming

Task 2: Configure Clients

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

9 Configuring Profiles

Profile Configuration Overview

Pro file Configuration During Installation

Configuring Client Attributes for Names Resolutio n

Configuring a Default Domain for Clients

Prioritizing Naming Methods

Routing Connection Requests

Configuring Database Access Control

Configuring Advance d Profile Information

Configuring External Naming Methods

Configuring Oracle Advanced Security

10 Configuring and Administering the Listener

Listener Configuration Overview

Listener Configuration During Insta llation

Customizing Listener Configuration

Configuring Listening Protocol Addresses

Configuring Access to Ora cle JServer

Handling Large Volumes of Concurrent Connection Requests

Configuring Static Service Information

Configuri ng Password Authentication for the Listener

Configuring Service Registrat ion

Configuring Service Registration

Registering Information with the Default, Local Listener

Registering Information with a Nondefault Listener

Registering Information with a Remote Listen er

Configuring a Naming Method

Listener Administration

Starting and Stopping a Listener

Determining the Current Status of a Listener

Monitoring Services of a Listener

Monitoring Listener Log Files

11 Configuring and A dministering Oracle Connection Manager

Oracle Connection Manager Configuration Overview

Configuring Oracle Connection Manager

Configuring the Oracle Connection Manager Computer

Listening Endpoint (ADDRESS)

Access Control Rule List (RULE_LIST)

Parameter List (PARAMETER_LIST)

Configuring Clients for Oracle Connection Manag er

Configuring the Oracle Database Server for Oracle Connection Manager

Service Registration Configuration

Session Multiplexing Configuration

Enabling Oracle Connection Manager Features

Enabling Session Multiplexing

Enabling Access Co ntrol

Migrating cman.ora from Oracle9i to Oracle Database 10g

12 Configuring Dispatchers

Configuring Dispatchers

En abling Connection Pooling

Enabling Session Multiplexing

Grouping Services by Dispatcher

Configuring Clients for Environ ments Using Both Dedicated Server and Shared Server

13 Enabling Advanced Features of Oracle Net Services

Configuring Advanced Network Address and Connect Data Information

Creating a List of Listener Protocol Addresses

Oracle Enterprise Manager

Oracle Net Manager

Configuring Add ress List Parameters

Configuring Advanced Connect Data Parameters

Oracle Enterprise Manager

Oracle Net Manager

Configuring Connection Load Balancing

Example: Connection Load Balancing for Shared Server Configuration

Exampl e: Connection Load Balancing for Dedicated Server Configuration

Configuring Tr ansparent Application Failover

What TAF Restores

Client-Server Database Connections

Users' Database Sessions

Executed Commands

Open Cursors Used for Fetch ing

Active Transactions

Serverside Program Variables

TAF Database Configurations

FAILOVER_MODE Parameters

TAF Implementation

Example: TAF with Connect-Time Failover and Client Load Balancing

Exampl e: TAF Retrying a Connection

Example: TAF Pre-Establishing a Connection

TAF Verification

Specifying the Instanc e Role for Primary and Secondary Instance Configurations

Configuring Connections to Non- Oracle Database Services

Configuring Oracle Net Services for External Procedur es

Default Configuration for External Procedures

Modifying Configuration of External Procedures for Higher Security

Configuring Oracle Net Services for Oracle Heterogeneous Services

Configuring Oracl e Net Services for an Oracle Rdb Database

14 Optimizing Performance

Con figuring Session Data Unit

Configuring I/O Buffer Space

Configuring SDP Protocol Support for Infiniband Network Communication to the Database Server

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

Part III Testing and Troubleshooting Oracle Net Services

15 Establishing a Connection and Testing the Network

Connecting to a Databa se

Starting Oracle Net Services Components

Task 1: Start the Listener

Task 2: Start the Database
Task 3: Start Oracle Connection Manager

En tering a Connect String

Connect Identifier and Connect Descriptor Syntax Char acteristics

Absolute Name Specification for Directory Naming

Initiating Connections

Connecting from the Oper ating System to Test a Client

Connecting from the Tool Logon Screen to Test a Client

Connecting from 3GL to Test a Client

Connec ting Using Special Commands Within Tools

Testing the Network

Testing a Listener

Testing Oracle Con nection Manager

Testing Configuration on the Database Server

Testing Network Connectivity from the Client

TNSPING Util ity

TRCROUTE Utility

Oracle Net Manager

16 Troubleshooting Oracle Net Services

Diagnosing Net8 Servi ces

Server Diagnostics

Task 1: Verify the Database Is Running

Task 2: Perform a Loopback Test

Client Diagnostics

Resolving the Most Common Error Messages for Oracle Net Services

Trou bleshooting Directory Naming Errors

Troubleshooting Tips from the Field f or Oracle Net Services

Questions to Ask When Troubleshooting Oracle Net S ervices

Troubleshooting Network Problems Using Log and Trace Files
Logging Error Information for Oracle Net Services

Oracle Net Error Stacks

Example: Error Stack

Oracle Net Services Log File Names

Setting Logging Parameters

sqlnet.ora Log Parameters

listener.ora Log Parameters

cman.ora Log Paramet ers

Setting Logging Parameters in Configuration Files

Setting Logging Settings During Runtime of Control Utilities

Using Log Files

Analyzing Listener Log Files

Listener Log Audit Trail Information

Listener Servic e Registration Event Information

Listener Direct Hand-Off Information

Analyzing Oracle Connection Manager Logs

CMADMIN Log File Example

Gateway Log File Example

Tracing Error Information for Oracle Net Services

Oracle Net Services Trace File Names

Setting Tracing P arameters

sqlnet.ora Trace Parameters

listener.ora Trace Parameters

cman.ora Trace Parameters

Setting Tracing Parameters in Configuration Files

Setting Tracing Settings During Runtime of Control Utilities

Evaluat ing Oracle Net Services Traces

Flow of Data Packets Between Network Nodes

Oracle Net Data Packet Formats

P ertinent Oracle Net Trace Error Output

Using the Trace Assistant to Exami ne Trace Files

Trace Assistant Syntax

Packet Examples

Two-Task Common Packet Examples

Connection Example

Statistics Example

Contacting Oracle Support Services

Glossary

Index

Contents

Title and Copyright Information

Send Us Your Comments

Preface

What's New in Oracle Net Services?

Part I Getting Started with Oracle Net Services

2 Connectivity Concepts

3 Configuration Management Concepts

4 Architecture of Oracle Net Services

5 Configuration and Administration Tools Overview

6 Quick Start to Oracle Net Connections

Part II Configuration and Administration of Oracle Net Services

7 Planning the Network

8 Configuring Naming Methods

9 Configuring Profiles

10 Configuring and Administering the Listener

11 Configuring and A dministering Oracle Connection Manager

12 Configuring Dispatchers

13 Enabling Advanced Features of Oracle Net Services

14 Optimizing Performance

Part III Testing and Troubleshooting Oracle Net Services

15 Establishing a Connection and Testing the Network

16 Troubleshooting Oracle Net Services

Glossary

Index