Oracle7 Workgroup Server Getting Started for Windows NT Go to Product Documentation Library
Library
Go to books for this product
Product


Oracle7 Workgroup 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 Workgroup Server for Windows NT

What is Oracle7 Workgroup Server for Windows NT?
Key Features of Oracle7 Workgroup Server for Windows NT
What are the New Features of This Release?
How is Oracle7 Workgroup 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 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

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 Workgroup 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 Workgroup Server for Windows NT Initialization Parameters
Creating a New Database--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 Workgroup 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
Replication Between Versions 7.2 and 7.3
Using NT Backup Manager
Support for Universal Naming Conventions
Windows NT Registry Keys
Operating System Permission Problems
Contacting Oracle Worldwide Customer Support
How to Contact Oracle Worldwide Customer Support
Before You Call for Assistance

Glossary

Index


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


Go to Product Documentation Library
Library
Go to books for this product
Product