Re: Multiple Listeners

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).