Oracle8(TM) Getting Started for Windows NT
Release 8.0.3






Title and Copyright Information

Send Us Your Comments


1 Getting Started with Your Documentation

Documentation Formats
What Documentation Did I Receive?
Documentation Set
What Documentation Do I Read First?
Starting Oracle Information Navigator
Starting Adobe Acrobat Reader

2 Introducing Oracle8

What is Oracle8?
Key Features
New Features
What Oracle8 Products are Available for Installation?

3 Starter Database Contents

Starter Database
Starter Database Contents
User Accounts
Data Files
Initialization Parameter File
Redo Log Files
Control File
Data Dictionary

4 Database Tools

Choosing Which Database Tools to Use
Database Tools and Operating System Compatibility
Preferred Database Tools
Starting Database Tools
Oracle8 Utilities
Windows NT Tools
Oracle Enterprise Manager
Oracle Assistants
NT Backup Manager
NT Recovery Manager
Using ORADIM80
Using SQL*Loader with Windows NT
Windows NT Processing Options
Direct Path Option
Control File Conventions

5 Database Co-existence and Migration

Database Co-existence and Migration Overview
Co-existence and Migration Decisions
Oracle7 and Oracle8 Client and Server Configuration
Install Oracle7 and Oracle8 in the Same Oracle Home
Install Oracle7 and Oracle8 on Separate Servers
Migrate Oracle7 Data to an Oracle8 Database
Upgrade Oracle7 Clients to Oracle8
Co-existence and Migration Networking Issues
Co-existence Issues
Migration Issues
Installing an Oracle7 and Oracle8 Database in the Same Oracle Home
Using Oracle Data Migration Assistant
Using the Migration Utility (MIG80)
Using Oracle Migration Assistant for Microsoft Access
Known Problems, Restrictions, and Workarounds

6 Configuration Tasks

What Must You Configure?
Configuring Net8
Configuring Oracle Enterprise Manager
Step 1: Start Oracle Services
Step 2: Create a Repository User Account
Step 3: Create an NT User Account
Step 4: Create Configuration Files
Step 5: Create the Repository and Discover Services
Configuring Oracle8 ConText Cartridge
Running Server Processes on Windows NT

7 Oracle8 Integration with Windows NT

Event Viewer
What Oracle8 Database Events Are Monitored?
Performance Monitor
What Oracle8 Database Information is Monitored?
What Database Parameters Are Configured?
Control Panel
What Oracle8 Services Appear in the Control Panel?
User Manager
What Oracle8 Database Tasks Can the User Manager Perform?

8 Understanding Oracle Enterprise Manager

Oracle Enterprise Manager
Overview of Oracle Enterprise Manager Components
Oracle Enterprise Manager Console Features
Common Services for Managing Databases
Integrated Applications

9 Creating a Database

Naming Conventions for Oracle8 Databases
Using Oracle Database Assistant
Creating a Database Manually
Step 1: Export an Existing Database
Step 2: Delete Database Files
Step 3: Modify or Create the INITSID.ORA File
Step 4: Create and Start an Oracle8 Service
Step 5: Prepare CREATE DATABASE SQL Statement
Step 6: Create a Database
Step 7: Import a Database
Step 8: Update ORACLE_SID in the Registry
Step 9: Back Up the New Database

10 Administering a Database

Starting and Stopping Oracle Services
Starting Oracle Services
Stopping Oracle Services
Auto-starting Oracle Services
Starting and Shutting Down a Database with Server Manager
Starting Server Manager
Starting a Database with Server Manager
Shutting Down a Database with Server Manager
Starting and Shutting Down a Database with Oracle Enterprise Manager
Starting a Database with Oracle Enterprise Manager
Shutting Down a Database with Oracle Enterprise Manager
Shutting Down a Database By Stopping a Service
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
Changing the Internal Password:
Granting Database Roles with Windows NT
Encrypting Database Passwords
Using the Oracle Enterprise Manager Console
Logging In
Performing Simple Single Tasks in the Navigator
Creating Maps
Integrating Applications into the Console

11 Monitoring a Database

Database Monitoring Overview
Using Oracle8 Performance Monitor
Oracle8 Performance Monitor Setup Information
Accessing Oracle8 Performance Monitor
Monitoring Oracle8 Objects
Understanding Oracle8 Performance Objects
Oracle8 Troubleshooting Information
Using the Event Viewer
Accessing the Event Viewer
Reading the Event Viewer
Using the Event Viewer
Using Trace and Alert Files
Using the Performance Pack
Performance Monitor Applications
Oracle Trace
Oracle Expert

12 Backing Up and Recovering Database Files

Selecting a Backup and Recovery Tool
Backing Up Files with OCOPY
Recovering Files with OCOPY

13 Applications Development

Building External Procedures
What are External Procedures?
Step 1: Installing and Configuring
Step 2: Writing an External Procedure
Step 3: Building a Shared Library
Step 4: Registering an External Procedure
Step 5: Executing an External Procedure
Additional Documentation
Compiling and Linking the Oracle XA Library
Compiling and Linking a Pro*C Program
Compiling and Linking an OCI Program
Accessing Web Data with Intercartridge Exchange
Configuring Intercartridge Exchange
Using Intercartridge Exchange
Packaged Function UTL_HTTP.REQUEST
UTL_HTTP Exception Conditions
Exceptional Conditions and Error Messages

14 Oracle8 ConText Filters, Demos, and Workbench

Oracle8 ConText Filters
Setting Up Oracle8 ConText Filters
Creating Wrappers for Oracle8 ConText Filters
Using Oracle8 ConText Filters
Oracle8 ConText Cartridge Demos
Oracle8 ConText Cartridge Workbench
Oracle8 ConText Cartridge System Administration
Oracle8 ConText Cartridge Viewer
Oracle8 ConText Cartridge I/O Utility

A Directory Structures

Windows NT Server Directory Structure
Client Directory Structure

B Initialization Parameter Files

What Is an Initialization Parameter File?
Sample File
Initialization Parameters
Creating a New Database-Initialization Parameters

C Configuration Parameters and the Registry

About Configuration Parameters
Registry Overview
Registry Parameters
Modifying a Registry Value
Adding a Registry Parameter

D Messages and Codes

Logging Error Messages
Oracle Installer Error Messages
Codes 09200-09499: Oracle8 Database Messages
Codes 04000-04999: Windows NT-Specific Oracle Messages
File I/O Errors: OSD-04000 to OSD-04099
Memory Errors: OSD-04100 to OSD-04199
Process Errors: OSD-04200 to OSD-04299
Loader Errors: OSD-04300 to OSD-04399
Semaphore Errors: OSD-04400 to OSD-04499
Miscellaneous Errors: OSD-04500 to OSD-04599

E National Language Support

NLS_LANG Parameters and Components
Default Values for NLS_LANG
Installing Additional Languages

F Distributing and Managing Oracle Software

Oracle Client Software Manager
Reviewing the Installation Requirements
Creating an OCSM Host Machine
Giving OCSM Clients Access to Oracle Home on the OCSM Host Machine
Registering the Client Machine
Understanding the Oracle Client Configuration Manager
Understanding Client User vs. Administrator Options
Assigning Products
Assigning Clients
Defining Installation Options
Defining Conflict Resolution Installation Options
Using Oracle Client Software Agent
Understanding OCSM Files
Distributing Software with OCSM
Systems Management Server
Oracle8 SMS Support
Distributing Oracle Software with SMS

G Troubleshooting

Database Connection Issues
Operating System Permission Issues
Using Oracle Trace
Contacting Oracle Worldwide Customer Support
How to Contact Oracle Worldwide Customer Support
Before You Call for Assistance



Copyright © 1997 Oracle Corporation.
All Rights Reserved.