[Contents] [Index] [Info] [Previous] [Next]

About this Guide

The Oracle7 for OpenVMS Server and Tools Administrator's Guide, Version 7.3.3 is one of a set of Oracle documents that describe how to install, establish, maintain, and use the Oracle7 Server and related Oracle products on OpenVMS.

The README files in the Oracle product directories contain the latest information about the OpenVMS production releases of Oracle7 and related products for OpenVMS.

The purpose of this guide is to help you administer the Oracle7 Server and its application development tools.

For the Latest Information

For the latest information about OpenVMS production releases of Oracle7 and related products, see the README files in the Oracle product directories.

Install Only Licensed Products

You are entitled to install and use only those products for which you have a current Oracle license agreement.

Audience

This guide is written for system administrators or database administrators (DBAs) who administer Oracle7. This guide assumes that the user has a fundamental knowledge of the OpenVMS operating system; it does not document any features of OpenVMS except when they affect or are affected by the Oracle7 system.

How this Guide Is Organized

This guide is organized as follows:

PART I : Administering the Oracle7 Server

This part covers activities that are related to maintaining the database once the Oracle7 Server has been installed and the instances accessing the database have been set up.

Chapter 1: Introduction to Oracle7 on OpenVMS
This chapter introduces Oracle products and gives an overview of Oracle7 system on OpenVMS.

Chapter 2: Setting Up Oracle7 Users
This chapter describes how to grant access to Oracle7 and how to set up specific tools.

Chapter 3: Starting Up and Shutting Down Oracle7
This chapter describes how to start up and shut down Oracle7.

Chapter 4: Managing Instances
This chapter describes how to define, delete, and control single and parallel instances.

Chapter 5: Managing the Database
This chapter describes how to manage the files that make up the physical database and other topics related to managing the database.

Chapter 6: Backing Up and Archiving Your Database
This chapter describes how to back up and archive your database.

Chapter 7: Recovering Your Data
This chapter describes how to recover previously backed up data.

Chapter 8: Optimizing Oracle7
This chapter describes how to tune Oracle7 and how to identify, monitor, and correct situations that cause problems while administering the database.

Chapter 9: Trace Files
This chapter describes how to set up and use trace files.

PART II : Using and Administering the Oracle Tools

This part presents the tools in separate chapters, organized alphabetically.

Chapter 10: Oracle Programmatic Interfaces

This chapter explains how to use the Oracle Programmatic Interfaces and SQL*Module in the OpenVMS environment.

Chapter 11: SQL*Plus

This chapter explains how to use SQL*Plus in the OpenVMS environment.

PART III : Appendices

This part includes supplementary information.

Appendix A: National Language Support
This appendix lists the languages, character sets, and sort sequences supported on OpenVMS and describes how to select them.

Appendix B: Logical Names and Parameters
This appendix provides information about Oracle7 logical names and OpenVMS-specific INIT.ORA parameters that are defined differently for different operating systems.

Appendix C: Messages and Codes This appendix explains the means of error messages you might see while using Oracle products on OpenVMS.

Appendix D: OpenVMS Process Control This appendix explains how to control Oracle Server processes on OpenVMS.

Appendix E: OpenVMS Supplement to the Generic Documentation Set This appendix gives OpenVMS specific information for each cross-reference from the generic documentation set.

Conventions Used in this Guide

This section explains the following:

Syntax

This guide uses the following conventions:

monospaced font Monospaced font is used to represent information displayed on a terminal or monitor or entered on a keyboard. For example, menu screens that are displayed during the Oracle7 installation procedure are represented in this guide with monospaced font.
UPPERCASE Uppercase in monospaced font represents a command name. Enter the text exactly as shown.
UPPERCASE Uppercase words within the text refer to command names.
<variable> <lowercase italicized words> in monospaced font enclosed by angle brackets represent a variable on the command line. Substitute an appropriate value.
<variable> <lowercase italicized words> enclosed by angle brackets within the text refer to variable names.

Terminology

Oracle Refers only to the company, Oracle Corporation, that develops and distributes the Oracle7 Server and Oracle products.
Oracle7 Server Refers to a single Oracle product. The Oracle7 Server is sometimes referred to as the kernel, the RDBMS, or simply Oracle7. The Oracle7 Server is the Oracle product that stores, manages, and manipulates data. It consists of the database manager, the database administrator utility called Server Manager, several user utilities (Export, Import, SQL*Loader, and the Database Verification Utility), and the data access optimizer.
Oracle7 System Refers to all the Oracle products installed at a site, including the Oracle7 Server and any optional tools such as Oracle Forms or SQL*Net, and to the structures created in shared OpenVMS memory when Oracle7 is running. So, the correct definition of an Oracle7 system varies from site to site. Note that in this guide the word database refers only to the files that contain data stored by the Oracle7 Server.

Related Products and Documents

This section explains the following:

Related Products

The following is a list of Oracle products, utilities, and options that are available with Oracle7:

Do Not Link Oracle7 Version 7.1 Products with Oracle7 Server Version 7.3

Products that are distributed with the Oracle7 Server Version 7.1 should not be linked against Oracle Server Version 7.3. Even though some of the product version numbers remain the same, products linked against Oracle7 Server Version 7.1 cannot be used with Oracle7 Server Version 7.3 unless you access Oracle7 Server Version 7.3 using SQL*Net.

Related Documents

This documentation set includes the following guides:

For more information on the Oracle7 Server, refer to the following generic documentation:

Migrating from Oracle Version 6

For more information about migrating from Oracle Version 6 to Oracle 7, see the following manual:

Customer Support Information

(Please copy this page and distribute within your organization as necessary.)

For Oracle Worldwide Customer Support Services (WCSS), contact your local number. (The hours are detailed in your support contract.) ___________________________________

Please prepare the following information before you call, using this page as a checklist:

Note: Keep in mind what did not happen, as well as what did happen. This type of information can help WCSS to more quickly resolve your problem.

For installation-related problems please have the following information available:

Your Comments Are Welcome

We value and appreciate your comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate our documentation, your opinions are the most important input we receive. At the back of our printed manuals is a Reader's Comment Form, which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals. If the form is not available, please use the following address, telephone number, or FAX number.

Digital Products Division
Publications Manager
Oracle Corporation
500 Oracle Parkway
Box 659104
Redwood Shores, CA 94065
Phone: (650) 506-7000
FAX: (650) 506-7361

[Contents] [Index] [Info] [Previous] [Next]