Chapter 2: Basic Concepts

Chapter 2: Basic Concepts

Overview

Now it is time to start using Oracle8. In this chapter we will learn how to verify that the Oracle8 server is ready to use, then look at how to create a database and which tools to use when working with the database.

Getting Started

When Oracle8 is installed, it can be configured so that when the computer is started, the Oracle database is automatically available. If at any time the Oracle database is unavailable you are likely to receive the message shown in Figure 2.1 if you are using the GUI tools, or error ORA-1034, Oracle not available on a new connection attempt.

Figure 2.1: Database Not Available

So what does all this mean? When this happens there are two simple checks to make:


	1.	The Oracle NT Services are running;


	2.	Oracle Instance has been started.

Oracle Services

A service in NT is a process that performs a specific task and when Oracle is installed it adds its own services to the ones already supplied with the operating system.

The Oracle8 server makes use of NT services which are used by many software products running on NT. For the Oracle database, there are a minimum of three NT services that must be started and there are others which we will see later in this book. For now we will only concern ourselves with the two services which control the Oracle instance and the one controlling the network.

To see which...

< Previous Excerpt Next Excerpt >

Purchase This Book

Oracle8 on Windows NT

TABLE OF CONTENTS

Chapter 2: Basic Concepts

Contact Preferences

This is embarrasing...

Customize Your GlobalSpec Experience

Select Your Free Newsletters

Industry Newsletters

Select Your Free Product Alerts

This is embarrasing...