My Oracle Support Banner

Instance startup via srvctl fails with ORA-119 and "USER (ospid:<pid>): terminating the instance due to error 119" in alert log (Doc ID 1908973.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Instance startup succeeds via sqlplus but fails via srvctl with below errors.


[oracle@node2 ~]$srvctl start instance -d rac -i rac2
PRCR-1013 : Failed to start resource ora.rac.db
PRCR-1064 : Failed to start resource ora.rac.db on node node2
CRS-5017: The resource action "ora.rac.db start" encountered the following error:
ORA-00119: invalid specification for system parameter LISTENER_NETWORKS
ORA-00137: invalid LISTENER_NETWORKS specification with NAME=network1
ORA-00138: all addresses specified for attribute LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name 'listener_net1'
ORA-00132: syntax error or unresolved network name 'listener_net2'
ORA-00132: syntax error or unresolved network name 'remote_net2'
. For details refer to "(:CLSN00107:)" in "/usr/app/11.2.0/grid/log/node1/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.rac.db' on 'node2' failed


Database alert log shows:
 


 dispatchers              = "(PROTOCOL=TCP) (SERVICE=<>)"
 remote_listener          = "rac-scan:1521"
 listener_networks        = "((NAME=network1)(LOCAL_LISTENER=listener_net1)
(REMOTE_LISTENER=<rac>-scan:1521))"
 listener_networks        = "((NAME=network2)(LOCAL_LISTENER=listener_net2)
(REMOTE_LISTENER=remote_net2))"
 audit_file_dest          = "/usr/app/oracle/admin/rac/adump"
 audit_trail              = "DB"
 db_name                  = "rac"
 open_cursors             = 300
 pga_aggregate_target     = 6493M
 diagnostic_dest          = "/usr/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
 169.254.200.44
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
USER (ospid: 13775): terminating the instance due to error 119
Instance terminated by USER, pid = 13775
Wed Mar 26 01:30:49 2014
Starting ORACLE instance (normal)

 
<GRID_HOME>/agent/crsd/oraagent_oracle/oraagent_oracle.log shows:


2014-03-26 01:30:52.064: [    AGFW][157198080] {2:11219:181} Received the reply to the message: RESOURCE_START[ora.rac.db 2 1] ID 4098:639 from the agent /usr/app/11.2.0/grid/bin/oraagent_oracle
2014-03-26 01:30:52.064: [    AGFW][157198080] {2:11219:181} Agfw Proxy Server sending the last reply to PE for message:RESOURCE_START[ora.rac.db 2 1] ID 4098:3746277
2014-03-26 01:30:52.067: [UiServer][144590592] {2:11219:181} Container [ Name: ORDER
MESSAGE:
TextMessage[CRS-5017: The resource action "ora.rac.db start" encountered the following error:
ORA-00119: invalid specification for system parameter LISTENER_NETWORKS
ORA-00137: invalid LISTENER_NETWORKS specification with NAME=network1
ORA-00138: all addresses specified for attribute LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name 'listener_net1'
ORA-00132: syntax error or unresolved network name 'listener_net2'
ORA-00132: syntax error or unresolved network name 'remote_net2'
. For details refer to "(:CLSN00107:)" in "/usr/app/11.2.0/grid/log/node1/agent/crsd/oraagent_oracle/oraagent_oracle.log".
]


The file tnsnames.ora is present in the RDBMS $ORACLE_HOME/network/admin directory, it has listener_net1, listener_net2 and remote_net2 defined and they can be resolved.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.