how do I configure Oracle Net Listener on a server with two network connections
If you have static ips you can configure them all in the listener.ora file:


LISTENER=
  (DESCRIPTION=
    (ADDRESS_LIST=
      (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
      (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.1)(PORT=1521))
      (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521))
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc1521))))



If you don't know the IPs or Hostname, you can also leave out the HOST part (this is undocumented as far as I know) this will result in listening on any:


(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(PORT = 1521))
)