||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 3 - High
Performance and Highly Available
The Active/Passive architecture is the most
widely used. Unfortunately, this option is usually capital intensive
and an expensive option. For simplicity and manageability reasons
many administrators prefer to implement this way. Active/Active
looks attractive and is a more cost-benefit solution as the backup
server is put to use. However, it can result in performance problems
when both the database services (or applications) failover to single
node. As the surviving node picks up the load from the failed node,
performance issues may arise.
Oracle Database Service in HA Cluster
The Oracle database is a widely used database
system. Large numbers of critical applications and business
operations depend on the availability of the database. Most of the
cluster products provide agents to support database fail over
The implementation of Oracle Database service
with fail over in a HA cluster has the following general features.
A single instance of Oracle runs on one of the
nodes in the cluster. The Oracle instance and listener has
dependencies on other resources such as file systems, mount points
and IP address. etc.
It has exclusive access to the set of database
disk groups on a storage array that is shared among the nodes.
Optionally, an Active / Active architecture of
oracle databases can be established. One node (Node1) acts as the
primary node to an Oracle instance (db1) and another node acts as a
secondary node (Node2) for fail over purpose. At the same time, the
secondary node (node2) acts as primary for another instance (db2)
and the primary node act as the backup/secondary node.
For more information,
see the book
Grid and Real Application Clusters 30% off if you
buy it directly from Rampant TechPress .
Written by top Oracle
experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
Oracle Consulting Services
Burleson Oracle Consulting offers Senior Oracle consultants which are available
for all areas of Oracle support. Common Oracle consulting support
activities include short-term Oracle tuning, Oracle database troubleshooting,
Oracle9i and Oracle10g migration,
Oracle9iAS App Server
consulting, Oracle design reviews and
Oracle requirements evaluation support. Oracle support and Oracle consulting
services are priced by the hour, so you only pay for what you need. These
one-time Oracle consulting services commonly include:
Answering questions from your Oracle DBA technical staff
Repairing down production Oracle database systems
One-time Oracle tuning evaluation
Guru support for your Oracle DBA
Installation of Oracle application packages
For more information, please visit