IP address used by listener
614406Nov 3 2010 — edited Nov 5 2010hi all,
we have 2 IPs (network cards) on one server (hp-ux). oracle db is installed on this server.
The listener PROD is defined in listener.ora using hostname
PROD =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCPROD))
(ADDRESS= (PROTOCOL= TCP)(Host= prodhost.prodomain)(Port= 1541))
)
in /etc/hosts
192.168.1.1 prodhost.prodomain prodhost
172.16.1.1 prodhost.prodomain prodhost
in hosts file only IP is different
my question is how to know which IP address the listener is using??
is there listener command that shows which IP address is used for the listener??
thank you
Edited by: BlueNet on Nov 3, 2010 1:23 PM