Oracle8i Enterprise Edition for Windows NT Getting Started
Release 8.1.5 for Windows NT

A68694-01

Library

Product

Contents

Index

2
Introducing Oracle8i Enterprise Edition

This chapter introduces you to Oracle8i Enterprise Edition.

Specific topics discussed:

Oracle8i Enterprise Edition Overview
New in this Release
List of Oracle8i Enterprise Edition Products

Oracle8i Enterprise Edition Overview

Oracle8i Enterprise Edition for Windows NT is a development and deployment platform for the Internet.

Oracle8i Enterprise Edition for Windows NT features include the following:

A built-in Java Virtual Machine that lets you store and run Java code within an Oracle database.

Support for the Common Object Request Broker Architecture (CORBA), the Internet Inter-ORB Protocol (IIOP), and Enterprise JavaBeans.

Support for SQLJ, a programming syntax that lets you embed SQL statements in Java programs.

Integration with the Component Object Model (COM) and Microsoft Transaction Server.

Supported Operating Systems

Oracle8i Enterprise Edition client and server software operates on a personal computer (PC), running on the following Microsoft operating systems:

Operating System Oracle Client software Oracle Server software

Windows NT Workstation 4.0

Yes

Yes

Windows NT Server 4.0

Yes

Yes

Windows NT Server 4.0

Yes

Yes

Windows 95

Yes

No

Windows 98

Yes

No

Operating System	Oracle Client software	Oracle Server software
Windows NT Workstation 4.0	Yes	Yes
Windows NT Server 4.0	Yes	Yes
Windows NT Server 4.0	Yes	Yes
Windows 95	Yes	No
Windows 98	Yes	No

4GB RAM Tuning (4GT) for Windows NT Server, Enterprise Edition

Windows NT Server, Enterprise Edition includes a new capability called 4GB RAM Tuning (4GT). This capability allows memory-intensive applications running on Windows NT Server, Enterprise Edition to utilize up to 50% more RAM on Intel Architecture servers. It does this by reducing the potential RAM allocated to the NT kernel from 2 Gigabytes (GB) to 1 GB, and increasing the potential RAM allocated to processes from 2 GB to 3 GB. Note that this capability is not currently available on any other Microsoft operating system.

For Oracle Server releases 7.3.4, 8.0.3, 8.0.4, 8.0.5, 8.1.3, 8.1.4, and 8.1.5 there is no additional Oracle configuration required to take advantage of 4GB RAM Tuning, nor is there a requirement that this feature be enabled in order to use Oracle Server.

To use 4GT for Oracle7 Server release 7.3.3, you must run the Windows NT IMAGECFG.EXE tool at the MS-DOS command prompt:

C:\> IMAGECFG -L ORACLE73.EXE

Additional Information:

See your Microsoft operating system documentation for more information on using 4GB RAM Tuning and the IMAGECFG.EXE tool, or visit:

http://www.microsoft.com

New in this Release

These tables describe the new products and features of release 8.1.5 specific to Windows NT.

Additional Information:

See Getting to Know Oracle 8i for the list of new products and features common to all operating systems.

New Products

This table describes the new products of Oracle8i Enterprise Edition release 8.1.5.

New Product Description For more information, see...

OPERFCFG

OPERFCFG is an Oracle tool that you run from the MS-DOS command prompt to edit the Oracle for Windows NT Performance Monitor's Hostname, Password, and Username registry parameters. OPERFCFG provides an alternative to modifying parameters with REGEDT32, which requires you to manually search through registry subkeys until you find the correct location.

Appendix C, "Oracle 8i Configuration Parameters and the Registry"

Oracle Administration Assistant

A collection of snap-ins that enable you to perform various administrative functions within Microsoft Management Console. These functions consist of starting and stopping the database service, auto-starting Oracle services, viewing information about Oracle background processes, configuring Oracle database users to be authenticated by Windows NT, and editing the registry parameter settings.
Note: Microsoft Management Console must be installed.

Chapter 10, "Authenticating Database Users with Windows NT" and Appendix C, "Oracle 8i Configuration Parameters and the Registry"

Oracle Advanced Security - Export Edition

Provides both encryption and authentication services. Encryption allows data privacy by ensuring that data cannot be read during transmission over a network. RSA, RC4, DES encryption, and MD5 checksumming are all installed automatically with Oracle Advanced Security option. Checksumming ensures that data is not modified during transmission over a network.
Note: Although not a new Oracle product, this product is new to the Oracle8i Enterprise Edition for Windows NT CD-ROM.

Oracle Advanced Security Administrator's Guide

Oracle AppWizard for Microsoft Visual C++

Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment.
Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.

Oracle AppWizard for Microsoft Visual C++ User's Guide

COM Automation Feature

Lets PL/SQL developers programmatically manipulate Component Object Model (COM) objects through the OLE Automation interface (IDispatch). This option provides a PL/SQL package and exposes a set of application programming interfaces (APIs) to instantiate COM objects, get and set their properties, and invoke their methods. PL/SQL developers can call these APIs from PL/SQL subprograms, stored procedures, stored functions, or triggers to manipulate COM objects. There are no restrictions as to where the COM objects can reside. They can be either local to the database server or be accessed remotely through the Distributed Component Object Model (DCOM).

COM Automation Developer's Guide

Oracle Services for Microsoft Transaction Server

Lets application developers create and deploy COM-based applications using Microsoft Transaction Server (MTS) against Oracle8i Enterprise Edition and to have the application transactions coordinated by MTS.
Note: To use Oracle Services for MTS, you must install Microsoft Transaction Server and Microsoft Management Console.

Using Microsoft Transaction Server with Oracle8i

New Product	Description	For more information, see...
OPERFCFG	OPERFCFG is an Oracle tool that you run from the MS-DOS command prompt to edit the Oracle for Windows NT Performance Monitor's Hostname, Password, and Username registry parameters. OPERFCFG provides an alternative to modifying parameters with REGEDT32, which requires you to manually search through registry subkeys until you find the correct location.	Appendix C, "Oracle 8i Configuration Parameters and the Registry"
Oracle Administration Assistant	A collection of snap-ins that enable you to perform various administrative functions within Microsoft Management Console. These functions consist of starting and stopping the database service, auto-starting Oracle services, viewing information about Oracle background processes, configuring Oracle database users to be authenticated by Windows NT, and editing the registry parameter settings. Note: Microsoft Management Console must be installed.	Chapter 10, "Authenticating Database Users with Windows NT" and Appendix C, "Oracle 8i Configuration Parameters and the Registry"
Oracle Advanced Security - Export Edition	Provides both encryption and authentication services. Encryption allows data privacy by ensuring that data cannot be read during transmission over a network. RSA, RC4, DES encryption, and MD5 checksumming are all installed automatically with Oracle Advanced Security option. Checksumming ensures that data is not modified during transmission over a network. Note: Although not a new Oracle product, this product is new to the Oracle8i Enterprise Edition for Windows NT CD-ROM.	Oracle Advanced Security Administrator's Guide
Oracle AppWizard for Microsoft Visual C++	Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment. Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.	Oracle AppWizard for Microsoft Visual C++ User's Guide
COM Automation Feature	Lets PL/SQL developers programmatically manipulate Component Object Model (COM) objects through the OLE Automation interface (IDispatch). This option provides a PL/SQL package and exposes a set of application programming interfaces (APIs) to instantiate COM objects, get and set their properties, and invoke their methods. PL/SQL developers can call these APIs from PL/SQL subprograms, stored procedures, stored functions, or triggers to manipulate COM objects. There are no restrictions as to where the COM objects can reside. They can be either local to the database server or be accessed remotely through the Distributed Component Object Model (DCOM).	COM Automation Developer's Guide
Oracle Services for Microsoft Transaction Server	Lets application developers create and deploy COM-based applications using Microsoft Transaction Server (MTS) against Oracle8i Enterprise Edition and to have the application transactions coordinated by MTS. Note: To use Oracle Services for MTS, you must install Microsoft Transaction Server and Microsoft Management Console.	Using Microsoft Transaction Server with Oracle8i

New Features

This table describes the new features of Oracle8i Enterprise Edition release 8.1.5 specific to Windows NT.

New Feature Description For more information, see...

Optimal Flexible Architecture (OFA)

Provides a structured method for installing Oracle databases and applications in a manner that helps promote ease of maintenance, improved performance, and reliability.

"Optimal Flexible Architecture Overview"
Note: OFA has caused a number of changes to the Oracle directory tree, file names, directory names, and the definition of Oracle home since release 8.0.x. See "Differences Between Directory Trees by Release" for a list of changes.

Operating system authentication of DBA users by default

When you install Oracle8i Enterprise Edition, your Windows NT user name is automatically added to a Windows NT local group called ORA_DBA, giving you DBA access to the Oracle database. Membership in ORA_DBA lets you make connections to the Oracle database without a password.

"Automatically Enabling Operating System Authentication During Installation"

New Feature	Description	For more information, see...
Optimal Flexible Architecture (OFA)	Provides a structured method for installing Oracle databases and applications in a manner that helps promote ease of maintenance, improved performance, and reliability.	"Optimal Flexible Architecture Overview" Note: OFA has caused a number of changes to the Oracle directory tree, file names, directory names, and the definition of Oracle home since release 8.0.x. See "Differences Between Directory Trees by Release" for a list of changes.
Operating system authentication of DBA users by default	When you install Oracle8i Enterprise Edition, your Windows NT user name is automatically added to a Windows NT local group called ORA_DBA, giving you DBA access to the Oracle database. Membership in ORA_DBA lets you make connections to the Oracle database without a password.	"Automatically Enabling Operating System Authentication During Installation"

List of Oracle8i Enterprise Edition Products

Licensing Information

Although the Oracle8i Enterprise Edition for Windows NT CD-ROM in your kit contains many Oracle products, you may install and use only those products for which you have purchased licenses. For additional licensing information, refer to the Global License Terms booklet in your kit.

Oracle Support Services does not provide support for products where licenses have not been purchased.

Oracle Enterprise Manager

Oracle Enterprise Manager is not included on the Oracle8i Enterprise Edition for Windows NT CD-ROM. Oracle Enterprise Manager is shipped on a separate CD-ROM from the Oracle8i Enterprise Edition for Windows NT kit and must be installed in a separate Oracle home from Oracle Server. For more information on Oracle Enterprise Manager, refer to the documentation included on the Oracle Enterprise Manager CD-ROM.

Net8

Net8, which is included on the Oracle8i Enterprise Edition for Windows NT CD-ROM, supports very large scale mission-critical environments. It offers a state-of-the-art security server and simplifies administration and configuration of both large and small environments. See the Net8 Administrator's Guide for a descriptionof Net8 features in general. The features described in the tables beginning are specific to the NT and Windows 95/98 platforms.

Choosing Which Oracle Products to Install

When you run Oracle Universal Installer, you can choose to install products from the Oracle8i Enterprise Edition, Oracle8i Client, or Programmer/2000 installation options.

The following table lists the three installation options, their subset installation types, and the operating systems on which you can install the products.

Installation Option Installation Type Platform

Oracle8i Enterprise Edition

Typical

Installs a preconfigured starter database, licensable Oracle options, networking services, Oracle utilities, and online documentation. This type of installation is recommended for users who want the complete database package.

Minimal

Gives you the option of installing a preconfigured starter database, networking services, and Oracle utilities. This type of installation is recommended for users who want a minimum database package.

Custom

Lets you selectively install any Oracle8i Enterprise Edition product from the CD-ROM.

Windows NT

Oracle8i Client

Typical

Installs components that allow database administrators to connect to an Oracle database and perform database administration.

Custom

Lets you selectively install any Oracle8i Client product from the CD-ROM.

Windows NT
Windows 95
Windows 98

Programmer/2000

Typical

Installs development tools and interfaces for creating applications that access an Oracle database. This installation package includes precompilers, networking services, and documentation.

Custom

Lets you selectively install any Programmer/2000 product from the CD-ROM.

Windows NT
Windows 95
Windows 98

Installation Option	Installation Type	Platform
Oracle8i Enterprise Edition	Typical Installs a preconfigured starter database, licensable Oracle options, networking services, Oracle utilities, and online documentation. This type of installation is recommended for users who want the complete database package. Minimal Gives you the option of installing a preconfigured starter database, networking services, and Oracle utilities. This type of installation is recommended for users who want a minimum database package. Custom Lets you selectively install any Oracle8i Enterprise Edition product from the CD-ROM.	Windows NT
Oracle8i Client	Typical Installs components that allow database administrators to connect to an Oracle database and perform database administration. Custom Lets you selectively install any Oracle8i Client product from the CD-ROM.	Windows NT Windows 95 Windows 98
Programmer/2000	Typical Installs development tools and interfaces for creating applications that access an Oracle database. This installation package includes precompilers, networking services, and documentation. Custom Lets you selectively install any Programmer/2000 product from the CD-ROM.	Windows NT Windows 95 Windows 98

Note:

The Oracle Server database component is available only from the Oracle8i Enterprise Edition installation option and can be installed only on Windows NT.

How Server Installation Options Affect Network Configuration and Services

The installation option you select will have an effect on listener and Client Service Names configuration as well as on NT services.

Listener Configuration

During server installation, the Net8 Configuration Assistant configures the listener as described below.

Installation Type Results

Typical

The Net8 Configuration Assistant runs without user input and configures a default listener named LISTENER for your platform's primary protocol, typically TCP/IP on port 1521. Listener information is stored in file named LISTENER.ORA.

Minimal

The Net8 Configuration Assistant runs without user input and configures a default listener named LISTENER for your platform's primary protocol, typically TCP/IP on port 1521. Listener information is stored in file named LISTENER.ORA.

Custom

The Net8 Configuration Assistant prompts you to configure the following:

Listener name(s)

Protocols to use for listener endpoints

Installation Type	Results
Typical	The Net8 Configuration Assistant runs without user input and configures a default listener named LISTENER for your platform's primary protocol, typically TCP/IP on port 1521. Listener information is stored in file named LISTENER.ORA.
Minimal	The Net8 Configuration Assistant runs without user input and configures a default listener named LISTENER for your platform's primary protocol, typically TCP/IP on port 1521. Listener information is stored in file named LISTENER.ORA.
Custom	The Net8 Configuration Assistant prompts you to configure the following: Listener name(s) Protocols to use for listener endpoints

Client Service Names Configuration

For each client (or Programmer/2000) installation type, the Net8 Configuration Assistant runs without user input and configures a default client profile that contains the Net8 naming domain information. Profile information is stored in a file named SQLNET.ORA.

After the Net8 Configuration Assistant executes, the Net8 Easy Configuration Assistant runs, configuring net service names for the local naming method (TNSNAMES.ORA). See Chapter 6, "Configuring the Naming Methods with the Listener" of the Net8 Administrator's Guide, to configure this method.

If you do not want net service names to reside in the TNSNAMES.ORA, click Cancel and see Chapter 6, "Configuring the Naming Methods with the Listener" of the Net8 Administrator's Guide to configure another naming method.

Windows NT Services

The installation options you choose will have different effects on your Windows NT services, as described below.

Typical and Minimal Installation

The following Windows NT services are installed during a Typical or Minimal installation:

Oracle Service Description Server Client

OracleHOME_NAMEClientCache

Service to enable client caching.

Not started, and set up as Manual Startup.

Yes

Yes

OracleHOME_NAMETNSListener

Service associated with the network listener.

Started, and set up as Automatic Startup.

Yes

No

Oracle Service	Description	Server	Client
OracleHOME_NAMEClientCache	Service to enable client caching. Not started, and set up as Manual Startup.	Yes	Yes
OracleHOME_NAMETNSListener	Service associated with the network listener. Started, and set up as Automatic Startup.	Yes	No

Custom Installation

When you install Oracle Connection Manager, using the Custom Installation option, the following NT services are installed. After configuration, you must start the service(s) you need:

Oracle Service Description

OracleHOME_NAMECMAdmin

Service associated with the Oracle Connection Manager's CMADMIN administrative process. This service registers the Connection Manager with the Oracle Names servers and acquires information about the Oracle Names servers.

Not started, and set up as Manual Startup.

OracleHOME_NAMECMan

Service associated with the Connection Manager's CMGW gateway process.

Not started, and set up as Manual Startup.

Oracle Service	Description
OracleHOME_NAMECMAdmin	Service associated with the Oracle Connection Manager's CMADMIN administrative process. This service registers the Connection Manager with the Oracle Names servers and acquires information about the Oracle Names servers. Not started, and set up as Manual Startup.
OracleHOME_NAMECMan	Service associated with the Connection Manager's CMGW gateway process. Not started, and set up as Manual Startup.

Oracle8i Enterprise Edition

This table describes the Oracle products that are available when you select the Oracle8i Enterprise Edition installation option.

Oracle8i Enterprise Edition can be installed only on Windows NT.

Oracle8i Enterprise Edition Products Typical Minimal Custom

Assistant Common Files
A collection of files required by Oracle assistants.

Yes

Yes

Yes

Legato Storage Manager (LSM)
Using Oracle Recovery Manager (RMAN.EXE) for Oracle database backups requires the installation of a media management product in order to back up and restore from tape storage. You can choose to install the media management product supplied with Oracle8i Enterprise Edition, which is LSM, or use a third-party media management product that also complies with Oracle's Backup Solutions Program. LSM also includes a scaled-down version of Legato NetWorker.
The installer prompts you to confirm whether or not you want to install LSM. When you confirm installation, LSM is installed automatically.
For more information on this product, call toll free (1) 888-8-LEGATO in the United States of America, or visit Legato's Oracle backup and recovery Web site:
http://www.backup-oracle.com/

N/A

N/A

Yes

Net8 Client
Provides products that enable client connection to databases across a network. A client-side application sends a request to Net8 to be transported across the network to the server.

Yes

Yes

Yes

Net8 Configuration Tools:

Net8 Configuration Assistant

Oracle recommends using the Net8 Configuration Assistant to configure certain Net8 client and server components after installation.

Net8 Configuration Assistant can also be run in stand-alone mode to configure naming methods, net service names, and the listener.¹

To start Net 8 Configuration Assistant:

Choose Start>Programs>Oracle-Home_Name>Network Administration>Net8 Configuration Assistant.

Additional Information: See Chapter 5: "Considerations for Upgrades and Migration and Chapter 7: "Enabling Optional Net8 Features" of the Net8 Administrator's Guide.

Yes

Yes

Yes

Net8 Assistant

Helps you configure and administer the SQLNET.ORA file, the TNSNAMES.ORA file, the LISTENER.ORA file, and Oracle Names Servers.

Yes

Yes

Yes

Net8 Easy Config

This Java-based tool lets you set up net service names in the TNSNAMES.ORA file. Use this tool for configuring simple networks and testing the configuration.

Yes

Yes

Yes

Trace Assistant

Formats level-16 SUPPORT traces into paragraphs that are easier to read than unformatted trace files.

Yes

Yes

Yes

Net8 Server

Provides products that allow the network listener, through a protocol, to accept connections from client applications on the network.

Note: Net8 Server will not be installed if you select Oracle 8i Client or Programmer/2000.

Yes

Yes

Yes

Net8 clients communicate with Oracle servers through net service names that are easy-to-remember aliases for database addresses. Net8 resolves net service names using the following naming methods:

Host Naming

Local Naming

Oracle Names

External Naming: NetWare Directory Service [NDS]

See Chapter 6: "Configuring Naming Methods and the Listener" of the Net8 Administrator's Guide for more information.

Yes

Yes

Yes

Net8 Support for the following protocols:²

Net8 Client (and not Oracle Universal Installer) installs TCP/IP and Named Pipes and auto-detects SPX. SPX is only installed in the installation packages if the appropriate software is detected on your system. If you explicitly select this product in the Custom installation type, it will be installed even if you do not have the appropriate software on your computer.

TCP/IP

Enables client/server conversation over a network using TCP/IP and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP/IP (if the Oracle database is running on a host system that supports network communication using TCP/IP).

Yes

Yes

Yes

SPX

Enables client/server conversation over a network using SPX/IPX and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through SPX/IPX (if the Oracle database is running on a host system that supports network communication using SPX/IPX). This protocol is predominantly used in Novell Netware environments.

Yes

Yes

Yes

Named Pipes

Enables client/server conversation over a network using Named Pipes and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through Named Pipes (if the Oracle database is running on a host system that supports network communication using Named Pipes).

Yes

Yes

Yes

Bequeath

Enables clients to retrieve information from the database without using the network listener. The Bequeath protocol internally spawns a server thread for each client application. In a sense, it does the same operation that a remote network listener does for your connection, but locally.

Bequeath has the following attributes:

Does not use a network listener (therefore, no network listener configuration is required)

Used for local connections where an Oracle client application (such as SQL*Plus) communicates with an Oracle server running on the same machine

Only works in Dedicated Server mode. Cannot be used in a Multi-Threaded Server (MTS) mode.

Supported on Windows NT for 32-bit applications. Also works on Windows 95 for connections to a Oracle8i Personal Edition database for 32-bit applications.

Installed by default with Net8 Client

Yes
(installed with Net8 Client and Net8 Server)

Yes
(installed with Net8 Client and Net8 Server)

N/A
(installed with Net8 Client and Net8 Server)

Logical Unit Type 6.2 (LU6.2) Protocol Adapter

The adapter is part of the IBM Advanced Program-to-Program Communication (APPC) architecture.

APPC is the IBM peer-to-peer (program-to-program) protocol for a System Network Architecture (SNA) network. SNA is an IBM reference model similar to the Open Systems Interconnect (OSI) model of the International Standards Organization (ISO).

APPC architecture lets the client and host communicate over an SNA network without forcing the client to emulate a terminal (as in terminal-to-host protocols). APPC architecture allows peer-to-peer communication; the client can initiate communication with the server.

An SNA network with the LU6.2 and Physical Unit Type 2.1 (PU2.1) protocols provides APPC. The LU6.2 protocol defines a session between two application programs; LU6.2 is a product-independent LU-type.

The LU6.2 Protocol Adapter enables an Oracle application on a PC to communicate with an Oracle database. This communication occurs over an SNA network with the Oracle database on a host system that supports APPC.

Yes

No

Yes

Net8 Scalability Features

Scalability refers to the ability to support simultaneous network access by a large number of clients to a single server. Net8 accomplishes this by optimizing the use of network resources by reducing the number of physical network connections a server must maintain. See the Net8 Administrator's Guide for more information about the following scalability-related features:

Oracle Connection Manager's Connection Concentration

No

No

Yes

Multi-Threaded Server Support (MTS) (in TCP/IP networks)

Connection Pooling (available only with MTS on TCP/IP networks)

Support for WINSOCK2 on Windows NT

Net8 supports both the WINSOCK 1.1 AND WINSOCK2 socket interface. Net8 automatically detects WINSOCK2 on Windows NT and uses it if it is available.

WINSOCK2 is a standard feature of the Windows NT release 4.0 operating system. Oracle uses these WINSOCK2 features in Net8:

Overlapped I/O with events

Shared sockets (can be enabled as an optional feature), as described in Appendix C, "Oracle 8i Configuration Parameters and the Registry."

Yes

Yes

Yes

Net8 Security Features:

Oracle Connection Manager's Net8 Access Control

Incorporates a Net8 application proxy for implementing firewall-like functionality. See Chapter 6: "Enabling Connection Concentration" of the Net8 Administrator's Guide.

No

No

Yes

Oracle Advanced Security--Export Edition

Ensures secure transmission of data over networks. Uses encryption and authentication engines from RSA Data Security, Inc. See the Oracle Advanced Security Administrator's Guide for more information.

Available algorithms:

Encryption

RC4_40
DES_40
Checksumming
MD5

Yes

No

Yes

Oracle Advanced Security Single Sign-On

Allows users to access multiple accounts and applications with a single password. This feature eliminates the need for multiple user passwords and simplifies administration of user accounts and passwords.

Centralized, secure authentication services ensure high confidence in the identity of users, clients, and servers in distributed environments. Network authentication services can also provide the benefit of single sign-on for users.

Support exists for the following authentication methods:

Kerberos

RADIUS

SSL

SecurID

Identix

CyberSafe

Yes

No

Yes

Net8 Enhancements for Developers:

Net8 OPEN

An application programming interface (API) that lets developers write applications that use Net8 for connectivity. Net8 OPEN offers the following benefits:

Enables development of both database and non-database applications that use an already deployed Net8 network

Enables deployment of an application developed on one machine to another without having to modify calls to the network interface.

Provides a single common interface to all industry standard network protocols.

For more information, see the Net8 Administrator's Guide.

Yes

Yes

Yes

Object Type Translator (OTT)

OTT (executable name OTT.EXE) is used to create C-struct representations of Abstract Data Types that have been created and stored in an Oracle database. To take advantage of objects, run OTT against the database, and a header file is generated that includes the C-structs.

Oracle INTYPE File Assistant

An assistant that helps you to create an INTYPE file, which provides a list of types for OTT to translate.

Yes

No

Yes

Oracle Snap-In Common Files

A collection of snap-ins that let you perform various administrative functions within Microsoft Management Console.

Oracle Administration Assistant for Windows NT

Lets you start and stop the Oracle database service, auto-start Oracle services, view information about Oracle background processes, and configure Oracle database users to be authenticated by Windows NT.

Oracle Remote Configuration Agent
Facilitates configuration and monitoring of remote Oracle databases.

Yes

Yes

Yes

Oracle AppWizard for Microsoft Visual C++

Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment.

Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.

No

No

Yes

Oracle Call Interface (OCI)

An application programming interface (API) for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements.

Yes

No

Yes

COM Automation

Enables PL/SQL developers to programmatically manipulate COM objects through the OLE Automation interface (IDispatch).

Yes

No

Yes

Oracle Connection Manager

Lets you multiplex multiple logical client sessions through a single transport connection to an Oracle server destination.

No

No

Yes

Oracle interMedia

Oracle enables file management in a variety of media, from text to audio, to video. Files in each medium are managed through a specific component of interMedia as described below.

Image

Provides for the storage, retrieval, and processing of two-dimensional, static bitmapped images. Images are stored efficiently using popular compression schemes in industry-standard desktop publishing image interchange formats.

Audio
Provides for the storage, retrieval and management of digitized audio data within an Oracle database.

Video
Provides for the storage, retrieval and management of digitized video data within an Oracle database.

Text
Enables text queries to be performed through SQL and PL/SQL from most Oracle interfaces. By installing Oracle interMedia Text with Oracle8i Enterprise Edition, client tools such as SQL*Plus, Oracle Forms, and Pro*C/C++ are able to retrieve and manipulate text in an Oracle database.

Locator
Enables Oracle8i to support online internet-based geocoding facilities for locator applications and proximity queries.

This multi-component product requires a separate license.

Yes

No

Yes

Oracle options

Spatial

Oracle Spatial makes the storage, retrieval, and manipulation of spatial data easier and more intuitive to users.
Time Series

Oracle Time Series stores and retrieves time-stamped data through object data types (ODTs).

These products require a separate license.

Yes

No

Yes

Oracle Data Migration Assistant

Lets you migrate your existing Oracle7 database (release 7.1.3.3.6 or later) or upgrade previous releases of Oracle8 and Oracle8i to the current Oracle8i database release.

Yes

Yes

Yes

Oracle Database Configuration Assistant

Lets you create, modify, and delete databases.

Yes

Yes

Yes

Oracle Documentation

Available in HTML, viewable using a Web browser. A PDF version is also available but is not automatically installed. You can find the PDF documentation on the CD-ROM in the PDFDOC directory. The Adobe Acrobat Reader is located in the ACROREAD directory.

Yes

Yes

Yes

Oracle for Windows NT Performance Monitor

Enables database administrators to monitor local and remote database performance through the Windows NT Performance Monitor.

Yes

No

Yes

Oracle Intelligent Agent

Responds to, schedules, and executes database administration job requests initiated by the Oracle Enterprise Manger Console.

Yes

Yes

Yes

Oracle Java Database Connectivity (JDBC) Drivers

A standard set of Java classes, specified by JavaSoft, that provide vendor-independent access to relational data from Java.

Yes

Yes

Yes

Oracle Java option

Provides a JDK 1.1.6-compliant Java Virtual Machine, a CORBA 2.0 Object Request Broker, an embedded JDBC driver, a SQLJ translator, and an Enterprise JavaBeans transaction server.

Yes

No

Yes

Oracle Java Tools

Provides Java tools to build and deploy Java stored procedures, CORBA objects, and Enterprise JavaBeans with Oracle's Java Virtual Machine.

Yes

No

Yes

Oracle Names

A distributed naming service developed for Oracle environments to help simplify the setup and administration of global, client/server computing networks. Oracle Names does this by establishing and maintaining an integrated system of Names servers. Oracle Names servers work like a directory service storing addresses for all the database services on a network and making them available to clients that want to make a connection. See the Net8 Administrator's Guide for more information on this product.

No

No

Yes

Oracle Objects for Object Linking and Embedding (OLE)

A custom control (OCX or ActiveX) combined with an OLE in-process server that lets you plug native Oracle8i Enterprise Edition functionality into your Windows applications.

Yes

Yes

Yes

Oracle Objects Functionality

Lets you create and manipulate objects, as well as to integrate objects with standard relational functionality.

Yes

No

Yes

Oracle Open Database Connectivity (ODBC) Driver

Provides support for ODBC connections from Windows NT, Windows 95, and Windows 98 client systems to Oracle databases. The Oracle ODBC Driver complies with version 3.00 of the Microsoft ODBC specification and supports all ODBC Core and the following Level 1 and Level 2 calls:

SQLBrowseConnect

SQLColumnPrivileges

SQLDescribeParam

SQLForeignKeys

SQLMoreResults

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLTablePrivileges

Yes

Yes

Yes

Oracle Parallel Server

Enables multiple Oracle instances to share a single Oracle database. This product requires a separate license.

The following product is automatically installed when you install Oracle Parallel Server option:

Oracle Parallel Server Manager

Enables Oracle Parallel Server nodes to manage multiple parallel server instances.

Yes

No

Yes

Oracle Partitioning option

Provides more control in managing tables and indexes by directing all maintenance operations to individual partitions rather than to tables and index names. This product requires a separate license.

Yes

No

Yes

Oracle Server

The database component of Oracle8i Enterprise Edition software.

Yes

Yes

Yes

Oracle Services for Microsoft Transaction Server

Provides full integration of Oracle8i Enterprise Edition release 8.1.5 with Microsoft Transaction Server (MTS). This product offers a solution to develop and deploy COM-based applications using MTS against Oracle8i release 8.1.5.

No

No

Yes

Oracle SNMP Agent

Oracle SNMP Agent allows Oracle products to be located, identified, and monitored by any SNMP-based network management system.

No

No

Yes

Oracle SQLJ Translator
A preprocessor for Java programs that contain embedded SQL statements. Oracle SQLJ Translator converts the SQL statements to JDBC calls.

Yes

No

Yes

Oracle Universal Installer

A GUI application that lets you quickly install, update, and remove Oracle products. Oracle Universal Installer also automatically installs Oracle Home Selector, a tool that lets you edit your environmental path to make an appropriate Oracle home directory your primary home.

Yes

Yes

Yes

Oracle Utilities

A suite of products used for database administration. Oracle Utilities include Server Manager, Export Utility, Import Utility, ORADIM, SQL*Loader, DBVERIFY, TKPROF, Migration Utility, Recovery Manager, OCOPY, and the Password Utility.

Yes

Yes

Yes

Oracle Visual Information Retrieval

Provides image storage, content-based retrieval, and format conversion capabilities through an object data type. This option is a building block for various imaging applications, rather than being an end-user application. Some common applications for this option consist of digital art galleries and museums, real estate marketing, document imaging, and stock photo collections for fashion designers and architect.

A demonstration is also available.

Yes

No

Yes

Oracle Web Publishing Assistant

Lets you query a database and publish the data retrieved on a Web page.

Yes

No

Yes

Oracle8i Enterprise Edition Release Notes

Important last-minute installation and configuration information that you should read before using Oracle products.

Yes

Yes

Yes

¹ The NT platform version of Net8 does not support prespawned dedicated server processes by the listener. Therefore, do not include the following parameters in the SID_DESC's of the LISTENER.ORA file: PRESPAWN_MAX, PROTOCOL, POOL_SIZE, TIMEOUT.
² Installation of some stand-alone TCP/IP and TCP/IP with SSL, SPX, and Named Pipes protocols is done, based on automatic detection of your system protocol stacks.

Oracle8i Enterprise Edition Products	Typical	Minimal	Custom
Assistant Common Files A collection of files required by Oracle assistants.	Yes	Yes	Yes
Legato Storage Manager (LSM) Using Oracle Recovery Manager (RMAN.EXE) for Oracle database backups requires the installation of a media management product in order to back up and restore from tape storage. You can choose to install the media management product supplied with Oracle8i Enterprise Edition, which is LSM, or use a third-party media management product that also complies with Oracle's Backup Solutions Program. LSM also includes a scaled-down version of Legato NetWorker. The installer prompts you to confirm whether or not you want to install LSM. When you confirm installation, LSM is installed automatically. For more information on this product, call toll free (1) 888-8-LEGATO in the United States of America, or visit Legato's Oracle backup and recovery Web site: `http://www.backup-oracle.com/`	N/A	N/A	Yes
Net8 Client Provides products that enable client connection to databases across a network. A client-side application sends a request to *Net8* to be transported across the network to the server.	Yes	Yes	Yes
Net8 Configuration Tools:
Net8 Configuration Assistant Oracle recommends using the Net8 Configuration Assistant to configure certain Net8 client and server components after installation. Net8 Configuration Assistant can also be run in stand-alone mode to configure naming methods, net service names, and the listener.¹ To start Net 8 Configuration Assistant: Choose Start>Programs>Oracle-Home_Name>Network Administration>Net8 Configuration Assistant. Additional Information: See Chapter 5: "Considerations for Upgrades and Migration and Chapter 7: "Enabling Optional Net8 Features" of the Net8 Administrator's Guide.	Yes	Yes	Yes
Net8 Assistant Helps you configure and administer the `SQLNET.ORA` file, the `TNSNAMES.ORA` file, the `LISTENER.ORA` file, and Oracle Names Servers.	Yes	Yes	Yes
Net8 Easy Config This Java-based tool lets you set up net service names in the TNSNAMES.ORA file. Use this tool for configuring simple networks and testing the configuration.	Yes	Yes	Yes
Trace Assistant Formats level-16 SUPPORT traces into paragraphs that are easier to read than unformatted trace files.	Yes	Yes	Yes
Net8 Server Provides products that allow the network listener, through a protocol, to accept connections from client applications on the network. Note: Net8 Server will not be installed if you select Oracle 8i Client or Programmer/2000.	Yes	Yes	Yes
Net8 clients communicate with Oracle servers through net service names that are easy-to-remember aliases for database addresses. Net8 resolves net service names using the following naming methods:
Host Naming Local Naming Oracle Names External Naming: NetWare Directory Service [NDS] See Chapter 6: "Configuring Naming Methods and the Listener" of the Net8 Administrator's Guide for more information.	Yes	Yes	Yes
Net8 Support for the following protocols:² Net8 Client (and not Oracle Universal Installer) installs TCP/IP and Named Pipes and auto-detects SPX. SPX is only installed in the installation packages if the appropriate software is detected on your system. If you explicitly select this product in the Custom installation type, it will be installed even if you do not have the appropriate software on your computer.
TCP/IP Enables client/server conversation over a network using TCP/IP and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP/IP (if the Oracle database is running on a host system that supports network communication using TCP/IP).	Yes	Yes	Yes
SPX Enables client/server conversation over a network using SPX/IPX and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through SPX/IPX (if the Oracle database is running on a host system that supports network communication using SPX/IPX). This protocol is predominantly used in Novell Netware environments.	Yes	Yes	Yes
Named Pipes Enables client/server conversation over a network using Named Pipes and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through Named Pipes (if the Oracle database is running on a host system that supports network communication using Named Pipes).	Yes	Yes	Yes
Bequeath Enables clients to retrieve information from the database without using the network listener. The Bequeath protocol internally spawns a server thread for each client application. In a sense, it does the same operation that a remote network listener does for your connection, but locally. Bequeath has the following attributes: Does not use a network listener (therefore, no network listener configuration is required) Used for local connections where an Oracle client application (such as SQLPlus) communicates with an Oracle server running on the same* machine Only works in Dedicated Server mode. Cannot be used in a Multi-Threaded Server (MTS) mode. Supported on Windows NT for 32-bit applications. Also works on Windows 95 for connections to a Oracle8i Personal Edition database for 32-bit applications. Installed by default with Net8 Client	Yes (installed with Net8 Client and Net8 Server)	Yes (installed with Net8 Client and Net8 Server)	N/A (installed with Net8 Client and Net8 Server)
Logical Unit Type 6.2 (LU6.2) Protocol Adapter The adapter is part of the IBM Advanced Program-to-Program Communication (APPC) architecture. APPC is the IBM peer-to-peer (program-to-program) protocol for a System Network Architecture (SNA) network. SNA is an IBM reference model similar to the Open Systems Interconnect (OSI) model of the International Standards Organization (ISO). APPC architecture lets the client and host communicate over an SNA network without forcing the client to emulate a terminal (as in terminal-to-host protocols). APPC architecture allows peer-to-peer communication; the client can initiate communication with the server. An SNA network with the LU6.2 and Physical Unit Type 2.1 (PU2.1) protocols provides APPC. The LU6.2 protocol defines a session between two application programs; LU6.2 is a product-independent LU-type. The LU6.2 Protocol Adapter enables an Oracle application on a PC to communicate with an Oracle database. This communication occurs over an SNA network with the Oracle database on a host system that supports APPC.	Yes	No	Yes
Net8 Scalability Features Scalability refers to the ability to support simultaneous network access by a large number of clients to a single server. Net8 accomplishes this by optimizing the use of network resources by reducing the number of physical network connections a server must maintain. See the Net8 Administrator's Guide for more information about the following scalability-related features:
Oracle Connection Manager's Connection Concentration	No	No	Yes
Multi-Threaded Server Support (MTS) (in TCP/IP networks) Connection Pooling (available only with MTS on TCP/IP networks) Support for WINSOCK2 on Windows NT Net8 supports both the WINSOCK 1.1 AND WINSOCK2 socket interface. Net8 automatically detects WINSOCK2 on Windows NT and uses it if it is available. WINSOCK2 is a standard feature of the Windows NT release 4.0 operating system. Oracle uses these WINSOCK2 features in Net8: Overlapped I/O with events Shared sockets (can be enabled as an optional feature), as described in Appendix C, "Oracle 8i Configuration Parameters and the Registry."	Yes	Yes	Yes
Net8 Security Features: Oracle Connection Manager's Net8 Access Control Incorporates a Net8 application proxy for implementing firewall-like functionality. See Chapter 6: "Enabling Connection Concentration" of the Net8 Administrator's Guide.	No	No	Yes
Oracle Advanced Security--Export Edition Ensures secure transmission of data over networks. Uses encryption and authentication engines from RSA Data Security, Inc. See the Oracle Advanced Security Administrator's Guide for more information. Available algorithms: Encryption RC4_40 DES_40 Checksumming MD5	Yes	No	Yes
Oracle Advanced Security Single Sign-On Allows users to access multiple accounts and applications with a single password. This feature eliminates the need for multiple user passwords and simplifies administration of user accounts and passwords. Centralized, secure authentication services ensure high confidence in the identity of users, clients, and servers in distributed environments. Network authentication services can also provide the benefit of single sign-on for users. Support exists for the following authentication methods: Kerberos RADIUS SSL SecurID Identix CyberSafe	Yes	No	Yes
Net8 Enhancements for Developers: Net8 OPEN An application programming interface (API) that lets developers write applications that use Net8 for connectivity. Net8 OPEN offers the following benefits: Enables development of both database and non-database applications that use an already deployed Net8 network Enables deployment of an application developed on one machine to another without having to modify calls to the network interface. Provides a single common interface to all industry standard network protocols. For more information, see the Net8 Administrator's Guide.	Yes	Yes	Yes
Object Type Translator (OTT) OTT (executable name OTT.EXE) is used to create C-struct representations of Abstract Data Types that have been created and stored in an Oracle database. To take advantage of objects, run OTT against the database, and a header file is generated that includes the C-structs. Oracle INTYPE File Assistant An assistant that helps you to create an INTYPE file, which provides a list of types for OTT to translate.	Yes	No	Yes
Oracle Snap-In Common Files A collection of snap-ins that let you perform various administrative functions within Microsoft Management Console. Oracle Administration Assistant for Windows NT Lets you start and stop the Oracle database service, auto-start Oracle services, view information about Oracle background processes, and configure Oracle database users to be authenticated by Windows NT. Oracle Remote Configuration Agent Facilitates configuration and monitoring of remote Oracle databases.	Yes	Yes	Yes
Oracle AppWizard for Microsoft Visual C++ Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment. Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.	No	No	Yes
Oracle Call Interface (OCI) An application programming interface (API) for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements.	Yes	No	Yes
COM Automation Enables PL/SQL developers to programmatically manipulate COM objects through the OLE Automation interface (IDispatch).	Yes	No	Yes
Oracle Connection Manager Lets you multiplex multiple logical client sessions through a single transport connection to an Oracle server destination.	No	No	Yes
*Oracle interMedia* Oracle enables file management in a variety of media, from text to audio, to video. Files in each medium are managed through a specific component of interMedia as described below. Image Provides for the storage, retrieval, and processing of two-dimensional, static bitmapped images. Images are stored efficiently using popular compression schemes in industry-standard desktop publishing image interchange formats. Audio Provides for the storage, retrieval and management of digitized audio data within an Oracle database. Video Provides for the storage, retrieval and management of digitized video data within an Oracle database. Text Enables text queries to be performed through SQL and PL/SQL from most Oracle interfaces. By installing Oracle interMedia Text with Oracle8i Enterprise Edition, client tools such as SQLPlus, Oracle Forms, and ProC/C++ are able to retrieve and manipulate text in an Oracle database. Locator Enables Oracle8i to support online internet-based geocoding facilities for locator applications and proximity queries. This multi-component product requires a separate license.	Yes	No	Yes
Oracle options Spatial Oracle Spatial makes the storage, retrieval, and manipulation of spatial data easier and more intuitive to users. Time Series Oracle Time Series stores and retrieves time-stamped data through object data types (ODTs). These products require a separate license.	Yes	No	Yes
Oracle Data Migration Assistant Lets you migrate your existing Oracle7 database (release 7.1.3.3.6 or later) or upgrade previous releases of Oracle8 and Oracle8i to the current Oracle8i database release.	Yes	Yes	Yes
Oracle Database Configuration Assistant Lets you create, modify, and delete databases.	Yes	Yes	Yes
Oracle Documentation Available in HTML, viewable using a Web browser. A PDF version is also available but is not automatically installed. You can find the PDF documentation on the CD-ROM in the PDFDOC directory. The Adobe Acrobat Reader is located in the ACROREAD directory.	Yes	Yes	Yes
Oracle for Windows NT Performance Monitor Enables database administrators to monitor local and remote database performance through the Windows NT Performance Monitor.	Yes	No	Yes
Oracle Intelligent Agent Responds to, schedules, and executes database administration job requests initiated by the Oracle Enterprise Manger Console.	Yes	Yes	Yes
Oracle Java Database Connectivity (JDBC) Drivers A standard set of Java classes, specified by JavaSoft, that provide vendor-independent access to relational data from Java.	Yes	Yes	Yes
Oracle Java option Provides a JDK 1.1.6-compliant Java Virtual Machine, a CORBA 2.0 Object Request Broker, an embedded JDBC driver, a SQLJ translator, and an Enterprise JavaBeans transaction server.	Yes	No	Yes
Oracle Java Tools Provides Java tools to build and deploy Java stored procedures, CORBA objects, and Enterprise JavaBeans with Oracle's Java Virtual Machine.	Yes	No	Yes
Oracle Names A distributed naming service developed for Oracle environments to help simplify the setup and administration of global, client/server computing networks. Oracle Names does this by establishing and maintaining an integrated system of Names servers. Oracle Names servers work like a directory service storing addresses for all the database services on a network and making them available to clients that want to make a connection. See the Net8 Administrator's Guide for more information on this product.	No	No	Yes
Oracle Objects for Object Linking and Embedding (OLE) A custom control (OCX or ActiveX) combined with an OLE in-process server that lets you plug native Oracle8i Enterprise Edition functionality into your Windows applications.	Yes	Yes	Yes
Oracle Objects Functionality Lets you create and manipulate objects, as well as to integrate objects with standard relational functionality.	Yes	No	Yes
Oracle Open Database Connectivity (ODBC) Driver Provides support for ODBC connections from Windows NT, Windows 95, and Windows 98 client systems to Oracle databases. The Oracle ODBC Driver complies with version 3.00 of the Microsoft ODBC specification and supports all ODBC Core and the following Level 1 and Level 2 calls: SQLBrowseConnect SQLColumnPrivileges SQLDescribeParam SQLForeignKeys SQLMoreResults SQLPrimaryKeys SQLProcedureColumns SQLProcedures SQLTablePrivileges	Yes	Yes	Yes
Oracle Parallel Server Enables multiple Oracle instances to share a single Oracle database. This product requires a separate license. The following product is automatically installed when you install Oracle Parallel Server option: Oracle Parallel Server Manager Enables Oracle Parallel Server nodes to manage multiple parallel server instances.	Yes	No	Yes
Oracle Partitioning option Provides more control in managing tables and indexes by directing all maintenance operations to individual partitions rather than to tables and index names. This product requires a separate license.	Yes	No	Yes
Oracle Server The database component of Oracle8i Enterprise Edition software.	Yes	Yes	Yes
Oracle Services for Microsoft Transaction Server Provides full integration of Oracle8i Enterprise Edition release 8.1.5 with Microsoft Transaction Server (MTS). This product offers a solution to develop and deploy COM-based applications using MTS against Oracle8i release 8.1.5.	No	No	Yes
Oracle SNMP Agent Oracle SNMP Agent allows Oracle products to be located, identified, and monitored by any SNMP-based network management system.	No	No	Yes
Oracle SQLJ Translator A preprocessor for Java programs that contain embedded SQL statements. Oracle SQLJ Translator converts the SQL statements to JDBC calls.	Yes	No	Yes
Oracle Universal Installer A GUI application that lets you quickly install, update, and remove Oracle products. Oracle Universal Installer also automatically installs Oracle Home Selector, a tool that lets you edit your environmental path to make an appropriate Oracle home directory your primary home.	Yes	Yes	Yes
Oracle Utilities A suite of products used for database administration. Oracle Utilities include Server Manager, Export Utility, Import Utility, ORADIM, SQL*Loader, DBVERIFY, TKPROF, Migration Utility, Recovery Manager, OCOPY, and the Password Utility.	Yes	Yes	Yes
Oracle Visual Information Retrieval Provides image storage, content-based retrieval, and format conversion capabilities through an object data type. This option is a building block for various imaging applications, rather than being an end-user application. Some common applications for this option consist of digital art galleries and museums, real estate marketing, document imaging, and stock photo collections for fashion designers and architect. A demonstration is also available.	Yes	No	Yes
Oracle Web Publishing Assistant Lets you query a database and publish the data retrieved on a Web page.	Yes	No	Yes
Oracle8i Enterprise Edition Release Notes Important last-minute installation and configuration information that you should read before using Oracle products.	Yes	Yes	Yes

Oracle8i Client

This table describes the Oracle products that are available when you select the Oracle8i Client installation option.

Oracle8i Client can be installed on Windows NT, Windows 95, and Windows 98.

Oracle8i Client Products Typical Custom

Assistant Common Files

A collection of files required by Oracle assistants.

Yes

Yes

Legato Storage Manager (LSM)

Using Oracle Recovery Manager (RMAN.EXE) for Oracle database backups requires the installation of a media management product in order to back up and restore from tape storage. You can choose to install the media management product supplied with Oracle8i Enterprise Edition, which is LSM, or use a third-party media management product that also complies with Oracle's Backup Solutions Program. LSM also includes a scaled-down version of Legato NetWorker.

The installer prompts you to confirm whether or not you want to install LSM. When you confirm installation, LSM is installed automatically.

For more information on this product, call toll free 1 (888) 8-LEGATO in the United States of America, or visit Legato's Oracle backup and recovery Web site:
http://www.backup-oracle.com/

N/A
NT only

N/A
NT only

Net8 Client

Provides products that enable client connection to databases across a network. A client-side application sends a request to Net8 to be transported across the network to the server. See Net8 Administrator's Guide for more information on this product.

Yes

Yes

Net8 Configuration Tools:

Net8 Configuration Assistant

Oracle recommends using the Net8 Configuration Assistant to configure certain Net8 client and server components after installation.

Net8 Configuration Assistant can also be run in stand-alone mode to configure naming methods, net service names, and the listener.¹

To start Net 8 Configuration Assistant:

Choose Start>Programs>Oracle-Home_Name>Network Administration>Net8 Configuration Assistant.

Additional Information: See Chapter 5: "Considerations for Upgrades and Migration and Chapter 7: "Enabling Optional Net8 Features" of the Net8 Administrator's Guide.

Yes

Yes

Net8 Assistant

Helps you configure and administer the SQLNET.ORA file, the TNSNAMES.ORA file, the LISTENER.ORA file, and Oracle Names Servers.

Yes

Yes

Net8 Easy Config

This Java-based tool lets you set up net service names in the TNSNAMES.ORA file. Use this tool for configuring simple networks and testing the configuration.

Yes

Yes

Trace Assistant

Formats level-16 SUPPORT traces into paragraphs that are easier to read than unformatted trace files.

Yes

Yes

Net8 Support for the following naming methods:

Net8 clients communicates with Oracle servers through net service names that are easy-to-remember aliases for database addresses. Net8 resolves net service names using the following naming methods:

Host Naming

Local Naming

Oracle Names

External Naming: NetWare Directory Service (NDS)

See Chapter 6: "Configuring Naming Methods and the Listener" of the Net8 Administrator's Guide for more information.

Yes

Yes

Support for the following protocols:²

Net8 Client (and not Oracle Universal Installer) installs TCP/IP and Named Pipes, and auto-detects SPX. SPX is only installed in the installation packages if the appropriate software is detected on your system. If you explicitly select this product in the Custom installation type, it will be installed even if you do not have the appropriate software on your computer.

TCP/IP

Enables client/server conversation over a network using TCP/IP and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP/IP (if the Oracle database is running on a host system that supports network communication using TCP/IP).

Yes

Yes

SPX

Enables client/server conversation over a network using SPX/IPX and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through SPX/IPX (if the Oracle database is running on a host system that supports network communication using SPX/IPX). This protocol is predominantly used in Novell Netware environments.

Yes

Yes

Named Pipes

Enables client/server conversation over a network using Named Pipes and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through Named Pipes (if the Oracle database is running on a host system that supports network communication using Named Pipes).

Yes

Yes

Bequeath

Enables clients to retrieve information from the database without using the network listener. The Bequeath protocol internally spawns a server thread for each client application. In a sense, it does the same operation that a remote network listener does for your connection, yet locally.

Bequeath has the following attributes:

Does not use a network listener (therefore, no network listener configuration is required)

Used for local connections where an Oracle client application (such as SQL*Plus) communicates with an Oracle server running on the same machine

Only works in Dedicated Server mode. Cannot be used in a Multi-Threaded Server (MTS) mode.

Supported on Windows NT for 32-bit applications. Also works on Windows 95 for connections to a Oracle8i Personal Edition database for 32-bit applications.

Installed by default with Net8 Client

Yes

N/A

Logical Unit Type 6.2 (LU6.2) Protocol Adapter

The adapter is part of the IBM Advanced Program-to-Program Communication (APPC) architecture.

APPC is the IBM peer-to-peer (program-to-program) protocol for a System Network Architecture (SNA) network. SNA is an IBM reference model similar to the Open Systems Interconnect (OSI) model of the International Standards Organization (ISO).

APPC architecture lets the client and host communicate over an SNA network without forcing the client to emulate a terminal (as in terminal-to-host protocols). APPC architecture allows peer-to-peer communication; the client can initiate communication with the server.

An SNA network with the LU6.2 and Physical Unit Type 2.1 (PU2.1) protocols provides APPC. The LU6.2 protocol defines a session between two application programs; LU6.2 is a product-independent LU-type.

The LU6.2 Protocol Adapter enables an Oracle application on a PC to communicate with an Oracle database. This communication occurs over an SNA network with the Oracle database on a host system that supports APPC.

Yes

Yes

Oracle Advanced Security--Export Edition

Ensures secure transmission of data over networks. Uses encryption and authentication engines from RSA Data Security, Inc. See the Oracle Advanced Security Administrator's Guide for more information.

Available algorithms:

Encryption

RC4_40

DES_40

Checksumming

MD5

Yes

Yes

Oracle Advanced Security Single Sign-On

Allows users to access multiple accounts and applications with a single password. This feature eliminates the need for multiple user passwords and simplifies administration of user accounts and passwords.

Centralized, secure authentication services ensure high confidence in the identity of users, clients, and servers in distributed environments. Network authentication services can also provide the benefit of single sign-on for users.

Support exists for the following authentication methods:

Kerberos

RADIUS

SSL

SecurID

Identix

Cybersafe

Yes

Yes

Net8 Enhancements for Developers:

Net8 OPEN

An application programming interface (API) that lets developers write applications that use Net8 for connectivity. Net8 OPEN offers the following benefits:

Enables development of both database and non-database applications that use an already deployed Net8 network

Enables deployment of an application developed on one machine to another without having to modify calls to the network interface.

Provides a single common interface to all industry standard network protocols.

For more information, see the Net8 Administrator's Guide.

Yes

Yes

Object Type Translator (OTT)

OTT (executable name OTT.EXE) is used to create C-struct representations of Abstract Data Types that have been created and stored in an Oracle database. To take advantage of objects, run OTT against the database, and a header file is generated that includes the C structs.

Oracle INTYPE File Assistant

An assistant that helps you to create an INTYPE file, which provides a list of types for OTT to translate.

Yes

Yes

Oracle AppWizard for Microsoft Visual C++

Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment.

Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.

No

Yes

Oracle Call Interface (OCI)

An application programming interface (API) for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements.

Yes

Yes

Oracle Documentation

Available in HTML, viewable using a Web browser. A PDF version is also available but is not automatically installed. You can find the PDF documentation on the CD-ROM in the PDFDOC directory. The Adobe Acrobat Reader is located in the ACROREAD directory.

Yes

Yes

Oracle interMedia Client
Provides an Oracle8i interMedia Audio, Image, and Video Java inteface that lets you use client-side applications to manipulate and/or modify multimedia data stored in a network accessible database on the server.

It also provides a simple interMedia Image sample (SimpImg.exe) that was developed, using MS Visual C++. SimpImg.exe locates and updates images, using interMedia Image in an Oracle8i database

This multi-component product requires a separate license.

Yes

Yes

Oracle Visual Information Retrieval Client

Provides image storage, content-based retrieval, and format conversion capabilities through a Java interface. This option is a building block for various imaging applications, rather than being an end-user application. Some common applications for this option consist of digital art galleries and museums, real estate marketing, document imaging, and stock photo collections for fashion designers and architect.

A demonstration is also available.

Yes

Yes

Oracle Java Database Connectivity (JDBC) Drivers

A standard set of Java classes, specified by JavaSoft, that provide vendor-independent access to relational data from Java.

Yes

Yes

Oracle Java Tools

Provides Java tools to build and deploy Java stored procedures, CORBA objects, and Enterprise JavaBeans with Oracle's Java Virtual Machine.

Yes

Yes

Oracle Objects for Object Linking and Embedding (OLE)

A custom control (OCX or ActiveX) combined with an OLE in-process server that lets you plug native Oracle8i Enterprise Edition functionality into your Windows applications.

Yes

Yes

Oracle Open Database Connectivity (ODBC) Driver

Provides support for ODBC connections from Windows NT, Windows 95, and Windows 98 client systems to Oracle databases. The Oracle ODBC Driver complies with version 3.00 of the Microsoft ODBC specification and supports all ODBC Core and the following Level 1 and Level 2 calls:

SQLBrowseConnect

SQLColumnPrivileges

SQLDescribeParam

SQLForeignKeys

SQLMoreResults

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLTablePrivileges

Yes

Yes

Oracle Services for Microsoft Transaction Server

Provides full integration of Oracle8i Enterprise Edition release 8.1.5 with Microsoft Transaction Server (MTS). This product offers a solution to develop and deploy COM-based applications using MTS against Oracle8i release 8.1.5.

No

Yes
NT only

Oracle Universal Installer

A GUI application that lets you quickly install, update, and remove Oracle products. Oracle Universal Installer also automatically installs Oracle Home Selector, a tool that lets you edit your environmental path to make an appropriate Oracle home directory your primary home.

Yes

Yes

Oracle Utilities

A suite of products used for database administration. Oracle Utilities include Server Manager, Export Utility, Import Utility, ORADIM, SQL*Loader, DBVERIFY, TKPROF, Migration Utility, Recovery Manager, OCOPY, and the Password Utility.

Yes

Yes

Oracle Web Publishing Assistant

Lets you query a database and publish the data retrieved on a Web page.

Yes
NT only

Yes
NT only

Oracle8i Enterprise Edition Release Notes

Important last-minute installation and configuration information that you should read before using Oracle products.

Yes

Yes

SQL*Plus

Lets you use the SQL and PL/SQL database languages in the Windows NT, Windows 95, or Windows 98 environments. SQL*Plus has both command line and GUI versions.

Yes

Yes

¹ The NT platform version of Net8 does not support prespawned dedicated server processes by the listener. Therefore, do not include the following parameters in the SID_DESC's of the LISTENER.ORA file: PRESPAWN_MAX, PROTOCOL, POOL_SIZE, TIMEOUT.
² Installation of some stand-alone TCP/IP and TCP/IP with SSL, SPX, and Named Pipes protocols is done, based on automatic detection of your system protocol stacks.

Oracle8i Client Products	Typical	Custom
Assistant Common Files A collection of files required by Oracle assistants.	Yes	Yes
Legato Storage Manager (LSM) Using Oracle Recovery Manager (RMAN.EXE) for Oracle database backups requires the installation of a media management product in order to back up and restore from tape storage. You can choose to install the media management product supplied with Oracle8i Enterprise Edition, which is LSM, or use a third-party media management product that also complies with Oracle's Backup Solutions Program. LSM also includes a scaled-down version of Legato NetWorker. The installer prompts you to confirm whether or not you want to install LSM. When you confirm installation, LSM is installed automatically. For more information on this product, call toll free 1 (888) 8-LEGATO in the United States of America, or visit Legato's Oracle backup and recovery Web site: `http://www.backup-oracle.com/`	N/A NT only	N/A NT only
Net8 Client Provides products that enable client connection to databases across a network. A client-side application sends a request to *Net8* to be transported across the network to the server. See Net8 Administrator's Guide for more information on this product.	Yes	Yes
Net8 Configuration Tools:
Net8 Configuration Assistant Oracle recommends using the Net8 Configuration Assistant to configure certain Net8 client and server components after installation. Net8 Configuration Assistant can also be run in stand-alone mode to configure naming methods, net service names, and the listener.¹ To start Net 8 Configuration Assistant: Choose Start>Programs>Oracle-Home_Name>Network Administration>Net8 Configuration Assistant. Additional Information: See Chapter 5: "Considerations for Upgrades and Migration and Chapter 7: "Enabling Optional Net8 Features" of the Net8 Administrator's Guide.	Yes	Yes
Net8 Assistant Helps you configure and administer the SQLNET.ORA file, the TNSNAMES.ORA file, the LISTENER.ORA file, and Oracle Names Servers.	Yes	Yes
Net8 Easy Config This Java-based tool lets you set up net service names in the TNSNAMES.ORA file. Use this tool for configuring simple networks and testing the configuration.	Yes	Yes
Trace Assistant Formats level-16 SUPPORT traces into paragraphs that are easier to read than unformatted trace files.	Yes	Yes
Net8 Support for the following naming methods: Net8 clients communicates with Oracle servers through net service names that are easy-to-remember aliases for database addresses. Net8 resolves net service names using the following naming methods:
Host Naming Local Naming Oracle Names External Naming: NetWare Directory Service (NDS) See Chapter 6: "Configuring Naming Methods and the Listener" of the Net8 Administrator's Guide for more information.	Yes	Yes
Support for the following protocols:² Net8 Client (and not Oracle Universal Installer) installs TCP/IP and Named Pipes, and auto-detects SPX. SPX is only installed in the installation packages if the appropriate software is detected on your system. If you explicitly select this product in the Custom installation type, it will be installed even if you do not have the appropriate software on your computer.
TCP/IP Enables client/server conversation over a network using TCP/IP and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP/IP (if the Oracle database is running on a host system that supports network communication using TCP/IP).	Yes	Yes
SPX Enables client/server conversation over a network using SPX/IPX and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through SPX/IPX (if the Oracle database is running on a host system that supports network communication using SPX/IPX). This protocol is predominantly used in Novell Netware environments.	Yes	Yes
Named Pipes Enables client/server conversation over a network using Named Pipes and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through Named Pipes (if the Oracle database is running on a host system that supports network communication using Named Pipes).	Yes	Yes
Bequeath Enables clients to retrieve information from the database without using the network listener. The Bequeath protocol internally spawns a server thread for each client application. In a sense, it does the same operation that a remote network listener does for your connection, yet locally. Bequeath has the following attributes: Does not use a network listener (therefore, no network listener configuration is required) Used for local connections where an Oracle client application (such as SQLPlus) communicates with an Oracle server running on the same* machine Only works in Dedicated Server mode. Cannot be used in a Multi-Threaded Server (MTS) mode. Supported on Windows NT for 32-bit applications. Also works on Windows 95 for connections to a Oracle8i Personal Edition database for 32-bit applications. Installed by default with Net8 Client	Yes	N/A
Logical Unit Type 6.2 (LU6.2) Protocol Adapter The adapter is part of the IBM Advanced Program-to-Program Communication (APPC) architecture. APPC is the IBM peer-to-peer (program-to-program) protocol for a System Network Architecture (SNA) network. SNA is an IBM reference model similar to the Open Systems Interconnect (OSI) model of the International Standards Organization (ISO). APPC architecture lets the client and host communicate over an SNA network without forcing the client to emulate a terminal (as in terminal-to-host protocols). APPC architecture allows peer-to-peer communication; the client can initiate communication with the server. An SNA network with the LU6.2 and Physical Unit Type 2.1 (PU2.1) protocols provides APPC. The LU6.2 protocol defines a session between two application programs; LU6.2 is a product-independent LU-type. The LU6.2 Protocol Adapter enables an Oracle application on a PC to communicate with an Oracle database. This communication occurs over an SNA network with the Oracle database on a host system that supports APPC.	Yes	Yes
Oracle Advanced Security--Export Edition Ensures secure transmission of data over networks. Uses encryption and authentication engines from RSA Data Security, Inc. See the Oracle Advanced Security Administrator's Guide for more information. Available algorithms: Encryption RC4_40 DES_40 Checksumming MD5	Yes	Yes
Oracle Advanced Security Single Sign-On Allows users to access multiple accounts and applications with a single password. This feature eliminates the need for multiple user passwords and simplifies administration of user accounts and passwords. Centralized, secure authentication services ensure high confidence in the identity of users, clients, and servers in distributed environments. Network authentication services can also provide the benefit of single sign-on for users. Support exists for the following authentication methods: Kerberos RADIUS SSL SecurID Identix Cybersafe	Yes	Yes
Net8 Enhancements for Developers: Net8 OPEN An application programming interface (API) that lets developers write applications that use Net8 for connectivity. Net8 OPEN offers the following benefits: Enables development of both database and non-database applications that use an already deployed Net8 network Enables deployment of an application developed on one machine to another without having to modify calls to the network interface. Provides a single common interface to all industry standard network protocols. For more information, see the Net8 Administrator's Guide.	Yes	Yes
Object Type Translator (OTT) OTT (executable name OTT.EXE) is used to create C-struct representations of Abstract Data Types that have been created and stored in an Oracle database. To take advantage of objects, run OTT against the database, and a header file is generated that includes the C structs. Oracle INTYPE File Assistant An assistant that helps you to create an INTYPE file, which provides a list of types for OTT to translate.	Yes	Yes
Oracle AppWizard for Microsoft Visual C++ Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment. Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.	No	Yes
Oracle Call Interface (OCI) An application programming interface (API) for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements.	Yes	Yes
Oracle Documentation Available in HTML, viewable using a Web browser. A PDF version is also available but is not automatically installed. You can find the PDF documentation on the CD-ROM in the PDFDOC directory. The Adobe Acrobat Reader is located in the ACROREAD directory.	Yes	Yes
*Oracle interMedia Client* Provides an Oracle8i interMedia Audio, Image, and Video Java inteface that lets you use client-side applications to manipulate and/or modify multimedia data stored in a network accessible database on the server. It also provides a simple interMedia Image sample (SimpImg.exe) that was developed, using MS Visual C++. SimpImg.exe locates and updates images, using interMedia Image in an Oracle8i database This multi-component product requires a separate license.	Yes	Yes
Oracle Visual Information Retrieval Client Provides image storage, content-based retrieval, and format conversion capabilities through a Java interface. This option is a building block for various imaging applications, rather than being an end-user application. Some common applications for this option consist of digital art galleries and museums, real estate marketing, document imaging, and stock photo collections for fashion designers and architect. A demonstration is also available.	Yes	Yes
Oracle Java Database Connectivity (JDBC) Drivers A standard set of Java classes, specified by JavaSoft, that provide vendor-independent access to relational data from Java.	Yes	Yes
Oracle Java Tools Provides Java tools to build and deploy Java stored procedures, CORBA objects, and Enterprise JavaBeans with Oracle's Java Virtual Machine.	Yes	Yes
Oracle Objects for Object Linking and Embedding (OLE) A custom control (OCX or ActiveX) combined with an OLE in-process server that lets you plug native Oracle8i Enterprise Edition functionality into your Windows applications.	Yes	Yes
Oracle Open Database Connectivity (ODBC) Driver Provides support for ODBC connections from Windows NT, Windows 95, and Windows 98 client systems to Oracle databases. The Oracle ODBC Driver complies with version 3.00 of the Microsoft ODBC specification and supports all ODBC Core and the following Level 1 and Level 2 calls: SQLBrowseConnect SQLColumnPrivileges SQLDescribeParam SQLForeignKeys SQLMoreResults SQLPrimaryKeys SQLProcedureColumns SQLProcedures SQLTablePrivileges	Yes	Yes
Oracle Services for Microsoft Transaction Server Provides full integration of Oracle8i Enterprise Edition release 8.1.5 with Microsoft Transaction Server (MTS). This product offers a solution to develop and deploy COM-based applications using MTS against Oracle8i release 8.1.5.	No	Yes NT only
Oracle Universal Installer A GUI application that lets you quickly install, update, and remove Oracle products. Oracle Universal Installer also automatically installs Oracle Home Selector, a tool that lets you edit your environmental path to make an appropriate Oracle home directory your primary home.	Yes	Yes
Oracle Utilities A suite of products used for database administration. Oracle Utilities include Server Manager, Export Utility, Import Utility, ORADIM, SQL*Loader, DBVERIFY, TKPROF, Migration Utility, Recovery Manager, OCOPY, and the Password Utility.	Yes	Yes
Oracle Web Publishing Assistant Lets you query a database and publish the data retrieved on a Web page.	Yes NT only	Yes NT only
Oracle8i Enterprise Edition Release Notes Important last-minute installation and configuration information that you should read before using Oracle products.	Yes	Yes
*SQLPlus** Lets you use the SQL and PL/SQL database languages in the Windows NT, Windows 95, or Windows 98 environments. SQL*Plus has both command line and GUI versions.	Yes	Yes

Programmer/2000

This table describes the Oracle products that are available when you select the Programmer/2000 installation option.

Programmer/2000 can be installed on Windows NT, Windows 95, and Windows 98.

Programmer/2000 Products Typical Custom

Assistant Common Files

A collection of files required by Oracle assistants.

Yes

Yes

Net8 Client

Provides products that enable client connection to databases across a network. A client-side application sends a request to Net8 to be transported across the network to the server. See Net8 Administrator's Guide for more information on this product.

Yes

Yes

Net8 Configuration Tools:

Net8 Configuration Assistant

Oracle recommends using the Net8 Configuration Assistant to configure certain Net8 client and server components after installation.

Net8 Configuration Assistant can also be run in stand-alone mode to configure naming methods, net service names, and the listener.¹

To start Net 8 Configuration Assistant:

Choose Start>Programs>Oracle-Home_Name>Network Administration>Net8 Configuration Assistant.

Additional Information: See Chapter 5: "Considerations for Upgrades and Migration and Chapter 7: "Enabling Optional Net8 Features" of the Net8 Administrator's Guide.

Yes

Yes

Net8 Assistant

Helps you configure and administer the SQLNET.ORA file, the TNSNAMES.ORA file, the LISTENER.ORA file, and Oracle Names Servers.

Yes

Yes

Net8 Easy Config

This Java-based tool lets you set up net service names in the TNSNAMES.ORA file. Use this tool for configuring simple networks and testing the configuration.

Yes

Yes

Trace Assistant

Formats level-16 SUPPORT traces into paragraphs that are easier to read than unformatted trace files.

Yes

Yes

Net8 Support for the following naming methods:
Net8 clients communicates with Oracle servers through net service names that are easy-to-remember aliases for database addresses. Net8 resolves net service names using the following naming methods:

Host Naming

Local Naming

Oracle Names

External Naming: Windows NT Native Authentication Method, NetWare Directory Service [NDS]

See Chapter 6: "Configuring Naming Methods and the Listener" of the Net8 Administrator's Guide for more information.

Yes

Yes

Net8 Support for the following protocols:²

Net8 Client (and not Oracle Universal Installer) installs TCP/IP and Named Pipes, and auto-detects SPX. SPX is only installed in the installation packages if the appropriate software is detected on your system. If you explicitly select this product in the Custom installation type, it will be installed even if you do not have the appropriate software on your computer.

TCP/IP

Enables client/server conversation over a network using TCP/IP and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP/IP (if the Oracle database is running on a host system that supports network communication using TCP/IP).

Yes

Yes

SPX

Enables client/server conversation over a network using SPX/IPX and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through SPX/IPX (if the Oracle database is running on a host system that supports network communication using SPX/IPX). This protocol is predominantly used in Novell Netware environments.

Yes

Yes

Named Pipes

Enables client/server conversation over a network using Named Pipes and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through Named Pipes (if the Oracle database is running on a host system that supports network communication using Named Pipes).

Yes

Yes

Logical Unit Type 6.2 (LU6.2) Protocol Adapter

The adapter is part of the IBM Advanced Program-to-Program Communication (APPC) architecture.
APPC is the IBM peer-to-peer (program-to-program) protocol for a System Network Architecture (SNA) network. SNA is an IBM reference model similar to the Open Systems Interconnect (OSI) model of the International Standards Organization (ISO).
APPC architecture lets the client and host communicate over an SNA network without forcing the client to emulate a terminal (as in terminal-to-host protocols). APPC architecture allows peer-to-peer communication; the client can initiate communication with the server.
An SNA network with the LU6.2 and Physical Unit Type 2.1 (PU2.1) protocols provides APPC. The LU6.2 protocol defines a session between two application programs; LU6.2 is a product-independent LU-type.
The LU6.2 Protocol Adapter enables an Oracle application on a PC to communicate with an Oracle database. This communication occurs over an SNA network with the Oracle database on a host system that supports APPC.

Yes

Yes

Bequeath

Enables clients to retrieve information from the database without using the network listener. The Bequeath protocol internally spawns a server thread for each client application. In a sense, it does the same operation that a remote network listener does for your connection, but locally.
Bequeath has the following attributes:

Does not use a network listener (therefore, no network listener configuration is required)

Used for local connections where an Oracle client application (such as SQL*Plus) communicates with an Oracle server running on the same machine

Only works in Dedicated Server mode. Cannot be used in a Multi-Threaded Server (MTS) mode.

Supported on Windows NT for 32-bit applications. Also works on Windows 95 for connections to a Oracle8i Personal Edition database for 32-bit applications.

Installed by default with Net8 Client

Yes
(installed with Net8 Client and Net8 Server)

N/A
(installed with Net8 Client and Net8 Server)

Oracle Advanced Security--Export Edition

Ensures secure transmission of data over networks. Uses encryption and authentication engines from RSA Data Security, Inc. See the Oracle Advanced Security Administrator's Guide for more information.

Available algorithms:

Encryption

RC4_40
DES_40
Checksumming
MD5

Yes

Yes

Oracle Advance Security Single Sign-On

Allows users to access multiple accounts and applications with a single password. This feature eliminates the need for multiple user passwords and simplifies administration of user accounts and passwords.

Centralized, secure authentication services ensure high confidence in the identity of users, clients, and servers in distributed environments. Network authentication services can also provide the benefit of single sign-on for users.

Support exists for the following authentication methods:

Kerberos

RADIUS

SSL

SecurID

Identix

CyberSafe

Yes

Yes

Net8 Enhancements for Developers:

Net8 OPEN

An application programming interface (API) that lets developers write applications that use Net8 for connectivity. Net8 OPEN offers the following benefits:

Enables development of both database and non-database applications that use an already deployed Net8 network.

Enables deployment of an application developed on one machine to another without having to modify calls to the network interface.

Provides a single common interface to all industry standard network protocols.

For more information, see the Net8 Administrator's Guide.

Yes

Yes

Object Type Translator (OTT)

OTT (executable name OTT.EXE) is used to create C-struct representations of Abstract Data Types that have been created and stored in an Oracle database. To take advantage of objects, run OTT against the database, and a header file is generated that includes the C structs.

Oracle INTYPE File Assistant

An assistant that helps you to create an INTYPE file, which provides a list of types for OTT to translate.

Yes

Yes

Oracle AppWizard for Microsoft Visual C++

Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment.

Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.

Yes

Oracle Call Interface (OCI)

An application programming interface (API) for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements.

Yes

Yes

Oracle Documentation

Available in HTML, viewable using a Web browser. A PDF version is also available, but is not automatically installed. You can find the PDF documentation on the CD-ROM in the PDFDOC directory. The Adobe Acrobat Reader is located in the ACROREAD directory.

Yes

Yes

Oracle Java Database Connectivity (JDBC) Drivers

A standard set of Java classes, specified by JavaSoft, that provide vendor-independent access to relational data from Java.

Yes

Yes

Oracle Java Tools

Provides Java tools to build and deploy Java stored procedures, CORBA objects, and Enterprise JavaBeans with Oracle's Java Virtual Machine.

Yes

Yes

Oracle Objects for Object Linking and Embedding (OLE)

A custom control (OCX or ActiveX) combined with an OLE in-process server that lets you plug native Oracle8i Enterprise Edition functionality into your Windows applications.

Yes

Yes

Oracle Open Database Connectivity (ODBC) Driver

Provides support for ODBC connections from Windows NT, Windows 95, and Windows 98 client systems to Oracle databases. The Oracle ODBC Driver complies with version 3.00 of the Microsoft ODBC specification and supports all ODBC Core and the following Level 1 and Level 2 calls:

SQLBrowseConnect

SQLColumnPrivileges

SQLDescribeParam

SQLForeignKeys

SQLMoreResults

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLTablePrivileges

Yes

Yes

Oracle SQLJ Translator

A preprocessor for Java programs that contain embedded SQL statements. Oracle SQLJ Translator converts the SQL statements to JDBC calls.

Yes

Yes

Oracle Universal Installer

A GUI application that lets you quickly install, update, and remove Oracle products. Oracle Universal Installer also automatically installs Oracle Home Selector, a tool that lets you edit your environmental path to make an appropriate Oracle home directory your primary home.

Yes

Yes

Oracle8i Enterprise Edition Release Notes

Important last-minute installation and configuration information that you should read before using Oracle products.

Yes

Yes

Pro*C/C++

The Pro*C/C++ precompiler takes SQL statements embedded in your C and C++ program and converts them to standard C code. When you precompile this code, the result is a C or C++ program that you can compile and use to build applications that access an Oracle database.

Yes

Yes

Pro*COBOL

To access an Oracle database, you use a high-level query language called Structured Query Language (SQL). You often use SQL through an interactive interface, such as SQL*Plus. Pro*COBOL is a precompiler that converts SQL statements embedded within COBOL programs into standard Oracle run-time library calls. The output file can then be compiled by a COBOL compiler.

Yes

Yes

SQL*Plus

Lets you use the SQL and PL/SQL database languages in the Windows NT, Windows 95, or Windows 98 environments. SQL*Plus has both command line and GUI versions.

Yes

Yes

¹ The NT platform version of Net8 does not support prespawned dedicated server processes by the listener. Therefore, do not include the following parameters in the SID_DESC's of the LISTENER.ORA file: PRESPAWN_MAX, PROTOCOL, POOL_SIZE, TIMEOUT.
² Installation of some stand-alone TCP/IP and TCP/IP with SSL, SPX, and Named Pipes protocols is done, based on automatic detection of your system protocol stacks.

Programmer/2000 Products	Typical	Custom
Assistant Common Files A collection of files required by Oracle assistants.	Yes	Yes
Net8 Client Provides products that enable client connection to databases across a network. A client-side application sends a request to *Net8* to be transported across the network to the server. See Net8 Administrator's Guide for more information on this product.	Yes	Yes
Net8 Configuration Tools:
Net8 Configuration Assistant Oracle recommends using the Net8 Configuration Assistant to configure certain Net8 client and server components after installation. Net8 Configuration Assistant can also be run in stand-alone mode to configure naming methods, net service names, and the listener.¹ To start Net 8 Configuration Assistant: Choose Start>Programs>Oracle-Home_Name>Network Administration>Net8 Configuration Assistant. Additional Information: See Chapter 5: "Considerations for Upgrades and Migration and Chapter 7: "Enabling Optional Net8 Features" of the Net8 Administrator's Guide.	Yes	Yes
Net8 Assistant Helps you configure and administer the SQLNET.ORA file, the TNSNAMES.ORA file, the LISTENER.ORA file, and Oracle Names Servers.	Yes	Yes
Net8 Easy Config This Java-based tool lets you set up net service names in the TNSNAMES.ORA file. Use this tool for configuring simple networks and testing the configuration.	Yes	Yes
Trace Assistant Formats level-16 SUPPORT traces into paragraphs that are easier to read than unformatted trace files.	Yes	Yes
Net8 Support for the following naming methods: Net8 clients communicates with Oracle servers through net service names that are easy-to-remember aliases for database addresses. Net8 resolves net service names using the following naming methods:
Host Naming Local Naming Oracle Names External Naming: Windows NT Native Authentication Method, NetWare Directory Service [NDS] See Chapter 6: "Configuring Naming Methods and the Listener" of the Net8 Administrator's Guide for more information.	Yes	Yes
Net8 Support for the following protocols:² Net8 Client (and not Oracle Universal Installer) installs TCP/IP and Named Pipes, and auto-detects SPX. SPX is only installed in the installation packages if the appropriate software is detected on your system. If you explicitly select this product in the Custom installation type, it will be installed even if you do not have the appropriate software on your computer.
TCP/IP Enables client/server conversation over a network using TCP/IP and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through TCP/IP (if the Oracle database is running on a host system that supports network communication using TCP/IP).	Yes	Yes
SPX Enables client/server conversation over a network using SPX/IPX and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through SPX/IPX (if the Oracle database is running on a host system that supports network communication using SPX/IPX). This protocol is predominantly used in Novell Netware environments.	Yes	Yes
Named Pipes Enables client/server conversation over a network using Named Pipes and Net8. This combination of Oracle products enables an Oracle application on a client to communicate with remote Oracle databases through Named Pipes (if the Oracle database is running on a host system that supports network communication using Named Pipes).	Yes	Yes
Logical Unit Type 6.2 (LU6.2) Protocol Adapter The adapter is part of the IBM Advanced Program-to-Program Communication (APPC) architecture. APPC is the IBM peer-to-peer (program-to-program) protocol for a System Network Architecture (SNA) network. SNA is an IBM reference model similar to the Open Systems Interconnect (OSI) model of the International Standards Organization (ISO). APPC architecture lets the client and host communicate over an SNA network without forcing the client to emulate a terminal (as in terminal-to-host protocols). APPC architecture allows peer-to-peer communication; the client can initiate communication with the server. An SNA network with the LU6.2 and Physical Unit Type 2.1 (PU2.1) protocols provides APPC. The LU6.2 protocol defines a session between two application programs; LU6.2 is a product-independent LU-type. The LU6.2 Protocol Adapter enables an Oracle application on a PC to communicate with an Oracle database. This communication occurs over an SNA network with the Oracle database on a host system that supports APPC.	Yes	Yes
Bequeath Enables clients to retrieve information from the database without using the network listener. The Bequeath protocol internally spawns a server thread for each client application. In a sense, it does the same operation that a remote network listener does for your connection, but locally. Bequeath has the following attributes: Does not use a network listener (therefore, no network listener configuration is required) Used for local connections where an Oracle client application (such as SQLPlus) communicates with an Oracle server running on the same* machine Only works in Dedicated Server mode. Cannot be used in a Multi-Threaded Server (MTS) mode. Supported on Windows NT for 32-bit applications. Also works on Windows 95 for connections to a Oracle8i Personal Edition database for 32-bit applications. Installed by default with Net8 Client	Yes (installed with Net8 Client and Net8 Server)	N/A (installed with Net8 Client and Net8 Server)
Oracle Advanced Security--Export Edition Ensures secure transmission of data over networks. Uses encryption and authentication engines from RSA Data Security, Inc. See the Oracle Advanced Security Administrator's Guide for more information. Available algorithms: Encryption RC4_40 DES_40 Checksumming MD5	Yes	Yes
Oracle Advance Security Single Sign-On Allows users to access multiple accounts and applications with a single password. This feature eliminates the need for multiple user passwords and simplifies administration of user accounts and passwords. Centralized, secure authentication services ensure high confidence in the identity of users, clients, and servers in distributed environments. Network authentication services can also provide the benefit of single sign-on for users. Support exists for the following authentication methods: Kerberos RADIUS SSL SecurID Identix CyberSafe	Yes	Yes
Net8 Enhancements for Developers: Net8 OPEN An application programming interface (API) that lets developers write applications that use Net8 for connectivity. Net8 OPEN offers the following benefits: Enables development of both database and non-database applications that use an already deployed Net8 network. Enables deployment of an application developed on one machine to another without having to modify calls to the network interface. Provides a single common interface to all industry standard network protocols. For more information, see the Net8 Administrator's Guide.	Yes	Yes
Object Type Translator (OTT) OTT (executable name OTT.EXE) is used to create C-struct representations of Abstract Data Types that have been created and stored in an Oracle database. To take advantage of objects, run OTT against the database, and a header file is generated that includes the C structs. Oracle INTYPE File Assistant An assistant that helps you to create an INTYPE file, which provides a list of types for OTT to translate.	Yes	Yes
Oracle AppWizard for Microsoft Visual C++ Lets you create an Oracle application skeleton in C++ code without writing a single line of code. You then customize the application skeleton as needed. This wizard is integrated within the Microsoft Visual C++ 5.0 development environment. Note: To install Oracle AppWizard for Microsoft Visual C++, you must have Microsoft Visual C++ already installed.		Yes
Oracle Call Interface (OCI) An application programming interface (API) for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements.	Yes	Yes
Oracle Documentation Available in HTML, viewable using a Web browser. A PDF version is also available, but is not automatically installed. You can find the PDF documentation on the CD-ROM in the PDFDOC directory. The Adobe Acrobat Reader is located in the ACROREAD directory.	Yes	Yes
Oracle Java Database Connectivity (JDBC) Drivers A standard set of Java classes, specified by JavaSoft, that provide vendor-independent access to relational data from Java.	Yes	Yes
Oracle Java Tools Provides Java tools to build and deploy Java stored procedures, CORBA objects, and Enterprise JavaBeans with Oracle's Java Virtual Machine.	Yes	Yes
Oracle Objects for Object Linking and Embedding (OLE) A custom control (OCX or ActiveX) combined with an OLE in-process server that lets you plug native Oracle8i Enterprise Edition functionality into your Windows applications.	Yes	Yes
Oracle Open Database Connectivity (ODBC) Driver Provides support for ODBC connections from Windows NT, Windows 95, and Windows 98 client systems to Oracle databases. The Oracle ODBC Driver complies with version 3.00 of the Microsoft ODBC specification and supports all ODBC Core and the following Level 1 and Level 2 calls: SQLBrowseConnect SQLColumnPrivileges SQLDescribeParam SQLForeignKeys SQLMoreResults SQLPrimaryKeys SQLProcedureColumns SQLProcedures SQLTablePrivileges	Yes	Yes
Oracle SQLJ Translator A preprocessor for Java programs that contain embedded SQL statements. Oracle SQLJ Translator converts the SQL statements to JDBC calls.	Yes	Yes
Oracle Universal Installer A GUI application that lets you quickly install, update, and remove Oracle products. Oracle Universal Installer also automatically installs Oracle Home Selector, a tool that lets you edit your environmental path to make an appropriate Oracle home directory your primary home.	Yes	Yes
Oracle8i Enterprise Edition Release Notes Important last-minute installation and configuration information that you should read before using Oracle products.	Yes	Yes
*ProC/C++** The Pro*C/C++ precompiler takes SQL statements embedded in your C and C++ program and converts them to standard C code. When you precompile this code, the result is a C or C++ program that you can compile and use to build applications that access an Oracle database.	Yes	Yes
*ProCOBOL** To access an Oracle database, you use a high-level query language called Structured Query Language (SQL). You often use SQL through an interactive interface, such as SQLPlus. ProCOBOL is a precompiler that converts SQL statements embedded within COBOL programs into standard Oracle run-time library calls. The output file can then be compiled by a COBOL compiler.	Yes	Yes
*SQLPlus** Lets you use the SQL and PL/SQL database languages in the Windows NT, Windows 95, or Windows 98 environments. SQL*Plus has both command line and GUI versions.	Yes	Yes

Supported Protocol Stack Vendors

The table below lists the supported vendor for each networking protocol.

Protocol Platform Supported Vendor

TCP/IP

Windows NT and Windows 95/98

Microsoft TCP/IP

SPX

Windows NT and Windows 95/98

Microsoft NW Link for Windows NT, Windows 95/98

Novell NetWare Client 32 release 4.1

Novell IntranetWare Client release 4.1 for Windows NT

Novell IntranetWare Client release 2.2 for Windows 95

Note: For Microsoft NW Link, Client Service for NetWare must be installed.

Named Pipes

Windows NT and Windows 95/98

Microsoft NETBEUI

Host Naming Adapter

Windows NT

Microsoft TCP/IP

NDS Native Naming

Windows NT and Windows 95

Novell NetWare Client 32 release 4.1

Novell IntranetWare Client release 4.1 for Windows NT

Novell IntranetWare Client release 2.2 for Windows 95

Note: An Oracle Server release 7.2.2 or above for NetWare release 4.1 is required.

NDS authentication method

Windows NT and Windows 95

Novell NetWare Client 32 release 4.1

Novell IntranetWare Client release 4.1 for Windows NT

Novell IntranetWare Client release 2.2 for Windows 95

Note: An Oracle Server release 7.2.2 or above for NetWare release 4.1 is required.

Windows NT Native authentication method

Windows NT and Windows 95/98

Microsoft

Oracle Advanced Security Kerberos authentication method

Windows NT and Windows 95/98

No vendor software requirements on an Oracle client or server

Oracle Advanced Security RADIUS authentication method

Windows NT and Windows 95/98

No vendor software requirements on an Oracle client or server. The RADIUS server must be compliant with the standards in the Internet Engineering Task Force (IETF) RFC #2138, and RFC #2139
See: Oracle Advanced Security Administrator's Guide

Oracle Advanced Security SecurID authentication method

Windows NT and Windows 95/98

No vendor software requirements on an Oracle client or server, but a SecurID card is needed

SSL

Windows NT and Windows 95/98

No vendor software requirements. An X.509-compliant certificate server is required to generate certificates

Oracle Advanced Security option CyberSafe authentication method

Windows NT and Windows 95/98

CyberSafe Challenger, version 5.2.7.3 on client and server (Oracle product developed with CyberSafe Application Security Toolkit 1.1)

Oracle Advanced Security option Identix (Biometric) authentication method

Windows NT and Windows 95/98

Identix hardware and driver on an
Oracle 8 client

Logical Unit Type 6.2 (LU6.2) Protocol Adapter

Windows NT

Microsoft SNA Server, version 3.0

Protocol	Platform	Supported Vendor
TCP/IP	Windows NT and Windows 95/98	Microsoft TCP/IP
SPX	Windows NT and Windows 95/98	Microsoft NW Link for Windows NT, Windows 95/98 Novell NetWare Client 32 release 4.1 Novell IntranetWare Client release 4.1 for Windows NT Novell IntranetWare Client release 2.2 for Windows 95 Note: For Microsoft NW Link, Client Service for NetWare must be installed.
Named Pipes	Windows NT and Windows 95/98	Microsoft NETBEUI
Host Naming Adapter	Windows NT	Microsoft TCP/IP
NDS Native Naming	Windows NT and Windows 95	Novell NetWare Client 32 release 4.1 Novell IntranetWare Client release 4.1 for Windows NT Novell IntranetWare Client release 2.2 for Windows 95 Note: An Oracle Server release 7.2.2 or above for NetWare release 4.1 is required.
NDS authentication method	Windows NT and Windows 95	Novell NetWare Client 32 release 4.1 Novell IntranetWare Client release 4.1 for Windows NT Novell IntranetWare Client release 2.2 for Windows 95 Note: An Oracle Server release 7.2.2 or above for NetWare release 4.1 is required.
Windows NT Native authentication method	Windows NT and Windows 95/98	Microsoft
Oracle Advanced Security Kerberos authentication method	Windows NT and Windows 95/98	No vendor software requirements on an Oracle client or server
Oracle Advanced Security RADIUS authentication method	Windows NT and Windows 95/98	No vendor software requirements on an Oracle client or server. The RADIUS server must be compliant with the standards in the Internet Engineering Task Force (IETF) RFC #2138, and RFC #2139 See: Oracle Advanced Security Administrator's Guide
Oracle Advanced Security SecurID authentication method	Windows NT and Windows 95/98	No vendor software requirements on an Oracle client or server, but a SecurID card is needed
SSL	Windows NT and Windows 95/98	No vendor software requirements. An X.509-compliant certificate server is required to generate certificates
Oracle Advanced Security option CyberSafe authentication method	Windows NT and Windows 95/98	CyberSafe Challenger, version 5.2.7.3 on client and server (Oracle product developed with CyberSafe Application Security Toolkit 1.1)
Oracle Advanced Security option Identix (Biometric) authentication method	Windows NT and Windows 95/98	Identix hardware and driver on an Oracle 8 client
Logical Unit Type 6.2 (LU6.2) Protocol Adapter	Windows NT	Microsoft SNA Server, version 3.0

Unsupported Features

The following features are currently unsupported on the Microsoft NT and Windows 95/98 platforms.

Feature Description

TRCROUTE

Client application not supported on the NT and Windows platforms.

SPAWN

SPAWN command in the listener control utility is not supported on the NT and Windows platforms.

Pre-SPAWNED dedicated server processes

Not supported by the listener.

Feature	Description
TRCROUTE	Client application not supported on the NT and Windows platforms.
SPAWN	SPAWN command in the listener control utility is not supported on the NT and Windows platforms.
Pre-SPAWNED dedicated server processes	Not supported by the listener.