= Oracle Listener Not Listening On Localhost =

**Summary**: How to configure the Oracle Listener to listen on the short hostname. \\
**Date**: Around 2013 \\
**Refactor**: 8 March 2025: Checked links and formatting. \\
{{tag>oracle}}

The oracle dba-er told me there was something wrong with the network on a new AIX box. The Oracle listener didn't listen on localhost which caused the oracle enterprise manager installation to fail.

This was shown using the netstat command:
<code>
sjoerd@oraclebox:/home/sjoerd>netstat -na | grep 1521
tcp4       0      0  10.10.10.100.1521         *.*                       LISTEN
tcp4       0      0  10.10.10.100.1521         10.10.10.1.1429           ESTABLISHED
tcp4       0      0  10.10.10.100.1521         10.10.10.100.32782        ESTABLISHED
tcp4       0      0  10.10.10.100.32782        10.10.10.100.1521         ESTABLISHED
tcp4       0      0  10.10.10.100.1521         10.10.10.100.32871        ESTABLISHED
</code>
And indeed, when trying to do a 'telnet localhost 1521' we got an connection refused error.

= Solution =
Turns out, there were some undocumented issues regarding the Boot IP address, which was undocumented in releases prior to Oracle 11g. It comes down to the simple requirement that the oracle listener shouldn't listen on the long hostname or the host's IP-address but on the hosts short hostname:
\\
Original oracle listener file:
  sudo cat /opt/oracle/product/10.2/network/admin/listener.ora.old
<code>
# listener.ora Network Configuration File: /opt/oracle/product/10.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.100)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = comp01.company.local)
      (ORACLE_HOME = /opt/oracle/product/10.2)
      (SID_NAME = comp01)
    )
  )
</code>
\\
Modified oracle listener file:
  sudo cat /opt/oracle/product/10.2/network/admin/listener.ora
<code>
# listener.ora Network Configuration File: /opt/oracle/product/10.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oraclebox)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = comp01.company.local)
      (ORACLE_HOME = /opt/oracle/product/10.2)
      (SID_NAME = comp01)
    )
  )
</code>

= Restart Oracle Listener =
Now to reload the oracle listener with the new settings:
<code>
lsnrctl stop
lsnrctl start
</code>
Of course, these commands should be issued by the oracle user.

= Netstat =
Now the netstat command gives this line:
<code>
tcp4       0      0  *.1521                 *.*                    LISTEN
</code>