Exadata Database Machine X2-2 Qtr Rack
 

PLA-Support>Database Technology>Engineered Systems>Oracle Exadata>DB: Exadata_EST
 
.Old GCS Categories>ST>Server>Engineered Systems>Exadata>Installation
 

In this Document

Symptoms

Cause

Solution

Applies to:

Symptoms

SDP Listener is in INTERMEDIATE Status on one exadata database node:

ora.LISTENER_IB.lsnr
               ONLINE  ONLINE            exa101
               ONLINE  INTERMEDIATE exa102                   Not All Endpoints Registered

listener_ib.log shows the following error on node exa102:

Error listening on: (ADDRESS=(PROTOCOL=SDP)(HOST=172.16.31.26)(PORT=1522))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.31.26)(PORT=1522)))
26-JUN-2012 16:30:02 * service_register * LsnrAgt * 12560
TNS-12560: TNS:protocol adapter error
 TNS-00530: Protocol adapter error
  Linux Error: 97: Address family not supported by protocol

Cause

 SDP module is enabled on customer systems who have an Exalogic and Exadata systems. In this case, the SDP module was not correctly enabled and loaded on node exa102:

[root@exa102 bin]# lsmod | grep ib
ib_srp                 67400  0   

But on first node it's loaded:

[root@exa101 trace]# lsmod | grep ib
ib_sdp                192732  6 

Solution

 Correct /etc/infiniband/openib.conf on exa102 and reboot it:

# Load SDP module
SDP_LOAD=yes
# Load SRP module
SRP_LOAD=no

SRP_LOAD was incorrectly set to yes instead of SDP_LOAD before ! Above is correct setting.

This solution has no attachment