Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

What's New in Oracle Net Services?

• Oracle Database 11g Release 2 New Features in Oracle Net Services
• Oracle Database 11g Release 1 New Features in Oracle Net Services

Part I Understanding Oracle Net Services

1 Introducing Oracle Net Services

• About Oracle Net Services
  • Understanding Connectivity
  • Understanding Manageability
  • Understanding Shared Server Architecture
  • Understanding Performance
  • Understanding Network Security
• Oracle Net Services Components
  • About Oracle Net
  • About Oracle Net Listener
  • About Oracle Connection Manager
  • About Networking Tools
  • About Oracle Advanced Security

2 Identifying and Accessing the Database

• Understanding Database Instances
• Understanding Database Services
• Connecting to a Database Service
  • About Connect Descriptors
  • About the Protocol Address
  • About Service Registration
• Understanding Service Handlers
  • About Dispatchers
  • About Dedicated Server Processes
  • About Database Resident Connection Pooling
• Understanding Naming Methods
  • Choosing a Naming Method
  • Establishing a Client Session using a Naming Method
  • Entering a Connect String
• Enhancing Service Accessibility using Multiple Listeners
  • About Connect-time Failover
  • About Transparent Application Failover
  • About Client Load Balancing
  • About Connection Load Balancing

3 Managing Network Address Information

• Using Localized Management
• Using a Directory Server for Centralized Management
  • Understanding the Directory Information Tree
  • Understanding Oracle Context
  • Understanding Net Service Alias Entries
  • Who Can Add or Modify Entries in the Directory Server
  • Client Connections Using Directory Naming
  • Considerations When Using Directory Servers
  • Limitations of Directory Naming Support with Microsoft Active Directory

4 Understanding the Communication Layers

• Understanding Oracle Net Stack Communication for Client/Server Applications
  • About the Client Communication Stack
  • About the Server Communication Stack
• Using Oracle Net Stack Communication for Java Applications
• Using Oracle Net Stack Communication for Web Clients
• Understanding Oracle Protocol Support Layer
  • TCP/IP Protocol
  • TCP/IP with SSL Protocol
  • Named Pipes Protocol
  • Sockets Direct Protocol (SDP)

5 Understanding Oracle Net Architecture

• About Service Registration
• About the Listener and Connection Requests
• About Oracle Restart
• About Blocked Connection Requests
• Understanding Database Server Process Architecture
  • About Shared Server Processes
  • About Dedicated Server Processes
• Understanding Oracle Connection Manager Architecture
• Complete Architecture

Part II Configuration and Administration of Oracle Net Services

6 Quick Start to Oracle Net Services

• Prerequisites for Establishing Connectivity
• Confirming Network Availability
• Starting Oracle Net Listener and the Oracle Database Server
• Starting Oracle Connection Manager
• Connecting to the Database
• Using Easy Connect to Connect to a Database

7 Managing Oracle Net Services

• Using the User Interface Tools
  • Using Oracle Enterprise Manager to Configure Oracle Net Services
  • Using Oracle Net Manager to Configure Oracle Net Services
  • Deciding When to Use Oracle Enterprise Manager and Oracle Net Manager
  • Using Oracle Net Configuration Assistant to Configure Network Components
• About the OracleNetAdmins Group
  • Adding Users To the OracleNetAdmins Group
  • Removing Users From the OracleNetAdmins Group
  • Changing Ownership of the OracleNetAdmins Group
• Using Listener Control Utility to Administer the Listener
• Performing Common Network Tasks

8 Configuring Naming Methods

• Using the Easy Connect Naming Method
  • Configuring Easy Connect Naming on the Client
  • Configuring Easy Connect Naming to Use a DNS Alias
  • Examples of Easy Connect Naming Method
• Configuring the Local Naming Method
  • Configuring the tnsnames.ora File During Installation
  • Configuring the tnsnames.ora File After Installation
• Configuring the Directory Naming Method
• Creating Multiple Default Contexts in a Directory Naming Server
• Exporting Local Naming Entries to a Directory Naming Server
• Exporting Directory Naming Entries to a tnsnames.ora File
• Configuring External Naming Methods

9 Configuring and Administering Oracle Net Listener

• Overview of Oracle Net Listener
• Configuring Oracle Net Listener During Installation
• Customizing Oracle Net Listener Configuration
  • Configuring Listening Protocol Addresses
  • Handling Large Volumes of Concurrent Connection Requests
  • Configuring Static Service Information
  • Managing Oracle Net Listener Security
• Configuring Service Registration
  • Setting Initialization Parameters for Service Registration
  • Registering Information with a Local Listener
  • Registering Information with a Remote Listener
  • Registering Information with All Listeners in a Network
  • Configuring a Naming Method
• Administering the Listener
  • Starting and Stopping a Listener
  • Managing a Listener in an Oracle Restart Configuration
  • Determining the Current Status of a Listener
  • Monitoring Services of a Listener
  • Monitoring Listener Log Files

10 Configuring Oracle Connection Manager

• Configuring Oracle Connection Manager
  • Configuring the cman.ora file for the Oracle Connection Manager Host
  • Configuring Clients for Oracle Connection Manager
  • Configuring the Oracle Database Server for Oracle Connection Manager
• Configuring Oracle Connection Manager as a Bridge for IPv4 and IPv6
• Using the Oracle Connection Manager Control Utility to Administer Oracle Connection Manager

11 Configuring Dispatchers

• Configuring Dispatchers
• Grouping Services by Dispatcher
• Enabling Connection Pooling
• Enabling Session Multiplexing
• Configuring Clients for Environments Using Both Shared Server and Dedicated Server

12 Configuring Profiles

• Overview of Profile Configuration
• Configuring the Profile During Installation
• Configuring Client Attributes for Names Resolution
  • Specifying a Default Domain for Clients
  • Prioritizing Naming Methods
  • Routing Connection Requests to a Process
• Configuring Database Access Control
• Configuring Advanced Profile Information
• Configuring External Naming Methods
• Configuring Oracle Advanced Security

13 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 of Connection Load Balancing for Shared Server Configuration
  • Example of Connection Load Balancing for Dedicated Server Configuration
• Configuring Transparent Application Failover
  • About Transparent Application Failover
  • What Transparent Application Failover Restores
  • About FAILOVER_MODE Parameters
  • Implementing Transparent Application Failover
  • Verifying Transparent Application Failover
• Specifying the Instance Role for Primary and Secondary Instance Configurations
• Configuring Connections to Third-party Database Services
  • Default Configuration for External Procedures
  • Configuring Oracle Net Services for Oracle Heterogeneous Services
  • Configuring Oracle Net Services for an Oracle Rdb Database

14 Optimizing Performance

• Configuring Session Data Unit
  • Setting the SDU Size for the Database
  • Setting the SDU Size for the Client
• Determining Bandwidth-delay Product
• Configuring I/O Buffer Space
  • Configuring I/O Buffer Space on the Client
  • Configuring I/O Buffer Size on the Server
• Configuring SDP Support for InfiniBand Connections
  • Prerequisites for Using SDP
  • Configuring SDP on the Server
  • Configuring SDP on the Client
• Limiting Resource Consumption by Unauthorized Users

Part III Testing and Troubleshooting Oracle Net Services

15 Testing Connections

• Testing the Network
• Using the TNSPING Utility to Test Connectivity from the Client
• Using the TRCROUTE Utility to Test Connectivity from the Client

16 Troubleshooting Oracle Net Services

• Understanding Automatic Diagnostic Repository
  • ADRCI: ADR Command Interpreter
• Diagnosing Oracle Net Services
  • Diagnosing Server Problems
  • Diagnosing Client Problems
• Resolving the Most Common Error Messages for Oracle Net Services
  • Troubleshooting Directory Naming Errors
• Troubleshooting Tips for Oracle Net Services
  • Questions to Consider When Troubleshooting Oracle Net Services
• Example of Troubleshooting a TNS-12154 Error
• 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 Logging During Control Utilities Run Time
  • Using Log Files
  • Analyzing Listener Log Files
  • Analyzing Oracle Connection Manager Logs
• Tracing Error Information for Oracle Net Services
  • Oracle Net Services Trace File Names
  • Setting Tracing Parameters
  • Setting Tracing During Control Utilities Run Time
  • Evaluating Oracle Net Services Trace Files
  • Using the Trace Assistant to Examine Trace Files
• Contacting Oracle Support Services

Glossary

Index