My Oracle Support Banner

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 SEPTEMBER 08, 2023

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.