Re: Multiple Listeners

It is better to have a single Listener per server, unless you have multiple servers that use high availability fail over between the servers. The single listener should be the most recent one on the server. It is backwards compatible with Oracle8i versions and Oracle7 databases. There is no need to run multiple listeners on the same server, especially when the versions are just one release off from each other (e.g. 8.1.6 and 8.1.7). A single listener and a single Intelligent Agent should be all that is needed. It may be clever to see if multiple listeners can run, but even Oracle will tell you that running multiple listeners is worse than foolish.:) In addition to changing the Oracle Home, the LD_LIBRARY_PATH or LIBPATH would have to be changed as well to match the libraries to the correct version of the listener.

Trust me, you only need one version of the Listener up. I have three versions of Oracle on a server: Oracle7, Oracle8i v8.1.7 and Oracle9i v9.2.0. I use the Oracle9i listener and agent on the servers. It allows seamless connections to all the databases.

RWB "Rachna Vaidya" <rachnavaidya_at_hotmail.com>@fatcity.com on 10/16/2002 02:23:35 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Thanks for the inputs.
This is how I did it.

1. There are two listener.ora files /opt/app/oracle/product/816/listener.ora : FILE816 /opt/app/oracle/product/817/listener.ora : FILE817 FILE817 is a copy of FILE816
2. Entries for db7 are removed from FILE816 FILE816 listner name is left unchanged as LISTENER FILE816 entry for IPC was left unchanged : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) FILE816 entry for PORT was left unchanged : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1521))
3. Entries for db6 are removed from FILE817 and ORACLE_HOME path changes are made FILE817 listner name was changed to LISTENER_817 FILE817 entry for IPC was changed as : (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_817)) ORACLE_HOME path changes were made to FILE817 FILE817 entry for PORT was changed as : (ADDRESS = (PROTOCOL = TCP)(HOST = lightening)(PORT = 1526))
4. To use 816 listener

ORACLE_HOME=$/opt/app/oracle/product/816 cd $ORACLE_HOME/network/admin

$ORACLE_HOME/bin/lsnrctl stop listener
$ORACLE_HOME/bin/lsnrctl start listener
$ORACLE_HOME/bin/lsnrctl status listener

9. To use 817 listener

ORACLE_HOME=$/opt/app/oracle/product/817 cd $ORACLE_HOME/network/admin

$ORACLE_HOME/bin/lsnrctl stop listener_817
$ORACLE_HOME/bin/lsnrctl start listener_817
$ORACLE_HOME/bin/lsnrctl status listener_817

And I think I am having

a. two separate Listeners
b. for two different databases
c. in different version (having different ORACLE_HOME)
d. listening at different ports

Am I correct or there is some mistake / improvement?

Thanks for the inputs.

-Rachna
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 16, 2002 2:39 PM

>
>
> > -----Original Message-----
> > Any quick start guides / scripts / notes for having multiple version
> > listeners on same Solaris box?
>
> ------------------------------------
>
> It works fine. Here is an example of some commands to put into a general
> Oracle startup script.
>
> export ORACLE_BASE=/oracle/app/oracle
> export LOGFILE=${ORACLE_BASE}/log/ora-startup.log
>
> exec >> $LOGFILE 2>&1
>
> touch $LOGFILE
> chmod a+r $LOGFILE
>
> print "\nStarting ora-startup"
> date
>
> # Automatically export all variables
> set -a
>
> # Start the databases
> $ORACLE_BASE/admin/dbascripts/init.d/dbstart
>
> # Start the listeners
> export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
> $ORACLE_HOME/bin/lsnrctl start LIST_V920
>
> export ORACLE_HOME=$ORACLE_BASE/product/9.0.1
> $ORACLE_HOME/bin/lsnrctl start LIST_V901
>
> #Start the listeners
> export ORACLE_HOME=$ORACLE_BASE/product/8.1.7
> $ORACLE_HOME/bin/lsnrctl start LIST_DSNR4
> $ORACLE_HOME/bin/lsnrctl start LIST_V817
> $ORACLE_HOME/bin/lsnrctl start LIST_V817_2
>
> export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4
> $ORACLE_HOME/bin/lsnrctl start LIST_V8174
>
> etc.
> etc.
> etc.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephen Lee
> INET: slee_at_dollar.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachna Vaidya
  INET: rachnavaidya_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).