Re: How to startup 2 listeners on the same machine?

The method is simple, as given by Oracle. Please refer to:

http://web.singnet.com.sg/~petermag/oracle.html

Under "Net8 Related Technical Bulletins" the first technical article is on setting up two listener. The same article also describe the solution for setting up one listener to listen to two database instances, and as described within, the version need not be the same, and thus two different ORACLE_HOME is needed.

As for the question of locating the listener.ora file, it can be located ANYWHERE, as long as before using the lsnrctl to start the listener, the TNS_ADMIN env variable is set to where the listener.ora is located.

Let me know if there is any way I can help.

Steve Lucius wrote:
>
> Hello all
>
> I have two Oracle instances running on one machine. One is Oracle
> 8.0.4 and the other is Oracle 7.3.4. I have started the listener for the
> Oracle 8 database. What do I need to do to start a listener for the
> Oracle 7.3.4 database. Any help would be greatly appreciated
>
> Steve Lucius
> Raytheon Systems Co.

--

      \\\|///          Peter Teoh
    \\  - -  //        Oracle Certified Professional
     (  @ @  )
__oOOo-(_)-oOOo____________________________________
|                                           _____  |
|                                          (~._.~) |
|Email:petermag_at_singnet.com.sg             _{ Y }_ |
|Phone:97813086(HP)                       ()_~~~_()|
|Pager:96047971                            (_)-(_) |
|http://web.singnet.com.sg/~petermag/              |
|__________________________________________________|