Library Product

Oracle Rdb7^(tm) for OpenVMS

Oracle SQL/Services^(tm) Installation Guide

Release 7.0

Part No. A42343-1

Corporate Copyright Notice

Copyright 1991, 1996 Oracle Corporation.

All rights reserved.

IMPORTANT - READ CAREFULLY BEFORE VIEWING AND/OR USING THIS DOCUMENTATION IN ANY WAY. NO PART OF THIS DOCUMENTATION MAY BE REPRODUCED OR TRANSMITTED IN ANY FORM OR BY ANY MEANS, ELECTRONIC OR MECHANICAL, FOR ANY PURPOSE, WITHOUT THE EXPRESS WRITTEN PERMISSION OF ORACLE CORPORATION.

This software contains proprietary information of Oracle Corporation; it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free.

Restricted Rights Legend Programs delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the programs shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, programs delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the programs shall be subject to the restrictions in FAR 52.227-14, Rights in Data---General, including Alternate III (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

The programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, back up, redundancy and other measures to ensure the safe use of such applications if the programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the programs.

Oracle, SQL*Net, and Secure Network Services are registered trademarks of Oracle Corporation, Redwood City, California. Rdb7, Oracle Rdb, Oracle RMU, DBAPack, Oracle Network Manager, Oracle7, and Oracle SQL/Services are trademarks of Oracle Corporation, Redwood City, California.

All other company or product names are used for identification purposes only, and may be trademarks of their respective owners.

Preface

Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this publication. Your input is an important part of the information used for revision.

You can send comments to us in the following ways:

• Electronic mail --- nedc_doc@us.oracle.com
• FAX --- 603-897-3334 Attn:Oracle Rdb Documentation
• Postal service

  Oracle Corporation 
  Oracle Rdb Documentation 
  One Oracle Drive
  Nashua, NH  03062
  USA 
  

If you like, you can use the following questionnaire to give us feedback. (Edit the online release notes file, extract a copy of this questionnaire, and send it to us.)

• Did you find any errors?
• Is the information clearly presented?
• Do you need more information? If so, where?
• Are the examples correct? Do you need more examples?
• What features did you like most about this manual?

If you find any errors or have any other suggestions for improvement, please indicate the chapter, section, and page number (if available).

Oracle SQL/Services, a client/server component of Oracle Rdb, allows you to develop client application programs on a variety of desktop and mainframe systems so that you can access Oracle Rdb databases as well as other databases supported by the SQL interface to Oracle Rdb.

Purpose of This Manual

This manual describes how to install and configure Oracle SQL/Services Version 7.0 for OpenVMS Alpha and OpenVMS VAX systems. This installation guide and the Oracle SQL/Services Release Notes are the only manuals that you need to install the Oracle SQL/Services server and OpenVMS client API software. Refer to the readme text files on the Oracle Rdb Client CD-ROM for installing all other client application programming interface (API) software.

Oracle SQL/Services software is installed separately from the SQL and Oracle Rdb software. There is a separate installation guide for installing SQL and Oracle Rdb. Oracle SQL/Services is a client/server product in which client application programs usually (but not necessarily) run on different systems than the server. Appendix A presents the installation for the Oracle SQL/Services OpenVMS client application programming interface (API) software.

You do not have to install a previous version of Oracle SQL/Services before installing Oracle SQL/Services V7.0.

Keep this guide with your distribution kit. You will need it to install maintenance updates or to reinstall Oracle SQL/Services for any other reason.

Intended Audience

Read this manual if you are responsible for:

• Planning the installation of Oracle SQL/Services and preparing your system (see Chapter 1)
• Installing Oracle SQL/Services (see Chapter 2)
• Changing your system by adjusting parameters, startup and shutdown files, and privileges required for running Oracle SQL/Services (see Chapter 3)
• Running multiple versions of Oracle SQL/Services on a single OpenVMS system or running multiple versions of Oracle Rdb with Oracle SQL/Services (see Chapter 4)
• Determining the transports supported, transport error code information, and guidelines for using each transport (see Chapter 5)

To install the software, you must:

• Be familiar with VMSINSTAL, the command procedure used to install software products in the OpenVMS environment. To locate the description of VMSINSTAL, see the OpenVMS documentation set.
• Have access to the SYSTEM account on your system or to an account with the user privilege, SETPRV.

Operating System Information

You can find information about the versions of the operating system and optional software that are compatible with this release of Oracle Rdb and Oracle SQL/Services in the Oracle Rdb7 Installation and Configuration Guide and also in the Oracle Rdb7 Release Notes and the Oracle SQL/Services Release Notes.

Contact your Oracle Corporation support representative if you have other questions about product requirements or compatibility. In addition, for more information about compatible products and their required version numbers, you can access the World Wide Web (WWW):

http://www.oracle.com/products/servers/rdb/html/Matrix.html 

Structure

This manual has the following chapters and appendixes:

Chapter 1	Explains how to plan the installation and prepare your system.
Chapter 2	Explains how to install the Oracle SQL/Services software and run the Installation Verification Procedure (IVP).
Chapter 3	Explains procedures to follow after the installation of Oracle SQL/Services completes successfully.
Chapter 4	Describes how to run multiple versions of Oracle SQL/Services on OpenVMS systems and how to run multiple versions of Oracle Rdb with Oracle SQL/Services.
Chapter 5	Describes the transports supported, transport error code information, and guidelines for using each transport.
Appendix A	Shows how to install the OpenVMS VAX and OpenVMS Alpha client APIs for Oracle SQL/Services.
Appendix B	Shows a sample server kit installation for the multiversion variant and standard version of Oracle SQL/Services.

Related Manuals

The Oracle SQL/Services documentation set contains detailed information and guidelines for installing software on your OpenVMS systems and for becoming familiar with related system management tasks.

The Oracle SQL/Services Server Configuration Guide contains information on configuring and managing the Oracle SQL/Services server on your OpenVMS systems.

The Guide to Using the Oracle SQL/Services Client API provides reference material and a complete description of API routines, data structures, and supported data types in addition to a description of the tools for API application development for the experienced programmer.

The Oracle SQL/Services Release Notes may contain information needed to install Oracle SQL/Services. Read that document before starting the Oracle SQL/Services installation.

Conventions

In this manual, Oracle Rdb refers to Oracle Rdb for OpenVMS software. Release 7.0 of Oracle Rdb software is often referred to as V7.0.

The SQL interface to Oracle Rdb is referred to as SQL. This interface is the Oracle Rdb implementation of the SQL standard ANSI X3.135-1992, ISO 9075:1992, commonly referred to as the ANSI/ISO SQL standard or SQL92.

Oracle ODBC Driver for Rdb software is referred to as the ODBC driver.

This manual uses icons to identify information specific to an operating system or platform. Where material pertains to more than one platform or operating system, combination icons or generic icons are used. For example:
The Alpha icon denotes the beginning of information specific to the OpenVMS Alpha operating system.

The VAX icon denotes the beginning of information specific to the OpenVMS VAX operating system.

The diamond symbol denotes the end of a section of information specific to the specified operating system.

These icons do not appear in the .TXT version of this document but are replaced by characters enclosed in angle brackets (<>).

File names and names of utilities are varianted for a multiversion installation. That is, the file name or utility may have a two-digit version number appended to the last two characters of its name. For example, the management client is SQLSRV_MANAGE70 and log files are *70.log, and so forth, if Oracle SQL/Services V7.0 is installed multiversion on the same node as a previous version of Oracle SQL/Services. For a standard installation, file names and names of utilities are not varianted. This manual assumes you have a standard installation and uses the nonvarianted names of files and utilities unless use of varianted names makes the meaning clearer. <>

OpenVMS means both the OpenVMS Alpha and the OpenVMS VAX operating systems.

In examples, an implied carriage return occurs at the end of each line. You must press the Return key at the end of a line of input.

Discussions in this manual that refer to VMScluster environments apply to both VAXcluster systems that include only VAX nodes and VMScluster systems that include at least one Alpha node, unless indicated otherwise.

The following conventions are also used in this manual:

. . .	Vertical ellipsis points in an example mean that information not directly related to the example has been omitted.
...	Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted.
< >	Angle brackets enclose user-supplied names.
boldface text	Boldface type in text indicates a term defined in the text, the glossary, or in both locations.
[ ]	In text, brackets enclose optional information from which you can choose one or none. In a prompt, brackets indicate that the enclosed item is the default response. For example, [y] means the default response is Yes.
$	The dollar sign represents the DIGITAL Command Language prompt. This symbol indicates that the DCL interpreter is ready for input.
Ctrl/C	This symbol indicates that you must press the Ctrl key while you simultaneously press another key (in this case, C).
ftp>	The ftp> sign represents the File Transfer Protocol (FTP) prompt.
NCP>	The NCP> sign represents the Network Control Program (NCP) or Network Control Language (NCL) prompt.

Terminology

Some Oracle SQL/Services terminology in this manual has changed effective with release 7.0 of Oracle SQL/Services. The revised terminology reflects changes in the current server architecture compared to the original Oracle SQL/Services architecture, and makes terminology consistent on all Oracle SQL/Services server platforms.

• The term dispatcher replaces all instances of the phrase communications server.
• The term executor or executors replaces all instances of the phrase execute server process or execute server processes.
• The term service replaces all instances of the term class.
• The term universal replaces all instances of the term generic when referring to a service type. For example, the phrase session reusable generic service becomes session reusable universal service and generic service becomes universal service. The universal service name GENERIC is still valid.

These terminology changes occur throughout this manual.

Library Product

Copyright ©1996, Oracle Corporation All rights reserved.