setting up listener to listen on 2 of 5 adresses (oracle9)

Hi,

sorry to ask (I guess its a trivial question), but I have read chapter 6 of the documentation and it only tells that I should use PROTOCOL =, HOST=, and PORT=. And this is fine for most of our SIDS, but we have one SID that should receive traffic from two different networkadapters (one legal address and one backbone (aka 192.168.x.y) address).

What I have done so far is that I have added a new line like this in the LISTENER section of the listener.ora file:

(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.x.y)(PORT = 1521)) )

Below this in the listener.ora file there is some SID_LIST_LISTENER and here all of the database SIDS are listed (?), and all of them have a GLOBAL_NAME and this is a valid dns name it seems like, I dont know what to do to this, if I should do anything at all.

Is this all I have to set up on the server? Only restart the listener and should it work???

I don't understand how the listener then should tell which SID to connect that listener to, it's important that the listener only connects the connections to one spesific SID.

Sorry again if this a really stupid question. I'm still searching Oracle to find the answer, but Oracle could really have a good use of a better search tool on their websites :-)

Thanks in advance for any answer.

Kind regards,
Roy T. Received on Mon Apr 15 2002 - 23:02:32 CEST