Understanding SQL*Net

Library

Product

---

• Understanding SQL*Net^®

• Preface

• Introduction to SQL*Net
  • Functions of SQL*Net Version 2
  • SQL*Net Release 2.3 and Other Oracle Network Products
  • SQL*Net's New Features

• SQL*Net Version 2 Architecture
  • SQL*Net Operations
  • How SQL*Net Establishes Connections to a Prestarted Dedicated Server
  • How SQL*Net Establishes Connections to a Multi-Threaded Server
  • Listener Load Balancing

• Network Layout and Naming Issues
  • Plan the Network Layout
  • Choose Whether to Use Oracle Names and the Dynamic Discovery Option
  • Naming Considerations
  • Integrating Oracle into Your Native Naming Environment
  • Prepare to Use the Network Manager
  • Use the Oracle Network Manager

• Migrating from an Earlier Version of SQL*Net
  • Coexistence of SQL*Net Version 1 and Version 2.x
  • Types of SQL*Net Installations
  • Upgrading from Version 1 to Version 2.x
  • Relinking 3GL Applications
  • Moving from SQL*Net Release 2.0 to a Later Release

• Using SQL*Net
  • Testing the Network Configuration
  • Common Errors During Testing
  • Using the Listener Control Utility
  • Modifying Client Parameters
  • Controlling Network Services from Network Manager
  • Initiating a SQL*Net Connection
  • Improving Network Performance
  • Distributed Database Management
  • Copying Data between Databases
  • Support for Operating System Authorized Logins
  • Support for Network Authentication Adapters in Release 2.2

• Configuring Oracle SNMP Support
  • What is the Purpose of SNMP?
  • Oracle SNMP Support for Oracle Services
  • Benefits of Oracle SNMP Support
  • Installing and Configuring Oracle SNMP Support
  • Using Oracle SNMP Support

• Contents of the Configuration Files
  • Overview of the Configuration Files
  • Configuring the Network Listener: LISTENER.ORA
  • Identifying Destinations: TNSNAMES.ORA
  • Configuring Clients: SQLNET.ORA
  • Creating Special Address Parameters: PROTOCOL.ORA
  • Enabling SNMP Support: SNMP.ORA
  • Increasing the Queue Size for the Listeners

• Syntax Rules for Configuration Files
  • Keyword-Value Pair Syntax
  • Further Syntax Rules for TNS Configuration Files
  • Creating the LISTENER.ORA File
  • Creating the TNSNAMES.ORA File
  • Creating the SQLNET.ORA File for Clients and Servers
  • Creating the PROTOCOL.ORA File
  • Creating the TNSNAV.ORA File for Clients and Servers
  • Further Examples

• Common Error Messages
  • Common Sources of Error: Configuration Files
  • Common Sources of Error: Inactive Components
  • Common Error Messages

• SQL*Net OPEN
  • Practical Uses for SQL*Net OPEN
  • Compatibility with Oracle Network Products
  • SQL*Net OPEN Function Calls
  • SQL*Net OPEN API Errors
  • Configuring the System to Use Your Application
  • Sample Programs

• New SQL*Net Tracing Mechanism: Oracle Trace
  • Using Oracle Trace for SQL*Net
  • Oracle Trace Output Files for SQL*Net.

• GLOSSARY

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product