endpoints_listener.ora is updated with loopback (127.0.0.1) instead of public IP for local listener (Doc ID 2270968.1)

Last updated on JUNE 11, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Solaris on SPARC (64-bit)

Symptoms

1. lsnrctl status from DB home (No role separation)

lsnrctl status
LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 13-JUN-2017 15:40:44

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
oracle@saturn-1 /oracle/db/product/12.1.0 $

2. lsnrctl status from GI home

lsnrctl status

LSNRCTL for Solaris: Version 12.1.0.2.0 - Production on 27-MAY-2017 18:20:41

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 12.1.0.2.0 - Production
Start Date 17-MAY-2017 15:04:47
Uptime 10 days 3 hr. 15 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/gi/product/12.1.0/network/admin/listener.ora
Listener Log File /oracle/db/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.01)(PORT=1521)))                            <<<<<< loopback address instead of public IP
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.21.6.36)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=node1)(PORT=5500))(Security=(my_wallet_directory=/oracle/db/product/12.1.0/admin/asmc/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "asmc" has 1 instance(s).
Instance "asmc2", status READY, has 1 handler(s) for this service...
Service "asmcXDB" has 1 instance(s).
Instance "asmc2", status READY, has 1 handler(s) for this service...
The command completed successfully
root@node1:~#

3. endpoints_listener.ora

LISTENER_NODE1=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)                 <<<<<< loopback address is updated by agent instead of public IP
(IP=FIRST))))
# line added by Agent

Changes

 None

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