Friday, October 28, 2011

How To Drop and Recreate ASM Diskgroup [ID 563048.1]

This is a very helpful Oracle note when I need to drop and recreate ASM diskgroup:
How To Drop and Recreate ASM Diskgroup [ID 563048.1]

Wednesday, October 26, 2011

How critical for RAC to use stand-alone, physically separate, dedicated switch for interconnection?

An interesting discussion found in Linkedin



How critical for RAC to use stand-alone, physically separate, dedicated switch for interconnection?

We are building our new production 5-nodes RAC DB. Network/Unix team insists that give us a shared but dedicated VLAN 10GB switch for interconnection. They believe 10GB shared switch perform better than our 1GB dedicate switch, and also save space and power etc.
How critical for RAC to use stand-alone, physically separate, dedicated switch as Oracle recommended for best practice, or has this recommendation is out of date for the new technoledges?



Gaja Krishna Vaidyanatha said:

Here are some guidelines that we recommend when dealing with this issue. It is a frequent subject of discussion at many customer sites, so we have put down standards, so that there are fewer debates on this topic...:)

Here it is:

1. A physical database server must have at least 2 physical NICs with at least 2 ports on each NIC to avoid having a SPOF on any one NIC.

2. A physical database server must have at least 2 physical HBAs with at least 2 ports on each HBA if SAN is being used for data storage.

3. If data traffic and cluster inter-node communication are combined on the same NICs, then:
a. Multiple VLANs must be created
b. VLAN tagging and Quality of Service (QoS) must both be used.
c. Cluster inter-node communication must be separated from public traffic on different VLANs.

4. Automated failover (such as Etherchannel, 802.3ad), must be used for primary/secondary failover of each NIC.

5. Independent network switches must be configured so that during failover from the primary to secondary NIC, a different network switch will also be used.

6. Network link aggregation may be used to combine network ports into a larger network channel, but this link itself must not be a SPOF. For example, if using 2 dual port NICs, then port A on NIC 1 must be aggregated to port B on the same NIC. NIC 2 must be configured to support failover of both port A and port B from NIC 1.

7. The server and networking infrastructure must be configured to allow multicast communications and large IP packets. 

delete all lines containing 'string' in vi with :g/string/d

delete all lines containing 'string' in vi with :g/string/d

Friday, October 14, 2011

Reviewed Oracle Notes on My Recent 11202 RAC Installation with ASMLib

ASM
  1. ASM 11.2 Configuration KIT (ASM 11gR2 Installation & Configuration, Deinstallation, Upgrade, ASM Job Role Separation (Standalone Only). [ID 1092213.1]
  2. How To Setup ASM on Linux Using ASMLIB Disks, Raw Devices or Block Devices? [ID 580153.1]
  3. Device Checks for ASM Fails with PRVF-5150: Path ORCL: is not a valid path [ID 1210863.1
  4. ASM Technical Best Practices [ID 265633.1]
  5. Master Note for Automatic Storage Management (ASM) [ID 1187723.1]
  6. How to Prepare Storage for ASM [ID 452924.1]
  7. How To Install ASMLIB API via the Unbreakable Linux Network [ID 461718.1]
  8. FAQ ASMLIB CONFIGURE,VERIFY, TROUBLESHOOT [ID 359266.1]
Grid/CRS/VIP
  1. Things to Consider Before Upgrading to 11.2.0.2 Grid Infrastructure [ID 1312225.1]
  2. Oracle De-install Utility - 11g R2 [ID 886184.1]
  3. How To Deinstall/Uninstall Oracle Home In 11gR2? [ID 883743.1]
  4. 11.2.0.2 Patchset Location For Grid Infrastructure And RDBMS. [ID 1223673.1]
  5. Support of Linux and Oracle Products on Linux [ID 266043.1]
  6. Grid And Database Runinstaller - Precheck Fails For Run-Level [ID 1307948.1]
  7. Things to Consider Before Upgrading to 11.2.0.2 Grid Infrastructure [ID 1312225.1]
  8. RAC: Frequently Asked Questions [ID 220970.1]
  9. Linux: PRVF-5449 : Check of Voting Disk location "ORCL:(ORCL:)" failed [ID 1267569.1]
  10. root.sh Fails as the ora.asm resource is not ONLINE or PROTL-16 Reports [ID 1259874.1]
  11. How to Proceed from Failed 11gR2 Grid Infrastructure (CRS) Installation [ID 942166.1]
  12. The listener stops or goes offline randomly due to VIP issue [ID 985170.1]
  13. VIP does not relocate back to the original node starting from 10.2.0.4 and 11.1 even after the public network problem is resolved. [ID 805969.1]
  14. Troubleshooting CRSD Start up Issue [ID 1323698.1]
  15. VIP does not Failover or Network Resource Stays Online after Disconnected Cables for Bond Public Network [ID 1276737.1]
  16. VIP Fails Over and Listener Stops After Short Public Network Hiccup [ID 1333165.1]
  17. Crs Components Are Not Starting After Server Reboot [ID 1152653.1]
  18. Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]
  19. CRS Diagnostic Data Gathering: A Summary of Common tools and their Usage [ID 783456.1]
  20. CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide [ID 330358.1]
  21. RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) [ID 810394.1]
  22. Introducing Cluster Health Monitor (IPD/OS) [ID 736752.1]

Labels: , , , ,