11gR2 and Later Releases: SCAN: DB Fails to Start: ORA-00119, ORA-00132 Incorrect Value for REMOTE_LISTENER
(Doc ID 1254929.1)
Last updated on DECEMBER 19, 2023
Applies to:
Oracle Net Services - Version 11.2.0.1 to 18.3.0.0.0 [Release 11.2 to 18.1]Information in this document applies to any platform.
Symptoms
1. Unable to start database due to REMOTE_LISTENER parameter error.
SQL> startup nomount
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'scan-listener:1521'
2. The REMOTE_LISTENER setting is correct for the scan listener reference.
3. Changing the REMOTE_LISTENER setting to use an entry in the tnsnames.ora file will allow the database to
start.
It's important to note that this issue can arise while running DBCA to start the listener also.
Changes
This is likely a new implementation of SCAN/RAC.
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 |