 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 4 -
Real Application Cluster Architecture
Database Related Files
For all practical purposes, the external tables
act as the usual tables, however, the data is not stored with the
Oracle Data Files. External Tables are a great way to load the data
into database and do data processing.
There is no restriction as to where the
external table data file has to locate. In a RAC database system, it
can be located on local file systems or on a cluster file systems.
For the sake of concurrent access, it becomes more meaningful to
keep the external table file on a shared storage or cluster file
system. For the transparent access to the external table, as any of
the instance in the RAC database should be able to read/write to the
operating system level (ASCII). This is possible only if the
external table file is located on a clustered file system.
Oracle Cluster
Registry (OCR)
The OCR contains cluster and database
configuration information for RAC and Cluster Ready Services (CRS)
such as the cluster node list, and cluster database instances to
node mapping, and CRS application resource profiles.
The OCR is a shared file located in a cluster
file system. When you are not using Cluster File System, OCR file
can be located on a shared raw device in UNIX-based systems, or a
shared logical partition in Windows environments. During the
installation of Cluster Ready Services software, The Oracle
Universal Installer (OUI) automatically initializes the OCR file by
executing the srvconfig -init command.
The above text is
an excerpt from:
Oracle 10g Grid & Real Application
Clusters
Oracle 10g
Grid
Computing with RAC
ISBN 0-9744355-4-6
by Mike Ault, Madhu Tumma
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
www.dba-oracle.com
or email
info@remote-dba.net.
|
