Oracle Enterprise Manager (hereafter referred to as Enterprise Manager) is the Oracle
integrated management solution for managing the complete Oracle environment. All
services within your enterprise, including hosts, databases, listeners, application
servers, HTTP Servers, and Web applications, are easily managed as one cohesive unit.
This chapter acknowledges the challenges you face as a database administrator and
states how Enterprise Manager can help you meet these challenges.
Enterprise Manager is Oracle’s single, integrated solution for administering and
monitoring targets that are based on the Oracle technology stack. See "Certified
Enterprise Manager Targets" for a list of Oracle targets and components that Enterprise
Manager can manage. This guide is written for Oracle and system administrators who want to install and
configure Oracle Enterprise Manager. You should already be familiar with Oracle and
the administrative tasks you want to perform.
Oracle Enterprise Manager Grid Control 11gR1: Business Service Management
A hands-on guide to modeling and managing business services using Oracle Enterprise Manager 11gR1
Ashwin Kumar Karkala Govinda Raj Sambamurthy professional pertise distilled
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
This is the first book dedicated solely to the subject of implementing Oracle Enterprise
Manager 10g Grid Control. It was only a matter of time before such a book was published.
With the first release (10.1) of Grid Control roughly seven years ago, Oracle ushered in a true
system management product. The latest release (10.2) of the product is enjoying large-scale
adoption by companies looking to centrally manage their complete IT infrastructure—not just
their Oracle systems, but non-Oracle ones as well....
Oracle Enterprise Manager 10g Grid Control Implementation Guide
and many other types of targets as well. It is best practice to run either Grid Control or Database Control, but not both, although you can run both concurrently.
Grid Control vs. AS Control
How is Grid Control different from Application Server (AS) Control? In short, as just one of many target types it monitors, Grid Control monitors the Oracle Application Server, whereas AS Control administers the Oracle Application Server.
In a complex enterprise computing environment, the ability to centrally monitor and manage key system components can provide many benefits:
greater operational efficiency, faster issue resolution, higher availability to meet service level agreement (SLA) requirements, more efficient server
auditing, and improved planning, among others. Oracle Enterprise Manager delivers benefits like these by centrally monitoring and managing the
health of an organization’s complete Oracle systems.
Recovery Manager Features
Recovery Manager (RMAN) is an Oracle utility that you use to manage the backup, restore, and recovery operations on Oracle databases. RMAN has a powerful command language that is independent of the operating system.
Recovery Manager has a command-line interface. Oracle Enterprise Manager also provides a graphical user interface for the Recovery Manager. Recovery Manager can be used on databases of Oracle8 or later releases.
RMAN provides several features not available when you make user-managed backups with operating system commands.
On occasion you will need to perform some tasks using SQL*Plus and/or the operating system command line. In Practice 2, you will start an SQL*Plus session. Continue to keep the SQL*Plus session open to accomplish those tasks done in SQL*Plus. When performing tasks that require the operating system command line, an [ ! ] will be used from the SQL*Plus command line to get you out of SQL*Plus and into the operating system command line mode. Once you have completed your work on the operating system command line you can return to the SQL*Plus command line...
1. Introduction to Oracle for Linux – Oracle Enterprise Linux
2. Installasi Oracle 10g / 11 g for Linux
3. Membuat Database
4. Mengunakan Oracle Enterprice Manager
5. Konfigurasi Network Environment
6. Manajemen Oracle Instance
7. Manajemen Database Storage
8. Administrasi Users dan Security
Oracle Database Installation Guide for Windows is intended for anyone installing an
Oracle Database on a single computer. Additional Installation Guides for Oracle
Database Client, Oracle Real Application Clusters and Cluster Ready Services (CRS),
Oracle Transparent Gateway for DRDA, Oracle Procedural Gateway for APPC, Oracle
Companion CD, and Oracle Enterprise Manager Grid Control are available on the
relevant installation media.
Whether you use this or some other DBA handbook, you will still need to refer to the Oracle database manuals frequently to get the full details of complex database operations. I can’t overemphasize the importance of mastering the fundamentals of Oracle Database 11g that are presented in the Oracle Concepts manual. Mastering this volume is critical to understanding many advanced DBA procedures.
CÁC CÔNG CỤ QUẢN TRỊ ORACLE
1.1.CÁC CÔNG CỤ QUẢN TRỊ CƠ SỞ DỮ LIỆU ORACLE
Oracle hiện tại đã cung cấp rất nhiều công cụ cho phép quản trị cơ sở dữ liệu. Có thể kể ra sau đây một số công cụ cơ bản sau: Công cụ Diễn giải
Server Manager Line Công cụ quản trị cơ sở dữ liệu Oracle theo chế độ dòng lệnh như Mode start (khởi động), shutdown (dừng) database,...
Bài giảng Cơ sở dữ liệu Oracle: Chương 3 Ngôn ngữ thủ tục PL/SQL nhằm trình bày về giới thiệu Oracle, các công cụ cơ bản trong Oracle, công cụ Enterprise Manager (EM), công cụ SQL Plus, công cụ iSQLPlus, ngôn ngữ SQL, ngôn ngữ thủ tục PL/SQL, kiến trúc quản trị Oracle.
Oracle Database Advanced Replication describes the features and functionality of
Advanced Replication. Specifically, Oracle Database Advanced Replication contains
conceptual information about Advanced Replication, as well as information about
planning your replication environment and troubleshooting replication problems.
Oracle Database Advanced Replication also contains an introduction to the Replication
Management tool in the Oracle Enterprise Manager Console.
The Oracle Net8 Administrator’s Guide contains information that describes the
features and functionality of the Oracle8 and the Oracle8 Enterprise Edition
products. Oracle8 and the Oracle8 Enterprise Edition have the same basic features.
However, several advanced features are available only with the Enterprise Edition,
and some of these are optional. For example, to use Oracle Connection Manager,
you must have the Enterprise Edition.
The Oracle Enterprise Manager Metric Reference Manual (hereafter referred to as the
Metric Reference Manual) lists all the target metrics that Enterprise Manager monitors.
This manual compiles in one place all the target metric help available online,
eliminating the need to have the Grid Control Console up and running.
Using Oracle Enterprise Manager
You can use the Recovery Wizard to restore and recover your database. On the Range Selection page you must enter a date and time to restore to a previous point. You use Instance Management or the Console to open the database after the job has completed. You can view the status of the job by selecting the Active and History page tabs in the Console’s Job window.
After completing this lesson, you should be able to do the following:
Identify key tuning components of the alert log file
Identify key tuning components of backgroundtrace files
Identify key tuning components of user trace files
Collect statistics with Oracle Enterprise Manager
Describe how Statspack collects statistics
Collect statistics with Statspack
Identify dynamic performance views useful in tuning
Describe other tools used for tuning
When failures occur, the fail over process moves processing performed by the failed
component to the backup component. This process remasters systemwide resources,
recovers partial or failed transactions, and restores the system to normal, preferably
within a matter of microseconds. The more transparent that fail over is to users, the
higher the availability of the system.
Oracle has a number of products and features that provide high availability in cases of
unplanned downtime or planned downtime.
Oracle Data Guard is the most effective solution available today to protect the core
asset of any enterprise—its data, and make it available on a 24x7 basis even in the
face of disasters and other calamities.
This guide describes Oracle Data Guard technology and concepts, and helps you
configure and implement standby databases.
This preface contains the following topics: