Oracle7 Getting Started for Windows NT

Oracle7 Getting Started for Windows NT

Oracle7 Server Getting Started for Windows NT

Preface

: Prerequisites
: Intended Audience
: Structure
: Conventions

1 Getting Started with Your Documentation

Documentation Formats

What Documentation Did I Receive?

: Documentation Set

What Documentation Do I Read First?

Where Do I Look for Specific Information?

2 Introducing Oracle7 Server for Windows NT

What is Oracle7 Server for Windows NT?

: Key Features of Oracle7 Server for Windows NT

What are the New Features of This Release?

How is Oracle7 Server Integrated with Windows NT?

: Windows NT Services and Oracle Instances
: Workstation Security
: Memory Structures

3 Post-installation Tasks

The Starter Database

: What Does Your Starter Database Include?

Configuring SQL*Net

Configuring Oracle Enterprise Manager

: Configuration Tasks
: Verify Oracle Services Are Started
: Start the Oracle Intelligent Agent
: Create a Repository User Account
: Create an NT User Account
: Create TNSNAMES.ORA and TOPOLOGY.ORA
: Access Oracle Enterprise Manager and Create the Repository
: Discovering Network Services
: Stop the Oracle Intelligent Agent

Configuring Oracle7 Spatial Data Option

Configuring ConText Option

: ConText Option Demos

: User Defined Filters

: Running ConText Option Server Processes on Windows NT

Configuring Advanced Replication Option

: Tablespace Requirements
: Initialization Parameters
: Configuration Tasks
: Data Dictionary Tables

Configuring Oracle Client Software Manager (OCSM)

: Configuration Options

Compiling and Linking Oracle XA Library

Implementing Multiple Oracle Homes (16-Bit Only)

: Create Another Oracle Home
: Switch Between Oracle Homes

4 Using Tools and Utilities

Choosing Which Tool or Utility To Use

Starting Tools and Utilities

Using Instance Manager from the Command Line

Using SQL*Loader with Windows NT

: Windows NT Processing Options
: Direct Path Option
: Control File Conventions

Oracle Database Administration Tools Support

: 32-bit Oracle Database Administration Tools
: 16-bit Oracle Database Administration Tools

5 Creating a New Database

Steps to Create a Database

: Export Your Current Database
: Delete Relevant Database Files
: Modify the Initialization Parameter File
: Create and Start an Oracle7 Database Service
: Prepare CREATE DATABASE SQL Script
: Create a Database
: Import a Database
: Update ORACLE_SID in the Windows NT Registry
: Back Up the New Database

Creating a New Database with NT Instance Manager GUI

6 Administering a Database

Managing Oracle Database Services

: Oracle Database Services
: Starting Oracle Services
: Stopping Oracle Services

Starting Up and Shutting Down a Database with Server Manager

: Starting Up a Database
: Shutting Down a Database

Running Multiple Instances

Integrating Database User Authentication with Windows NT

Authenticating Database Administrators

: Using Password Files
: Using Operating System Authentication
: Connecting as SYSOPER and SYSDBA
: Connecting as INTERNAL

Granting Database Roles with Windows NT

Encrypting Database Passwords

Refreshing Table Snapshots

7 Monitoring a Database

Database Monitoring Overview

Using Performance Monitor

: Accessing the Performance Monitor
: Monitoring Oracle7 Objects
: Oracle7 Specific Information

Using Event Viewer

Using Trace and Alert Files

: Trace Files
: Alert Files

8 Backing Up and Recovering Database Files

: Backing Up Database Files
: Backing Up Files with OCOPY
: Recovering Files with OCOPY

A Oracle7 Server Directory Structures

: Windows NT Directory Structure
: Windows 95 and Windows 3.1 Directory Structures

B Initialization Parameter Files

What Is an Initialization Parameter File?

: Location
: Editing
: Sample File

Oracle7 Server for Windows NT Initialization Parameters

: Creating a New Database--Initialization Parameters
: Advanced Replication Initialization Parameters

C Configuration Parameters and the Registry

About Configuration Parameters

Editing Configuration Parameters

: In the Windows NT Registry
: In the AUTOEXEC.BAT File
: At the Command Prompt

Configuration Parameters Not Supported on Oracle7

Supported Configuration Parameters

: NLS_LANG
: ORACLE_GROUP_NAME
: ORACLE_HOME
: ORACLE_PRIORITY
: ORACLE_SID
: ORA_sid_PWFILE
: ORA_XCPT, ORA_sid_XCPT
: PLSQLnn
: RDBMSnn

D Messages and Codes

Logging Error Messages

Oracle Installer Error Messages

Codes 9200-9499: Oracle7 Server Database Messages

Codes 4000-4999: Windows NT-Specific Oracle Messages

: File I/O Errors: OSD-4000 to OSD-4099
: Memory Errors: OSD-4100 to OSD-4199
: Process Errors: OSD-4200 to OSD-4299
: Loader Errors: OSD-4300 to OSD-4399
: Semaphore Errors: OSD-4400 to OSD-4499
: Miscellaneous Errors: OSD-4500 to OSD-4599

E National Language Support

NLS_LANG Parameters and Components

Default Values for NLS_LANG

NLS Initialization Parameters

: NLS_LANGUAGE
: NLS_TERRITORY
: NLS_SORT

Language, Territory and Character Set Parameter Lists

: Languages
: Territories
: Single-Byte Character Sets
: Multi-Byte Character Sets

Installing Additional Languages

: Language File Abbreviations

F Contacting Oracle Worldwide Customer Support

Known Problems, Restrictions and Workarounds

Contacting Oracle Worldwide Customer Support

: How to Contact Oracle Worldwide Customer Support
: Before You Call for Assistance

Glossary

Index

Copyright © 1996 Oracle Corporation
500 Oracle Parkway, Redwood City, CA 94065