0

I have a server that I have virtualized and as such it has two network connections, one to simulate a network between several virtual machines and the other to connect to the host physical network. when this server starts, oracle net listener does not start automatically. My understanding of this issue is that there is a conflict in host address configuration in my .ora file seeing as during initial install, net config assistant sets it up with a host address. Can someone advise me on how to correctly configure this Listener to have it startup automatically?

1

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))
)
  • Thanks Dieter for that suggestion, one connection is on static ip and the other is on auto ip config. is it possible to combine option 2 of your suggestions with option 1? – Edwin Bagzee Baguma Jun 22 '14 at 7:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.