Listener Dynamic Registration Issue: Change to LOCAL_LISTENER Setting
(Doc ID 2315830.1)
Last updated on JANUARY 16, 2025
Applies to:
Oracle Net Services - Version 10.1.0.2 to 19.5.0.0.0 [Release 10.1 to 19]Oracle Database - Enterprise Edition - Version 19.3.0.0.0 to 19.3.0.0.0 [Release 19]
Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
- Init parameter LOCAL_LISTENER points to a tnsnames.ora file entry.
In our example, the TNS alias is: LSNR_TNS
Show parameter LOCAL_LISTENER shows the setting: LISTENER
The local tnsnames.ora file contains this entry.
Changes
The IP address was changed on this server. The listener has been been restarted so that it's running on the new IP address.
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 |