Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Verify Oracle RAC Databases use RDS Protocol over InfiniBand Network

Verify Oracle RAC Databases use RDS Protocol over InfiniBand Network.

0 Comments

Verify Oracle RAC Databases use RDS Protocol over InfiniBand Network.

Priority

Alert Level

Date

Owner

Status

Engineered System

     Bug(s)        

Critical

FAIL

 

 

03/01/2017

Vern Wagman

Production

Exadata - Physical,
Exadata - User Domain,
SSC

25490898 - exachk
24958292 - exachk
Reference: 23039723

DB Version

DB Role

Engineered System Platform

Exadata Version

OS & Version

Validation Tool Version

TBD

11.2.0.2+

Primary,
Standby, ASM

X2-2(4170), X2-2, X2-8, X3-2, X3-8, X4-2, X4-8, X5-2, X5-8, X6-2, X6-8, SL6

All

Linux x86-64,
Sparc Linux

exachk 12.2.0.1.3

 

Benefit / Impact:

The RDS protocol over InfiniBand provides superior performance because it avoids additional memory buffering operations when moving data from process memory to the network interface for IO operations. 
This includes both IO operations between the Oracle instance and the storage servers, as well as instance to instance block transfers via Cache Fusion.

There is minimal impact to verify that the RDS protocol is in use. Implementing the RDS protocol over InfiniBand requires an outage to relink the Oracle software.

Risk:

If the Oracle RAC databases do not use RDS protocol over the InfiniBand network, IO operations will be sub-optimal.

Action / Repair:

To verify the RDS protocol is in use by a given Oracle instance, set the ORACLE_HOME and LD_LIBRARY_PATH variables properly for the instance and execute the following command as the oracle userid 
on each database server where the instance is running:

$ORACLE_HOME/bin/skgxpinfo

The output should be:

rds

Note: For Oracle software versions below 11.2.0.2, the skgxpinfo command is not present. For 11.2.0.1, you can copy over skgxpinfo to the proper path in your 11.2.0.1 environment from an 
available 11.2.0.2 environment and execute it against the 11.2.0.1 database home(s) using the provided command.

Note: An alternative check (regardless of Oracle software version) is to scan each instance's alert log (must contain a startup sequence!) for the following line:

 

Cluster communication is configured to use the following interface(s)for this instance 192.168.20.21 cluster interconnect IPC version:Oracle RDS/IP (generic)

 

Posted on : 3/10/2018 by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Oracle Database 19c is available via LiveSQL
Posted on :   1/21/2019

How Do I Find the Exadata Documentation, Such as Owner and User Guide
Posted on :   5/31/2018

Exachk 18.2.0_20180518 is available now…
Posted on :   5/20/2018

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved © 2013 Oracle-12c