Re: Multiple Listeners

Hmm,

The db7 (upgraded to 817) automatically registers itself to listener. Why?

And, changing the PORT, wouldn't I need to change all tnsnames.ora ? Nabil, your and Kirti's suggestion for one listener has this particular benefit.

Still thinking.........I am.....

-Rachna

• Original Message ----- To: "'Rachna Vaidya'" <rachnavaidya_at_hotmail.com> Sent: Wednesday, October 16, 2002 2:33 PM

> again,
>
> I think its better to use one listener. Unless you have some reason for
> needed two of them.
>
> just me 2 cents
>
> :-)
>
> nabil
>
> -----Original Message-----
> From: Rachna Vaidya [mailto:rachnavaidya_at_hotmail.com]
> Sent: Wednesday, October 16, 2002 1:21 PM
> To: LazyDBA.com Discussion
> Subject: 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 -----
> From: "Stephen Lee" <slee_at_dollar.com>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 16, 2002 2:39 PM
> Subject: RE: Multiple Listeners
>
>
> >
> >
> > > -----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).
> >
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>

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