Ok, so why do all that?
It’s a primary on a Data Guard pair – the DG replication is played across a private segment (named ggt1-rep.localdomain) on the normal 1521 port. And a more public segment (named ggt1.localdomain) allows general sqlnet connections on port 1526.
Here is the listener.ora and then a listener status:
SID_LIST_LISTENER_GGTDG
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ggtdg_DGMGRL)
(ORACLE_HOME = /oracle/obase/ggtdg/12102)
(SID_NAME = ggtdg)
)
)
LISTENER_GGTDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ggt1-rep.localdomain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ggt1.localdomain)(PORT = 1526))
)
ADR_BASE_LISTENER_GGTDG = /oracle/odump/common/ggtdg
[oradb@ghddbaggt1lds admin]$ lsnrctl status listener_ggtdg
LSNRCTL for Linux: Version 12.1.0.2.0 – Production on 26-OCT-2017 15:33:31
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ggt1-rep.localdomain)(PORT=1521)))
STATUS of the LISTENER
————————
Alias listener_ggtdg
Version TNSLSNR for Linux: Version 12.1.0.2.0 – Production
Start Date 26-OCT-2017 15:06:44
Uptime 0 days 0 hr. 26 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/obase/ggtdg/12102/network/admin/listener.ora
Listener Log File /oracle/obase/diag/tnslsnr/ghddbaggt1lds/listener_ggtdg/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.226.2.51)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.222.160.218)(PORT=1526)))
Services Summary…
Service “GGTDG” has 1 instance(s).
Instance “ggtdg”, status READY, has 1 handler(s) for this service…
Service “ggtdgXDB” has 1 instance(s).
Instance “ggtdg”, status READY, has 1 handler(s) for this service…
The command completed successfully