McGraw Hill - OCP Oracle Database 10g New Features For Administrators Exam Guide.pdf - Oracle 10g - adszy1

Installation, Server

Configuration, and

Database Upgrades

CERTIFICATION OBJECTIVES

1.01

Installation New Features Support

1.06

Using New Utility to Perform

Pre-Upgrade Validation Checks

1.02

Performance Enhancements

to the Installation Processs

1.07

Using the Simplified Upgrade Process

1.03

Simplified Instance Configuration

1.08

Starting Up the Database Using

a New Mode When Upgrading

1.04

Viewing Database Feature Usage Statistics

✓

Two-Minute Drill

Q&A Self Test

1.05

Supported Upgrade Paths to Oracle

Database 10 g

Chapter 1: Installation, Server Configuration, and Database Upgrades

O racle Corporation has ambitiously positioned Oracle Database 10 g as a

The database server I use in this book is the Oracle Database 10 g Enterprise

Edition Release 10.1.0.2.0. I use both a UNIX platform and a Windows platform

for most of the examples in this book. You can probably replicate several examples

in this book using a different version of the Oracle software, but you can get the

Enterprise Edition software free from Oracle, so there isn’t any reason for not using

that version. Practicing using the new features is essential not only for passing the

test, but also for learning the features well enough to implement them in your

databases. So, if you haven’t already downloaded the software, please do so now

(from www.oracle.com).

The g in Oracle 10 g , stands for grid computing . Grid computing is all the rage now,

with IBM promoting “on-demand” computing, and Sun, HP, and other companies

talking about their own visions of grid computing. Regardless of what a particular

company might name it, grid computing really means treating computing as a utility,

somewhat like an electrical company’s power grid. When you want more or less

computing power, the grid will supply it to you automatically in a flexible manner.

The following three attributes lie at the heart of grid computing:

■

Virtualization between the layers of the computing stack and the users

■

Dynamic provisioning of work among the available resources, based on

changing needs

■

Pooling of resources to maximize availability and utilization

Several new manageability-enhancing features, along with revamped older features,

promise Oracle database administrators (DBAs) a very new way of managing their

powerful Oracle databases. The main goals of this new approach are to reduce

administrative effort and capital expenditures, while simultaneously keeping failure

costs to a minimum. The changes start, as they should, right with the installation of

the database software itself.

This first chapter discusses in detail features related to installation, configuration,

and upgrading.

sophisticated self-managing database. Note that you don’t refer to the new

10 g database as Oracle10 g , as in Oracle9 i . The correct name of our new

database is Oracle Database 10 g . Throughout this text, I refer to the database as Oracle

Database 10 g , although I may occasionally refer to it as simply Oracle 10 g , for convenience.

Installation New Features Support

Please refer to the Oracle Database 10 g documentation for complete details

on a given feature. This book is intended to provide the information you

need for upgrading your Oracle OCP certification from Oracle9 i to Oracle

Database 10 g . (The complete name of the test required for upgrading your

certification is Oracle Database 10 g : New Features for Administrators (Exam

#1Z0-040) Therefore, unless the feature is completely new to Oracle 10 g ,

I don’t attempt to fully explain it in this book.

Let’s start our review of the new Oracle 10 g installation features by looking at

some interesting changes in the installation process.

CERTIFICATION OBJECTIVE 1.01

Installation New Features Support

While the essential database software installation is through the familiar Oracle

Universal Installer, there are several appealing changes in the Oracle Database 10 g

installation process itself. The entire installation process is simpler now, and the

typical server installation takes less than a half an hour to complete. Client installations

can now be done in less than a minute, and they require less than 70MB of disk space.

The following are some new features related to the Oracle Enterprise Server

software installation process:

■

Database management choices

■

Automatic pre-install checks

■

New file storage options

■

Backup and recovery options

■

Database user password specification

■

Cluster Ready Services

■

Enterprise Configuration Management Tool

■

Oracle MetaLink integration

■

Oracle software cloning

■

Database cloning

Chapter 1: Installation, Server Configuration, and Database Upgrades

Let’s look at each of these installation new features, starting with enhancements

in database management choices.

Database Management Choices

As part of the Oracle Database 10 g software installation, Oracle offers you the choice

to create a “starter” database, as was the case in previous versions. However, now, you

have more management choices to make when you decide to let Oracle create the

starter database.

In Oracle9 i , you could create the Oracle Enterprise Manager (OEM) central

management setup (including database management, as well as host and

network management) as part of the normal database installation. In Oracle 10 g ,

if you wish to configure a centralized (or grid-based) OEM capability, you must

configure this feature separately.

In Oracle9 i , you needed to choose between an OEM console in the stand-alone

mode or log in to the Oracle Management Server. In the stand-alone mode, you

could manage only your databases. In order to manage HTTP servers, events, and

jobs, you needed to use the Oracle Management Server. You can now use the OEM

in two fundamentally different ways:

■

You can manage your databases locally using the OEM Database Control ,

which is part of the Oracle 10 g server software.

■

You can manage your databases centrally , through the OEM Grid Control ,

which is available on separate CDs.

The OEM Database Control comes with the Oracle Database 10 g

server software.

The OEM Database Control is a web-based application that you can use to manage

a single Oracle 10 g database. The Database Control simply lets you monitor and

manage a single database. You can access the Database Control by using a web

browser; no configuration is necessary to start using the Database Control. Oracle

automatically installs the OEM Database Control in the same Oracle Home as your

Oracle database.

Alternatively, you can install the OEM Grid Control tool, which lets you

monitor and manage several databases and servers at once. In order to use the OEM

Grid Control, you need to configure and start the Oracle Management Agent on

each of the nodes you wish to monitor.

Installation New Features Support

If you are managing a single database, the simple stand-alone OEM Database

Control is adequate. On the other hand, if you are in charge of several databases

on several hosts, you’ll need to install and use the OEM Grid Control. The

Grid Control includes the Oracle Management Agent, Oracle Management

Service, the Oracle Management Repository, and the Grid Control console.

It is through the console that you perform all monitoring, configuration, and

management tasks for not only databases, but also for the various hosts

and other services.

In Oracle9 i databases, there was only one kind of OEM, and you had the

option of configuring it with or without Management Agents and the Management

Repository. Now, Oracle is making a formal distinction between a local and centrally

managed OEM.

The OEM Database Control runs with the help of a HTTP server, and you use a

regular Internet browser to see the OEM interface. The default URL for the OEM

Database Control is as follows:

http://host.domain:5500/em/

In order to manage your database, log in as the user SYS and connect as SYSDBA.

The default port number for the OEM is 5500. You can determine the correct

port number for your database by looking at the portlist.ini file, which you

can find in the $ORACLE_HOME/install directory.

In order to run the OEM Database Control, you must first start the database

from which the Database Control is running. Let’s say your database name

is nina. You then need to make sure that the service (on a Windows server)

OracleServiceDBConsoleNina is running, before you try to access the OEM Database

Control interface through your web browser.

When you choose local management using the Database Control, the installer

also gives you the choice of configuring default backup strategies administered by

the Recovery Manager (RMAN). In addition, choosing the Database Control also

enables you to configure the sending of automatic e-mail alerts to warn you about

space concerns and other problems.

The Apache HTTP Server isn’t a part of the Oracle Database 10 g software,

unlike in the previous versions. Oracle continues to provide the Apache HTTP

Server, but as part of the supplemental product CD-ROM.

McGraw Hill - OCP Oracle Database 10g New Features For Administrators Exam Guide.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: