RDBMS version: 11.2.0.4
OS : Oracle Linux 6.4
DB type : Standalone
Standalone DBs in my shop have their listeners configured using DB servers' hostnames and not IPs. I would like to know the best practice for this.
ie. Which is better , using server's IP or server Host name to register the listener ?
As shown in red below, the listener is registered with the hostname in my shop.
[oracle@hewmdbv6201 ~]$ lsnrctl status LISTENER
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-AUG-2016 16:04:13
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hewmdbv6201)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 22-JUL-2016 14:27:26
Uptime 33 days 1 hr. 36 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/product/oracle/11.2.0/network/admin/listener.ora
Listener Log File /u01/product/diag/tnslsnr/hewmdbv6201/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hewmdbv6201)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "MANHST6" has 1 instance(s).
Instance "MANHST6", status READY, has 1 handler(s) for this service...
Service "MANHST6XDB" has 1 instance(s).
Instance "MANHST6", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@hewmdbv6201 ~]$ cat /u01/product/oracle/11.2.0/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/product/oracle/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hewmdbv6201)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/product