Database Startup Fails With ORA-00119 (Doc ID 471767.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Net Services - Version 9.2.0.8 to 12.1.0.2 [Release 9.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 6-JUL-2016***


Symptoms

During an attempt to start the database, the following errors are generated and the startup operation fails:

 

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


The same error might be thrown for the system parameter LISTENER_NETWORKS:

 See also:  <Note: 1615175.1> ORA-00119: Invalid Specification for System Parameter LISTENER_NETWORKS During Database Startup

 

Changes

If the sqlnet.ora file parameter NAMES.DEFAULT_DOMAIN has been changed recently, the change may have caused this error. 

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