Instance Fails to Start and Throws Errors ORA-00119 & ORA-00132
Last updated on JANUARY 29, 2018
Applies to:Oracle Net Services - Version 10.2.0.1 to 220.127.116.11 [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:
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