What is Cluster?
Cluster consists of two or more independent nodes. Cluster software hides structure of nodes. Due to cluster software all nodes are acting as single server.
What is Real Application Cluster?
It is component of Oracle for managing two or more instances on different node which are sharing single database. RAC software manages data access and makes consistent image of database.
What is Node?
Each node contains separate CPU and memory and self contained server in cluster. It contains single instance of RAC database.
What is Interconnect?
Using cluster interconnect each node communicates messages to other nodes. In short using interconnect all nodes are talking to each other. Interconnect transfers all messages of database from all connected nodes.
What is Shared Disk?
Oracle real application cluster database must be accessible from all connected nodes (Instances). Due to this database must be on shared disk which is accessed by all nodes. RAW device file system available in Unix/Linux and unformatted disk partition available in Windows for making shared disk.
What is Cluster Manager?
Cluster Manager manages and monitoring connected nodes. It regulates messages and activity of nodes in cluster.
What is Oracle Cluster file system (OCFS)?
OCFS is shared file system and made by Oracle itself for Oracle Real Application Cluster. It allows to accessing single Oracle Home for all nodes. Without using OCFS we should need to install separate Oracle Home on each nodes in Cluster.
What is Oracle Clusterware?
In previous version of oracle (Oracle 9i) it is called as Cluster Manager. Oracle clusterware monitors all components like instances and listeners. There are two components in Oracle clusterware, those are Voting Disk and OCR.
What is Voting Disk?
Voting Disk is shared disk component. Information of shared storage & nodes reside in Voting Disk. It is accessed by the all nodes during cluster operations. Every node pings Voting Disk, if will be failing to ping cluster immediate serves as communication failure & the node is evicted from cluster.
What is OCR?
OCR means Oracle Cluster Registry. It stores cluster configuration information. It is also shared disk component. It must be accessed by all nodes in cluster environment.It also keeps information of Which database instance run on which nodes and which service runs on which database.The daemon OCSSd manages the configuration info in OCR and maintains the changes to cluster in the registry.
Updates
- Steps to import data from 11g to 9i database
- AWR vs ADDM vs ASH
- Advantages and Disadvantages of Datapump
- Oracle Database 12c New Features for Developers
- Unix for the DBA
- Oracle library cache tuning – A Real Case Study.
- Oracle Performance Tuning – AWR Queries
- Oracle DBA Silver Bullets – Performance Queries
- Script to find out Backups taken and their duration in last 24 hours
- Script to Compile all invalid Materialized Views in a schema
- Script to find out if any new table/procedure added in the schema in past 24 hours
- Find duplicate columns from all tables in a schema
- Difference b/w Oracle Restore and Recovery
- Enabling/Disabling Archivelog mode in Oracle
- Where is my Alert log file?
- Script to find out if Archlog Files backed up in last 24 Hours
- Keeping PL/SQL in Oracle Memory
- Oracle RMAN: Industry Standards & best practices for Stable/Reliable backups
- Oracle Data Guard : Synchronous vs. Asynchronous Redo Transport
- Compare Structures of Two Tables in Oracle
- Oracle: Query to find the 10 Largest Objects in DB
- Oracle Locks
- Script for Hidden Parameters
- Oracle RAC Basic
- Oracle: Query to find the 10 Largest Objects in DB
- Oracle: DBMS_STATS Gather Statistics of Schema, Tables, Indexes
- Create External Table from CSV File
- How to find long running query in oracle?
- Node evictions in RAC environment
- Recovering drop table using RMAN
- Writing DBA scripts :
- Oracle ASM Queries for DBA
- Reference summary of asmcmd commands
- RAW Device and ASM for Oracle Database Creation on Linux & Solaris Platform
- Copying Files and Directories commands for DBAs:
- Oracle Database Health check scripts
- Using ORA_ROWSCN and SCN_TO_TIMESTAMP to find the last updated date or timestamp of a record.
- How We Resolved the Account Locked (Timed) issue?
- Download Oracle 11g New Features PDF.
- Installing & Configuring Oracle ASM on Linux – Red Hat Enterprise Linux 4.0
- Creating a Recovery Catalog – RMAN in Oracle 10g
- Clone of a database on the same Host i.e. Server (Linux RHEL -4)
- Cloning and Refreshing an Oracle Database
- Group and User Creation in Solairs.
- How to check the Physical RAM and Swap Space in Unix/Linux Systems.
- Do not invoke SQL*Plus with a password On UNIX and Linux platforms.
- Setting an Oracle Environment variable – ORACLE_HOME
- How important is having Unix/Linux OS Knowledge for Oracle DBAs?
- Upgrade Oracle Database from 9.2.0.1 to 9.2.0.7 on Soalris 10 (Sun Sparc)
- Upgrading Oracle Database Server 10g Release 10.2.0.1 to Oracle Database 10g Release 10.2.0.3 on Linux/Fedora core 6
- Changing an Oracle Database Name in Oracle 10g
- All about the STATSPACK (Statistics Packages) in Oracle 8i, 9i & 10g
- How to perform a full database export using original export/import utility?
- Here are the simple steps to migrate the default Database Character Set:
- CSSCAN Utility and CSALTER Script:
- Background processes in RAC
- New features in Oracle 9i/10g/11g RAC
0 comments:
Post a Comment