Instance Fails to Start and Throws Errors ORA-00119 & ORA-00132

(Doc ID 359386.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Net Services - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 24-JUN-2015***


Attempting to start the database, the following errors are returned:

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name '%s'

The '%s' will normally be the listener name of the local server.

This issue often occurs following an Oracle RDBMS to 10gR2 using DBUA.


The tnsnames.ora file was moved or changed and the tns alias to which the LOCAL_LISTENER parameter points is no longer valid.


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