Oracle on multihomed host
Posted on 2012-09-13
We have a client running Oracle 11g on a server with 2 NICs. Only one is currently enabled, as the machine is servicing a community of users on a network related to a large construction project. The client now wants people on another related project to be able to use the Oracle instance on this machine, which will require the activation of the second NIC so that it appears on the other project's network as well.
What (if anything) do we need to do to the Oracle instance to ensure that it serves requests for data via port 1521 on both IP addresses? I assume we may need to edit some .ora files but detailed guidance would be welcome.
Thanks in advance