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 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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
2017-07-19T13:37:51.266134-04:00
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

Cause

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