Copyright © 2005, Oracle. All rights reserved.
Introduction
Oracle Database 10g: Administration Workshop I 1-2
Copyright © 2005, Oracle. All rights reserved.
1-2
Objectives
• After completing this course, you should be able
to do the following:
– Install, create, and administer Oracle Database 10g
Enterprise Edition
– Configure the database for an application
– Implement a backup and recovery strategy
– Employ basic monitoring procedures
• After completing this lesson, you should be able
to do the following:
– Describe course objectives
– Explain the Oracle Database 10g
architecture
Objectives
In this course, you install the Oracle Database 10g Enterprise Edition software, create a new
database, and learn how to administer the database.
You also configure the database to support an application and perform tasks such as creating
users, defining storage structures, and setting up security. This course uses a fictional
application. However, you perform all the core tasks that are necessary for a real application.
Database administration does not end after the database is configured. You also learn how to
protect your database by designing a backup and recovery strategy, and how to monitor the
database to ensure that it operates smoothly.
Oracle Database 10g: Administration Workshop I 1-3
Copyright © 2005, Oracle. All rights reserved.
1-3
Oracle Products
• Oracle databases
• Oracle Application Server
• Oracle Applications
• Oracle Collaboration Suite
• Oracle Developer Suite
• Oracle services
Oracle Products
• Oracle databases: The Oracle database is the first database that is designed for
enterprise grid computing, the most flexible and cost-effective way to manage
information and applications.
• Oracle Application Server: Oracle’s Java 2, Enterprise Edition (J2EE)–certified server
integrates everything that is needed to develop and deploy Web-based applications. The
application server deploys e-business portals, Web services, and transactional
applications, including PL/SQL, Oracle Forms, and J2EE-based applications.
• Oracle Applications: Oracle E-Business Suite is a complete set of business applications
for managing and automating processes across your organization.
• Oracle Collaboration Suite: Oracle Collaboration Suite is a single, integrated system
for all your organization’s communications data: voice, e-mail, fax, wireless, calendar
information, and files.
• Oracle Developer Suite: Oracle Developer Suite is a complete, integrated environment
that combines application development and business intelligence tools.
• Oracle services: Services such as Oracle Consulting and Oracle University provide you
with the necessary expertise for your Oracle projects. For useful links to a variety of
resources, see the appendix titled “Next Steps, Continuing Your Education.”
Oracle Database 10g: Administration Workshop I 1-4
Copyright © 2005, Oracle. All rights reserved.
1-4
Oracle Database 10g:
“g” Stands for Grid
• Low cost
• High quality of service
• Easy to manage
Storage
grid
Database
grid
Application
grid
Grid
control
Automatic
Storage
Management
Real
Application
Clusters
Oracle
Streams
Enterprise
Manager
Grid Control
Oracle Database 10g: “g” Stands for Grid
Oracle Corporation has created grid computing infrastructure software that balances all types
of workloads across servers and enables all those servers to be managed as one complete
system. Grid computing can achieve the same very high level of reliability as mainframe
computing because all components are clustered. But unlike mainframes and large UNIX
symmetric multiprocessing (SMP) servers, a grid can be built with open system technologies,
such as Intel processors and the Linux operating system, at a very low cost.
Oracle’s grid computing technology includes:
• Automatic Storage Management
• Real Application Clusters
• Oracle Streams
• Enterprise Manager Grid Control
Oracle Database 10g: Administration Workshop I 1-5
Oracle Grid Computing
Automatic Storage Management (ASM) spreads database data across all disks, creates and
maintains a storage grid, and provides the highest input/output (I/O) throughput with minimal
management costs. As disks are added or dropped, ASM redistributes the data automatically.
(There is no need for a logical volume manager to manage the file system.) Data availability
increases with optional mirroring, and you can add or drop disks online. For more information,
see the lesson titled “Managing Database Storage Structures.”
Oracle’s Real Application Clusters (RAC) runs and scales all application workloads on a
cluster of servers and offers the following features:
• Integrated clusterware: This includes functionality for cluster connectivity, messaging
and locking, cluster control, and recovery. It is available on all platforms that are
supported by Oracle Database 10g.
• Automatic workload management: Rules can be defined to automatically allocate
processing resources to each service both during normal operations and in response to
failures, and these rules can be dynamically modified to meet changing business needs.
This dynamic resource allocation within a database grid is unique to Oracle RAC.
• Automatic event notification to the mid-tier: When a cluster configuration changes,
the mid-tier can immediately adapt to instance failover or availability of a new instance.
This enables end users to continue working in the event of instance failover without the
delays typically caused by network timeouts. In the event of new instance availability,
the mid-tier can immediately start load balancing connections to that instance. Oracle
Database 10g Java Database Connectivity (JDBC) drivers have the “fast connection
failover” functionality that can be automatically enabled to handle these events.
Oracle Streams provides a unified framework for information sharing, combining message
queuing, data replication, event notification, data warehouse loading, and publish and
subscribe functionality into a single technology. Oracle Streams can keep two or more data
source copies synchronized when updates are applied at either site. It can automatically
capture database changes, propagate the changes to subscribing nodes, apply changes, and
detect and resolve data update conflicts. Oracle Streams can be used directly by applications
as a message-queuing or workflow feature, enabling communications between applications in
the grid.
Enterprise Manager Grid Control manages gridwide operations that include managing the
entire stack of software, provisioning users, cloning databases, and managing patches. It can
monitor the performance of all applications from the point of view of your end users. Grid
Control views the performance and availability of the grid infrastructure as a unified whole
rather than as isolated storage units, databases, and application servers. You can group
hardware nodes, databases, and application servers into single logical entities and manage a
group of targets as one unit.
Note: In this course, you use Enterprise Manager Database Console to manage one database
at a time.
- 1
- 2
前往页