ORA-00119: Invalid Specification for System Parameter LISTENER_NETWORKS During Database Startup

(Doc ID 1615175.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Net Services - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Goal

Can't startup a database through remote connection

 

Tnsping works fine.

[oracle@dmb1dbadm01 ~]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 16-JAN-2014 11:11:47

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL_SERV) (INSTANCE_NAME = ORCL)))

[oracle@myhost ~]$ sqlplus sys/password@ORCL as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 16 11:11:33 2014

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LISTENER_NETWORKS
ORA-00137: invalid LISTENER_NETWORKS specification with NAME=NET1
ORA-00138: all addresses specified for attribute LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name 'LOCAL_1'
ORA-00132: syntax error or unresolved network name 'REMOTE_1'
ORA-00132: syntax error or unresolved network name 'LOCAL_2'
ORA-00132: syntax error or unresolved network name 'REMOTE_2'
ORA-00132: syntax error or unresolved network name 'LOCAL_3'
ORA-00132: syntax error or unresolved network name 'REMOTE_3'
ORA-00132: syntax error or unresolved network name 'LOCAL_4'
ORA-00132: syntax error or unresolved network name 'REMOTE_4'
SQL> exit

--> All TNS alias are resolved


SQL> show parameter listener_networks;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string      ((NAME=NET1)(LOCAL_LISTENER=
                                                LOCAL_1)(REMOTE_LISTENER=REMOTE_
                                                1)), ((NAME=NET2)(LOCAL_LISTEN
                                                ER=LOCAL_2)(REMOTE_LISTENER=RE
                                                MOTE_2)), ((N)(NAME=NET3)(LOCAL
                                                _LISTENER=LOCAL_3)(REMOTE_LIS
                                                TENER=REMOTE_3)), ((NAME=NET4
                                                )(LOCAL_LISTENER=LOCAL_4)(R
                                                EMOTE_LISTENER=REMOTE_4))

 


[oracle@myhost ~]$ srvctl start database -d ORCL --> works fine


 


Solution

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