This document describes the tasks to install Oracle Database
10g Standard Edition on a Windows two-node cluster, using
Real Application Clusters (RAC) and Automated Storage
Management (ASM). This install also builds a general purpose
starter database with the Sample Schemas included and with
automatic disk backup enabled.
This section describes the RAC documentation set. The platform-specific Oracle
Database 10g CD contains a copy of this book, the Oracle Real Application Clusters
Installation and Configuration Guide in both HTML and PDF formats. This book contains
the pre-installation, installation, and post-installation information for all UNIX- and
Windows-based platforms on which RAC operates.
This section describes the RAC documentation set. This book, the Oracle Real
Application Clusters Deployment and Performance Guide, highlights the main deployment
topics for RAC by briefly describing Cluster Ready Services (CRS), storage, database
creation, and services deployment in RAC. Design and deployment topics in this book
describe service topologies and workload management in RAC.
The Oracle Real Application Clusters Administrator's Guide also describes how to use the
Server Control (SRVCTL) utility to start and stop the database and instances, manage
configuration information, and to delete or move instances and services. You can also
use the appendix to resolve various RAC tools error and informational messages. A
troubleshooting section describes how to interpret the content of various RAC-specific
Running today’s non-critical business applications in virtualized environments has
shown to be efficient and cost saving. More sophisticated or highly available
applications on the other hand were most likely incompatible with commonly used
software based virtualization solutions.
The availability of Oracle VM overcomes this obstacle.
Oracle Real Application Clusters (RAC) enables multiple instances that are linked by
an interconnect to share access to an Oracle database. This enables RAC to provide
high availability, scalability, and redundancy during failures. RAC provides scalability
without requiring application code changes.This book is intended for chief technology officers, information technology architects,
database administrators, system administrators, network administrators, and
application administrators who perform the following tasks:...
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.
The demand for QoS to ensure the quality of real-time services must take into account not only
network parameters are static but dynamic. Therefore, the QoS measures need
introduced in the network to the quality of real-time services can be ensured. the
The most common construction of a routing problem in an optimal distribution network data
based on a multicommodity flow optimization whereby a separate objective function
minimized for all kinds of restricted flow multicommodity flow.
Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle's industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides. ...
Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is packed full of features
and has a fresh approach to information presentation, system management and
security. This book will introduce the reader to those features, providing a step-by-step
guide to building a complete system from scratch. The aim of the book is to equip a
developer or analyst with a good basic understanding of what the product contains,
how to install and configure it, and how to create effective business intelligence....
Cài Oracle cần như sau:
1. Tạo 2 Groups: đặc tên là oinstall và dba
2. Tạo 1 User account tên là: oracle
(note: Đúng ra đặt là Tí Tèo gì củng được, nhưng conventional, thấy thiên hạ cài Oracle hay đặt là vậy.)
Login as root, run: �
# groupadd oinstall
# groupadd dba
# useradd -m -g oinstall -G dba oracle
Tạo password cho user: oracle
# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
Oracle Real Application Clusters (RAC) harnesses the processing power of multiple,
interconnected servers on a cluster; allows access to a single database from multiple servers on a
cluster, insulating both applications and database users from server failures, while providing
performance that scales out on-demand at low cost; and is a vital component of grid computing
that allows multiple servers to access a single database at one time. Oracle Database 11g also
includes Automated Storage Management (ASM) and Oracle Clusterware.
Oracle Real Application Clusters (RAC)1 is an option to the award-winning
Oracle Database Enterprise Edition. Oracle RAC is a cluster database with a shared
cache architecture that overcomes the limitations of traditional shared-nothing and
shared-disk approaches to provide highly scalable and available database solutions
for all your business applications. Oracle RAC is a key component of Oracle’s
enterprise grid architecture and cloud foundation.
With Oracle Real Application Clusters (as with any other Oracle database) the
Oracle Instance (the processes and memory structures allocated on a server to
allow access to the data) is de-coupled from the Oracle Database (the physical
structures residing on the storage, which actually hold the data. These structures are
commonly known as ‘datafiles’).
However, a clustered database (using more than one instance) differs from a single
instance database in a way that the database can be accessed by multiple instances
With a shared server architecture, a small pool of server processes can serve a large
number of clients. This reduces the server’s memory requirements. Connection
pooling and session multiplexing features are enabled through shared server.
Connection pooling enables the database server to time out protocol connections and
to use those connections to service an active session.
Session multiplexing, available with Oracle Connection Manager, enables multiple
client sessions to funnel through a single protocol connection. ...
Real Application Clusters (RAC) comprises several Oracle instances running on
multiple clustered computers, which communicate with each other by means of a
so-called interconnect. RAC uses cluster software to access a shared database that
resides on shared disk. RAC combines the processing power of these multiple
interconnected computers to provide system redundancy, near linear scalability, and
high availability. RAC also offers significant advantages for both OLTP and data
warehouse systems and all systems and applications can efficiently exploit clustered
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.
When additional resources are required, additional nodes and instances can easily
be added to the cluster with no downtime. Once a new instance has been started,
applications using services can immediately take advantage of it with no changes to
the application or application server.
Oracle Real Application Clusters is an extension to the Oracle Database and
therefore benefits from the manageability, reliability, and security features built into
the Oracle Database.
You must load your data warehouse regularly so that it can serve its purpose of
facilitating business analysis. To do this, data from one or more operational systems
must be extracted and copied into the warehouse. The process of extracting data from
source systems and bringing it into the data warehouse is commonly called ETL,
which stands for extraction, transformation, and loading.
A materialized view provides access to table data by storing the results of a query in a
separate schema object.
MTMF combines the best parts of the Linear Spectral Mixing model and the statistical
Matched Filter model while avoiding the drawbacks of each parent method (Boardman,
1998). It is a useful Matched Filter method without knowing all the possible endmembers in
a landscape especially in case of subtle, sub-pixel occurrences. Firstly, pixel spectra and
endmember spectra require a minimum noise fraction (MNF) (Green et al., 1988, Boardman,
1993) transformation. MNF reduces and separates an image into its most dimensional and