My Oracle Support Banner

12c GI: agent might override the LISTENER_NETWORKS parameter in the spfile (Doc ID 1964100.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Starting from 12c, clusteware agent automatically populates the LISTENER_NETWORKS parameter during the instance startup, if this parameter is not set in the spfile. In some cases, customers can see agent overrides the value set in the database spfile, during the startup, which can cause the instance to be registered with the listener on the unintended network.

We can see from the below agent log file entries that, it detect the spfile entries for LISTENER_NETWORKS, but decided to override it with the endpoint values from the listener running on a different network.

2015-01-07 18:30:26.870256 : USRTHRD:635365696: {4:44777:11615} Value of REMOTE_LISTENER is exa01scan01:1955
2015-01-07 18:30:26.873416 : USRTHRD:635365696: {4:44777:11615} Value of LISTENER_NETWORKS is (( NAME=net1)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XXX.XX)(PORT=1521))))) 

2015-01-07 18:30:26.873462 : USRTHRD:635365696: {4:44777:11615} LsnrAgent::generateEndPoints entry {lsnrResName:ora.LISTENER2.lsnr endpAttr: type:2
2015-01-07 18:30:26.873504 : USRTHRD:635365696: {4:44777:11615} Listener Resources: = ora.LISTENER2.lsnr

2015-01-07 18:30:26.889395 : USRTHRD:635365696: {4:44777:11615} Network Resources: = ora.net2.network

2015-01-07 18:30:26.909740 : USRTHRD:635365696: {4:44777:11615} LsnrAgent::generateEndPoints hostIP:10.100.110.10 hostIPV6:nil
2015-01-07 18:30:26.927485 : USRTHRD:635365696: {4:44777:11615} CrsCmd::ClscrsCmdData::stat attribute ENDPOINTS@SERVERNAME(exadb01) not found
2015-01-07 18:30:26.951006 : USRTHRD:635365696: {4:44777:11615} LsnrAgent::generateEndPoints}

2015-01-07 18:30:26.951025 : USRTHRD:635365696: {4:44777:11615} Endp=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XXX.XXX)(PORT=1522)) 

2015-01-07 18:30:26.951050 : USRTHRD:635365696: {4:44777:11615} sqlStmt = ALTER SYSTEM SET LISTENER_NETWORKS='(( NAME=net2)(LOCAL_LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XXX.XX )(PORT=1522)))))' SCOPE=MEMORY SID='racdb1' /* db agent *//* {4:44777:11615} */ 

 

Changes

Upgrade the GI to 12c

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
Changes
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.