Database Startup Fails with Errors ORA-00141 And ORA-00132 and Warning: "Invalid value for listener related parameter MIXED LISTENER"

(Doc ID 2296927.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Net Services - Version and later
Information in this document applies to any platform.


Unable to start up database. RDBMS version 12.2 throwing the followinig error when attempt to start:

WARNING: Invalid value for listener related parameter MIXED LISTENER
ORA-00141: all addresses specified for parameter LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name 'LISTENER_TNS'   <=This points to an entry in the local TNSNAMES.ORA


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms