Before You Begin

This guide provides operating system-specific information on using Oracle Parallel Server for Windows NT.

Note:

OPS-specific implementation, installation and configuration issues are covered in Oracle8i Parallel Server Setup and Configuration Guide.

Topics discussed are:

Intended Audience

This guide is for network administrators and database administrators who install, configure, and use Oracle Parallel Server on Windows NT clusters.

Prerequisites

This guide assumes that you are familiar with:

Windows NT and have installed and tested it for your personal computer (PC) and network hardware
Object relational database management concepts

Structure

This guide contains the following chapters and appendices.

Chapter 1 Overview of Oracle Parallel Server

Describes the main features and components of Oracle Parallel Server.

Chapter 2 Migrating or Upgrading to Release 8.1

Describes setting up raw partitions for Oracle Parallel Server database files.

Chapter 3 Setting Up Raw Partitions

Describes Oracle Parallel Server initialization files and Oracle Parallel Server Manager.

Chapter 4 Oracle Parallel Server Management

Describes Oracle Parallel Server Management using OPSCTL.EXE.

Appendix A Directory Structure

Describes the directory structures for Oracle Parallel Server.

Appendix B OSD Registry Entries

Describes the Oracle Operating System Dependent (OSD) registry entries.

Appendix C Troubleshooting

Describes how to resolve Oracle Parallel Server problems.

Documentation and Code Conventions

The following conventions are used in this guide:

Convention Example Meaning

All uppercase plain

ORANT\NETWORK

Indicates command names, SQL reserved words, and keywords, as in ALTER DATABASE. All uppercase plain is also used for directory names and file names

Italic

Italic is used to indicate a variable:
filename
Italic is used for emphasis:
The WHERE clause may be used to join rows in different tables.

Indicates a value that you must provide. For example, if a command asks you to type filename, you must type the actual name of the file.
Italic is also used for emphasis in the text and to indicate the titles of other guides.

Square brackets [ ]

X:\[PATHNAME]\ORACLE\
HOME_NAME

Encloses optional items. For example, when you create an OFA-compliant Oracle home directory, you can place an optional pathname before the \ORACLE pathname.
Square brackets also indicate a function key, for example [Enter].

Choose Start >

Choose Start > Programs > Oracle > HOME_NAME > Network Administration > Net8 Easy Config

How to start a program. For example, to start Net8 Easy Config, you must click the Start button on the taskbar and then choose Programs, Oracle, HOME_NAME Oracle Universal Installer.

C:\>

C:\ORACLE\ORA81>

Represents the Windows NT command prompt of the current hard disk drive. Your prompt reflects the subdirectory in which you are working. Referred to as the MS-DOS command prompt in this guide.

Backslash (\) before a directory name

\OPS

Indicates that the directory is a subdirectory of the root directory.

ORACLE_HOME and ORACLE_BASE

Go to the ORACLE_BASE\ORACLE_HOME\BIN directory

In previous releases when you installed Oracle8 Enterprise Edition, all subdirectories were located under a top level ORACLE_HOME directory, that by default was:
C:\ORANT for Windows NT
C:\ORAWIN95 for Windows 95
C:\ORAWIN for Windows 3.1
or whatever you may have called your Oracle home.
In this Optimal Flexible Architecture (OFA)-compliant release, all subdirectories are no longer under a top level ORACLE_HOME directory. There is now a new top level directory called ORACLE_BASE that by default is C:\ORACLE. If you install Oracle8 Enterprise Edition release 8.1.3 on a clean computer (that is, there is no other Oracle software on the computer), the default settings for the first Oracle home directory is C:\ORACLE\ORA81. If you run Oracle Universal Installer again and install release 8.2.x, the second Oracle home directory is called \ORA82. These Oracle home directories are located directly under ORACLE_BASE.
See Chapter 4, "Multiple Oracle Homes and Optimal Flexible Architecture" of the Oracle8 Enterprise Edition Getting Started for Windows NT guide for more information.

%ORACLE_HOME%

SVRMGR> @%ORACLE_HOME%\ADMIN\DB_NAME\ADHOC\CATALOG.SQL

In Server Manager commands, you may see %ORACLE_HOME%. Server Manager is able to locate your Oracle Home directory using the %ORACLE_HOME% variable. This convention can be used in Server Manager, SQL*Plus, Export Utility, and Import Utility.

HOME_NAME

OracleHOME_NAMETNSListener80

Represents the Oracle home name.
The home name can be up to sixteen alphanumeric characters. The only special character allowed in the home name is the underscore.

HOMEID

HOME0, HOME1, HOME2

Represents a unique registry subkey for each Oracle home directory in which you install products. A new HOMEID is created and incremented each time you install products to a different Oracle home directory on one computer. Each HOMEID contains its own configuration parameter settings for installed Oracle products.

Symbols

period .
comma ,
hyphen -
semicolon ;
colon :
equal sign =
backslash \
single quote `
double quote "
parentheses ()

Symbols other than brackets and vertical bars must be entered in commands exactly as shown.

Convention	Example	Meaning
All uppercase plain	ORANT\NETWORK	Indicates command names, SQL reserved words, and keywords, as in ALTER DATABASE. All uppercase plain is also used for directory names and file names
Italic	Italic is used to indicate a variable: filename Italic is used for emphasis: The WHERE clause may be used to join rows in different tables.	Indicates a value that you must provide. For example, if a command asks you to type filename, you must type the actual name of the file. Italic is also used for emphasis in the text and to indicate the titles of other guides.
Square brackets [ ]	X:\[PATHNAME]\ORACLE\ HOME_NAME	Encloses optional items. For example, when you create an OFA-compliant Oracle home directory, you can place an optional pathname before the \ORACLE pathname. Square brackets also indicate a function key, for example [Enter].
Choose Start >	Choose Start > Programs > Oracle > HOME_NAME > Network Administration > Net8 Easy Config	How to start a program. For example, to start Net8 Easy Config, you must click the Start button on the taskbar and then choose Programs, Oracle, HOME_NAME Oracle Universal Installer.
C:\>	C:\ORACLE\ORA81>	Represents the Windows NT command prompt of the current hard disk drive. Your prompt reflects the subdirectory in which you are working. Referred to as the MS-DOS command prompt in this guide.
Backslash (\) before a directory name	\OPS	Indicates that the directory is a subdirectory of the root directory.
ORACLE_HOME and ORACLE_BASE	Go to the ORACLE_BASE\ORACLE_HOME\BIN directory	In previous releases when you installed Oracle8 Enterprise Edition, all subdirectories were located under a top level ORACLE_HOME directory, that by default was: C:\ORANT for Windows NT C:\ORAWIN95 for Windows 95 C:\ORAWIN for Windows 3.1 or whatever you may have called your Oracle home. In this Optimal Flexible Architecture (OFA)-compliant release, all subdirectories are no longer under a top level ORACLE_HOME directory. There is now a new top level directory called ORACLE_BASE that by default is C:\ORACLE. If you install Oracle8 Enterprise Edition release 8.1.3 on a clean computer (that is, there is no other Oracle software on the computer), the default settings for the first Oracle home directory is C:\ORACLE\ORA81. If you run Oracle Universal Installer again and install release 8.2.x, the second Oracle home directory is called \ORA82. These Oracle home directories are located directly under ORACLE_BASE. See Chapter 4, "Multiple Oracle Homes and Optimal Flexible Architecture" of the Oracle8 Enterprise Edition Getting Started for Windows NT guide for more information.
%ORACLE_HOME%	`SVRMGR> @%ORACLE_HOME%\ADMIN\DB_NAME\ADHOC\CATALOG.SQL`	In Server Manager commands, you may see %ORACLE_HOME%. Server Manager is able to locate your Oracle Home directory using the %ORACLE_HOME% variable. This convention can be used in Server Manager, SQL*Plus, Export Utility, and Import Utility.
HOME_NAME	OracleHOME_NAMETNSListener80	Represents the Oracle home name. The home name can be up to sixteen alphanumeric characters. The only special character allowed in the home name is the underscore.
HOMEID	HOME0, HOME1, HOME2	Represents a unique registry subkey for each Oracle home directory in which you install products. A new HOMEID is created and incremented each time you install products to a different Oracle home directory on one computer. Each HOMEID contains its own configuration parameter settings for installed Oracle products.
Symbols	period . comma , hyphen - semicolon ; colon : equal sign = backslash \ single quote ` double quote " parentheses ()	Symbols other than brackets and vertical bars must be entered in commands exactly as shown.