Table of Contents

Oracle Network Products Getting Started Release 2.3.4 for Windows Platforms

Title

Preface

1 Introducing Oracle Network Products

Oracle Connectivity Overview

Architectural Overview

Oracle Protocol Adapters

Network-Specific Protocol Stack

Client/Server Interaction

Client Connection Request

Server Response to Client Connection Request

2 Supported Oracle Network Products

Oracle Network Products

Oracle Network Products Compatibility

SQL*Net and Net8 Coexistence and Migration

Supported Vendors

16-Bit Support on Windows NT and Windows 95

Oracle Protocol Adapters

TCP/IP Protocol Adapter

SPX Protocol Adapter

DECnet Protocol Adapter

Named Pipes Protocol Adapter

NetBIOS Protocol Adapter

LU6.2 Protocol Adapter

Bequeath Protocol Adapter

SQL*Net Configuration Tools

NDS Native Naming Adapter

SQL*Net Authentication Adapters

NDS Authentication Adapter

Windows NT Authentication Adapter

Advanced Networking Option

Network Security and Single Sign-On

DCE Integration

3 Installation Overview

Installation Results

Verifying Installation

4 Configuration

Configuration Overview

SQL*Net Easy Configuration

Oracle Network Manager

Simple and Complex Network Considerations

Configuring a Network Without Oracle Names

Using SQL*Net Easy Configuration

Using Other SQL*Net Easy Configuration Features

Using Oracle Network Manager

Configuring a Network With Oracle Names

Choosing Whether to Use Oracle Names and the Dynamic Discovery Option

Configuration Steps

Using DDO with SQL*Net Version 2.2 Clients

Testing the Configuration on the Server

Step 1: Set Up for a Loopback Test

Step 2: Perform a Loopback Test on the Server

Testing the Configuration on the Client

Step 1: Verify TCP/IP Network Connections

Step 2: Verify Oracle Database Connections Using TNSPING

Closing a Database Connection

5 Database Connection Tasks

Connecting to a Database from a Client Machine

Step 1: Start Server Services

Step 2: Connect to a Database

Step 3: Close a Database Connection

Connecting from Windows on Windows NT and Windows 95

Connecting to a Remote Database

Connecting to a Local Database

Connecting with the NDS Native Naming Adapter

Connecting with Authentication Adapters

Windows NT Authentication Adapter

NDS Authentication Adapter

Non-NT Authentication Servers

Understanding Windows 3.1x Connection Issues

Setting the LOCAL and REMOTE Parameters

Working with Security for the Named Pipes Protocol Adapter

6 Using the Advanced Networking Option

Setting Up Network Security and Single Sign-On for Windows NT and Windows 95

Biometric (Identix) Authentication Adapter

Configuring the Kerberos Authentication Adapter

Configuring the SecurID Authentication Adapter

Configuring the CyberSAFE Authentication Adapter

Setting Up for Network Security and Single Sign-On for Windows 3.1x

Configuring the CyberSAFE Authentication Adapter

Configuring the Kerberos Authentication Adapter

Using the Oracle Kerberos Utility

Configuring the SecurID Authentication Adapter

A Installed Directory Structure and Files

Understanding the Oracle Network Products Directory Structure

Understanding Oracle Network Products Installed Files

Analyzing SQL*Net Installed Files

Analyzing Oracle Protocol Adapter Installed Files

Analyzing Oracle Names Installed Files

Analyzing Oracle Network Manager Installed Files

Analyzing ANO Installed Files

Verifying Environment Setup

B Verifying Parameters and Vendor Adapters for Windows 3.1x

Verifying File Parameters

Verifying CONFIG.SYS File Contents

Including a DOS Oracle Home Directory in the AUTOEXEC.BAT File

Verifying TCP/IP Protocol Adapter Setup

Loading TSR Transports for TCP/IP

Loading TCP/IP Kernel-Specific Code Before Running Windows TCP/IP Transports

Verifying ORACLE.INI File Contents

Using Windows Socket Vendors

Verifying TCP/IP Vendor File Installation

Loading the TCP/IP Network Software

Enabling Ctrl+C

Verifying SPX Protocol Adapter Setup

Editing the AUTOEXEC.BAT File

Verifying NetBIOS Protocol Adapter Setup

Editing the CONFIG.SYS File or Setting a Default Protocol

Verifying LU6.2 Protocol Adapter for IBM NS/WIN Setup

Editing the AUTOEXEC.BAT AND SYSTEM.INI Files

Editing the NSD.INI File

Configuring Oracle Version 6 Tools

C Modifying Oracle Parameters for Windows 3.1x

Understanding the ORACLE.INI Configuration File

Defining Configuration Parameters

Setting Configuration Parameters

Specifying Alternative Configuration Files

Understanding Configuration Parameters

D Modifying Oracle Configurations for Windows NT and Windows 95

Configuration Parameters

Adding Configuration Parameters

Using the Registry

Using the Control Panel on Windows NT

E Configuration Files

Understanding the Configuration Files

Understanding the TNSNAMES.ORA File

Specifying Connect Descriptors

Specifying Service Names

Configuring Addresses for Oracle Protocol Adapters

Specifying TCP/IP Addresses

Specifying SPX Addresses

Specifying Named Pipes Addresses

Specifying DECnet Addresses

Specifying NetBIOS Addresses

Specifying LU6.2 Addresses

Specifying Bequeath Addresses

Understanding the SQLNET.ORA File

Specifying Dead Connection Detection

Using SQLNET.ORA Logging and Tracing Parameters

Understanding Default Domains

Understanding Client Parameters for Use with Oracle Names Server

Understanding the IPC Parameter

Understanding Authentication, Encryption, and Checksumming Parameters

Understanding the LISTENER.ORA File

Defining the Listener Name

Defining the Listener Address

Describing the Databases on the Listener

Defining Listener Prespawned Dedicated Server Processes

Using LISTENER.ORA Control Parameters

Using Oracle Names

F Services and Port Numbers Used

G Troubleshooting

Diagnosing SQL*Net

Understanding Proper SQL*Net Installation

Server Diagnostics

Client Diagnostics

SQL*Net Logging and Tracing

The Difference Between Logging and Tracing

Tracing for Oracle Names Server

Oracle Trace for SQL*Net

Resolving Common Error Messages and Codes

ORA-12154: Could not resolve service name

ORA-12203:TNS:unable to connect to destination

ORA-12203: TNS: unable to connect to destination and ORA-12154: TNS: could not resolve service name Using 16-bit Applications on Windows NT

ORA-3121: No interface driver connection - function not performed on Windows NT

Resolving Oracle Names Server Problems

Client Connections Not Established

Service Is Not Resolved

SQL*Net Troubleshooting Hints and Tips from the Field

Questions to Ask When Troubleshooting

Contacting Oracle Worldwide Customer Support

How to Contact Oracle Worldwide Customer Support

Before You Call for Assistance

Glossary

Index

Copyright © 1997 Oracle Corporation
500 Oracle Parkway, Redwood Shores, CA 94065 USA