The IB Listener Is Not Running when SDP module is not loaded
(Doc ID 2754686.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Exadata X5-2 Hardware - Version All Versions to All Versions [Release All Releases]Information in this document applies to any platform.
Symptoms
On : NA version, DATABASE
ACTUAL BEHAVIOR
---------------
The IB listener is not running or intermiediate
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=SDP)(HOST=xxx.yyy.zzz.aaa)(PARTIAL=YES))(ASYNC_TIMER=yes)(EXPIRE_TIME=1)(TRANSPORT_CONNECT_TIMEOUT=15))
01-FEB-2021 04:36:15 * remote_registration_address * 1176
TNS-01176: Error in loading the new parameter value
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 97: Address family not supported by protocol
Error listening on: (ADDRESS=(PROTOCOL=SDP)(RATE_LIMIT=YES)(HOST=192.168.xxx.yyy)(PORT=1525))
Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.xxx.yyy)(PORT=1525)))
01-FEB-2021 04:36:16 * service_register * LsnrAgt * 12560
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 97: Address family not supported by protocol
Customer did restart the crs on both nodes and then IB listener on both node showing as intermediate
e.g.
ora.LISTENER_IB.lsnr
ONLINE ONLINE
ONLINE INTERMEDIATE <hostname> Not All Endpoints Registered
[grid@<hostname> ~]$ srvctl config listener
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521/TCPS:2484
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
Name: LISTENER_IB
Type: Database Listener
Network: 2, Owner: oracle
Home: <CRS home>
End points: TCP:1525/SDP:1525
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
[grid@<hostname> ~]$ lsnrctl status LISTENER_IB
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 22-FEB-2021 08:48:31
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_IB)))
STATUS of the LISTENER
------------------------
Alias LISTENER_IB
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 18-FEB-2021 18:58:19
Uptime 3 days 13 hr. 50 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/12.1.0.2/grid/network/admin/listener.ora
Listener Log File /u01/app/12.1.0.2/grid/network/log/listener_ib.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_IB)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.xxx.yyy)(PORT=1525)))
Services Summary...
...
The command completed successfully
Changes
N/A
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |