[Q] Can SQL*NET listen on two addresses at onec?

I have need to listen to two address with the same listener. I have tried modifing my listener.ora file to include the second listener address but after reloading and then attempting to conect it failed. I was hoping that someone might be able to shed some light on this.

I am running SQL*NET 2.2.3, Oralce 7.2.3 on HP/UX 10.10. I have two identical boxes connected and am running MCSERVICE GUARD (swith over type software). Each box has an IP address (say .1 &.2) and MCSERVICE GUARD has an IP address (say .3) (kind of like a virtual address) all trafic is directed to the .3 address which handles mapping it to the box that is currently running the instance and has all of the logical volumes mounted etc. My problem is that I have an installed base of users that are still pointing at the old IP address .1, but know the listener is listening to .3. I would like to set the listener to listen on both .1 and .3. One last thing I am running MTS.

Please help if you can.

Thank you very much!

-- 

Craig Harper 
IFTN


(v) 415.583.4528


(f) 415.583.5536                                                                                                                                                                                                                               


Thinking is more interesting than knowing,
but less interesting than looking.