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'" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > 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" <[EMAIL PROTECTED]> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] > To subscribe: send a blank email to [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
