Re: How to start 2 listeners on 1 UNIX machine with 2 network cards (i.e. 2 IP addresses) ?

Hi Nelson,

    Although I am sure there is (are) a better way(s) to do what you want.....

    Step 1. Beg, plead, cajole, and coerce your Unix system administrator to add two additional entries to /etc/services. Just tell him/her to copy the 1521 and 1526 entries to 1522 and 1527.

    Step 2. Edit the listener.ora file and copy the entry for the first instance changing the ports to 1522 and 1527 and changing the SID name.

    Step 3. Edit the tnsnames.ora file (on the server) and make the same changes that you did for the listener.ora file

    Step 4. (Big pain in the neck) Edit the tnsnames.ora files on each or your clients and make the same changes you did in the server's tnsnames.ora file. This is a big pain because once you do this you can no longer use net*easy (or whatever it is called) to edit the tnsnames.ora file

regards
jerry gitomer

Nelson Mak wrote in message
<37f1cdc1.7339029_at_news.glink.net.hk>...
>Our RS/6000 running Oracle 8.0.5.1 originally have 1 network
card and
>1 IP address. We have the listener running fine.
>
>However now we have added 1 more network card (connecting a
different
>network) to the machine and we cannot get the PC on the new
network to
>connect to Oracle.
>
>I suspected that we need to start another listener listening to
the
>new IP address.
>
>How can I do that ?
>
>Thanks,
>Nelson Mak
>
>
Received on Wed Sep 29 1999 - 13:12:39 CDT