In Oracle : Oracle RAC Architecture II

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle RAC (Real Application Cluster)

-> Oracle RAC Architecture

 

 Oracle RAC Architecture (Q and A)

 

 

 

  1. What is VIP IP used for?

  2. Why we need to have configured SSH or RSH on the RAC nodes?

  3. Is the SSH, RSH needed for normal RAC operations?

  4. Do we have to have Oracle RDBMS on all nodes?

  5. What are the restrictions on the SID with a RAC database? Is it limited to 5 characters?

  6. Does Real Application Clusters support heterogeneous platforms?

  7. Are there any issues for the interconnect when sharing the same switch as the public network by using VLAN to separate the network?

  8. What is the Load Balancing Advisory?

  9. How many nodes are supported in a RAC Database?

10. What is the Cluster Verification Utiltiy (cluvfy)?
11. What versions of the database can I use the cluster verification utility (cluvfy) with?
12. If I am using Vendor Clusterware such as Veritas, IBM, Sun or HP, do I still need Oracle Clusterware to run Oracle RAC10g?
13. Is RAC on VMWare supported?
14. What is hangcheck timer used for ?
15. Is the hangcheck timer still needed with Oracle RAC 10g?

 


16. What files can I put on Linux OCFS2?
17. Is it possible to use ASM for the OCR and voting disk?
18. Can I change the name of my cluster after I have created it when I am using Oracle Clusterware?
19. What the O2CB is?
20. What the OCR file is used for?
21. What the Voting Disk file is used for?

 

 

1. What is VIP IP used for?

It returns a dead connection IMMIDIATELY, when its primary node fails. Without using VIP IP, the clients have to wait around 10 minutes to receive ORA-3113: “end of file on communications channel”. However, using Transparent Application Failover (TAF) could avoid ORA-3113. 

 


2. Why we need to have configured SSH or RSH on the RAC nodes?

SSH (Secure Shell,10g+) or RSH (Remote Shell, 9i+) allows “oracle” UNIX account connecting to another RAC node and copy/ run commands as the local “oracle” UNIX account. 

 

3. Is the SSH, RSH needed for normal RAC operations?

No. SSH or RSH are needed only for RAC, patch set installation and clustered database creation. 

 

4. Do we have to have Oracle RDBMS on all nodes?

Each node of a cluster that is being used for a clustered database will typically have the RDBMS and RAC software loaded on it, but not actual data files (these need to be available via shared disk).

 


5. What are the restrictions on the SID with a RAC database? Is it limited to 5 characters?

The SID prefix in 10g Release 1 and prior versions was restricted to five characters by install/ config tools so that an ORACLE_SID of up to max of 5+3=8 characters can be supported in a RAC environment. The SID prefix is relaxed up to 8 characters in 10g Release 2, see bug 4024251 for more information.

 


6. Does Real Application Clusters support heterogeneous platforms?

The Real Application Clusters do not support heterogeneous platforms in the same cluster.

 


7. Are there any issues for the interconnect when sharing the same switch as the public network by using VLAN to separate the network?

RAC and Clusterware deployment best practices suggests that the interconnect (private connection) be deployed on a stand-alone, physically separate, dedicated switch. On big network the connections could be instables.

 


8. What is the Load Balancing Advisory?

 

To assist in the balancing of application workload across designated resources, Oracle Database 10g Release 2 provides the Load Balancing Advisory. This Advisory monitors the current workload activity across the cluster and for each instance where a service is active; it provides a percentage value of how much of the total workload should be sent to this instance as well as service quality flag. 

 

 

9. How many nodes are supported in a RAC Database?

 

With 10g Release 2, we support 100 nodes in a cluster using Oracle Clusterware, and 100 instances in a RAC database. Currently DBCA has a bug where it will not go beyond 63 instances. There is also a documentation bug for the max-instances parameter. With 10g Release 1 the Maximum is 63.

 


10. What is the Cluster Verification Utiltiy (cluvfy)?

 

The Cluster Verification Utility (CVU) is a validation tool that you can use to check all the important components that need to be verified at different stages of deployment in a RAC environment. 

 


11. What versions of the database can I use the cluster verification utility (cluvfy) with?

 

The cluster verification utility is release with Oracle Database 10g Release 2 but can also be used with Oracle Database 10g Release 1.

 

 

12. If I am using Vendor Clusterware such as Veritas, IBM, Sun or HP, do I still need Oracle Clusterware to run Oracle RAC 10g?

 

Yes. When ceritifed, you can use Vendor clusterware however you must still install and use Oracle Clusterware for RAC. Best Practice is to leave Oracle Clusterware to manage RAC. For details see Metalink Note 332257.1 and for Veritas SFRAC see 397460.1.

 


13. Is RAC on VMWare supported?

 

No.

 

 

14. What is hangcheck timer used for ?

 

The hangcheck timer checks regularly the health of the system. If the system hangs or stop the node will be restarted automatically. 
There are 2 key parameters for this module: 
-> hangcheck-tick: this parameter defines the period of time between checks of system health. The default value is 60 seconds; Oracle recommends setting it to 30seconds. 
-> hangcheck-margin: this defines the maximum hung delay that should be tolerated before hangcheck-timer resets the RAC node. 

 

 

15. Is the hangcheck timer still needed with Oracle RAC 10g?

 

Yes. 

 

 

16. What files can I put on Linux OCFS2?

 

For optimal performance, you should only put the following files on Linux OCFS2:
- Datafiles
- Control Files
- Redo Logs
- Archive Logs
- Shared Configuration File (OCR)
- Voting File
- SPFILE

 


17. Is it possible to use ASM for the OCR and voting disk?


No, the OCR and voting disk must be on raw or CFS (cluster file system).

 


18. Can I change the name of my cluster after I have created it when I am using Oracle Clusterware?

 

No, you must properly uninstall Oracle Clusterware and then re-install.



19. What the O2CB is?

The O2CB is the OCFS2 cluster stack. OCFS2 includes some services. These services must be started before using OCFS2 (mount/ format the file systems).

 


20. What the OCR file is used for? 

OCR is a file that manages the cluster and RAC configuration.

 


21. What the Voting Disk file is used for? 

The voting disk is nothing but a file that contains and manages information of all the node memberships.

 

 

In-Oracle.com  -> Oracle DBA -> Oracle RAC (Real Application Cluster)

-> Oracle RAC Architecture

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.