12c: Listener REMOTE_REGISTRATION_ADDRESS is Disabled or Set to OFF After Upgrade from 11g to 12c
(Doc ID 2186687.1)
Last updated on JANUARY 18, 2025
Applies to:
Oracle Net Services - Version 12.1.0.1 and laterOracle Database - Enterprise Edition - Version 19.7.0.0.0 and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Symptoms
In this example LISTENER_SCAN2 and local LISTENER are used.
LSNRCTL> set current_listener listener
Current Listener is listener
LSNRCTL> show remote_registration_address
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
listener parameter "remote_registration_address" set to (REMOTE_REGISTRATION_ADDRESS=OFF)
The command completed successfully
LSNRCTL> set current_listener LISTENER_SCAN2
Current Listener is LISTENER_SCAN2
LSNRCTL> show remote_registration_address
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
LISTENER_SCAN2 parameter "remote_registration_address" set to (REMOTE_REGISTRATION_ADDRESS=OFF)
Changes
This is a 12c installation that was upgraded from 11gR2. (Versus a new installation of 12c)
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 |