RE: Multiple Listeners
Test first We discovered a bug on Tru64 that prevented this from working correctly in at least a couple versions of Oracle. 8.1.7 was suppossed to fix this, but it didn't. 8.1.7.3 did *I think*. [EMAIL PROTECTED] 10/16/02 11:39AM You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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).
Re: Multiple Listeners
Here are my current findings Auto Registration : === 1. Auto Registration takes place with default listener when local_listener=(ADDRESS=(PROTOCOL=TCP)HOST=lightening)(PORT=1526)) When the above line was NOT present in init.ora of the database (db7) for whcih the second listener is configured, the database Auto registered with the old listener (v816, PORT=1521) too. So, that I could connect to the database through both listeners. 2. Auto Registration does NOT take place with default listener when local_listener=(ADDRESS=(PROTOCOL=TCP)HOST=lightening)(PORT=1526)) When the above line was present in init.ora of the database (db7) for whcih the second listener is configured, the database Auto registered with the new listener. So, now I could connect to the database through the new listener only! Multiple Listeners : 1. Is it possible to have single listener? You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. So, using signel v817 listener for v817 as well as v816 databases was possible. 2. What's involved in configuring multiple listeners? There are metalink docs explaining it in details, But in short : They have to be of different names. Explicit name needs to be used for non default (name other than LISTENER) listeners while using lsnrctl command. They need to be listening on different ports. The KEY value for IPC needs to be different in each listener.ora. 3. Why I decided to run single listener in the end? When I was running two listeners, each was listening on different ports. Initially, I had only one listener at PORT=1521. So all my client side configuration in tnsnames.ora were pointing to PORT=1521. Now with this second listener listening at PORT=1526, I would have needed to change all of my client side configuration. (We are not using Names Server currently.) Thanks for the discussion! -Rachna -- 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).
Re: Multiple Listeners
There has been much discussion regarding single or multiple listeners and there seems to be a split between those who advocate one method over the other. I am currently working at a site with a large number of systems/databases. They are well organised and one of the standards that is in place is to have a listener per database with the same name as the database. The lowest port will be 1526 to avoid any issues with auto registration on port 1521. The whole concept works very well in my experience; the small overhead on the server is outweighed by the ability to stop a listener individually without affecting any other service. John
RE: Multiple Listeners
-Original Message- Okay, I will concede the point. Sometimes having multiple listeners can be a good thing. An example: (NOTHING)/etc ps -eo args | grep smon ora_smon_CATT2 ora_smon_CRCD1 ora_smon_CRCT1 ora_smon_DEMO ora_smon_DEVL ora_smon_DRTD ora_smon_DRTD1 ora_smon_DRTT ora_smon_DRTT1 ora_smon_DSNR2 ora_smon_DSNR4 ora_smon_DWHD ora_smon_FFLD ora_smon_FFLT1 ora_smon_FLCD ora_smon_FTLD ora_smon_FTLT ora_smon_HLPT ora_smon_INTD ora_smon_MOBT ora_smon_PWRT ora_smon_RSAD ora_smon_RTWD ora_smon_TIMD And there are some adhoc databases on the box that are shut down. -- 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).
Re: Multiple Listeners
On most servers I have only one database on the node. Where I do have multiple databases, I have seperate ORACLE_HOMEs. Where I have seperate ORACLE_HOMEs, I have seperate Listeners. There's really not much of an effort in managing multiple listeners -- after all you have to issue a seperate sqlplus command for each database [and also from a seperate ORACLE_HOME each time !] , you can also issue a seperate lsnrctl start listenername command. I could be running 8.1.7.2, 8.1.7.3 and 9.2.0.1 on the same box. When applying a patchset to upgrade to 8.1.7.3 or 8.1.7.4 for one database, I do not want to have to stop access to the other databases. Therefore, each database has it's own listener. Also, try _not_ to use 1521 as the listener port so that no database auto-registers with a listener. Hemant At 04:04 AM 17-10-02 -0800, you wrote: There has been much discussion regarding single or multiple listeners and there seems to be a split between those who advocate one method over the other. I am currently working at a site with a large number of systems/databases. They are well organised and one of the standards that is in place is to have a listener per database with the same name as the database. The lowest port will be 1526 to avoid any issues with auto registration on port 1521. The whole concept works very well in my experience; the small overhead on the server is outweighed by the ability to stop a listener individually without affecting any other service. John Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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).
Multiple Listeners
DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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).
Re: Multiple Listeners
1st thing i do when upgrading db's on a server is to start using the new listener. just have your 816 db's use the 817 listener. hth, gene [EMAIL PROTECTED] 10/16/02 02:12PM DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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).
RE: Multiple Listeners
You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: Multiple Listeners
Rachna, Do yourself a favor - use the most recent listener for all databases. Have only one listener running on a machine and use that for all databases on that machine. In your case, use the 817 listener. In the long run, it will be much easier and less confusing. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 16, 2002 2:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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).
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 21 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).
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 [EMAIL PROTECTED] 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 21 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). -- 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).
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. - 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 -- 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).
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' [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 21 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
RE: Multiple Listeners
I respectfully disagree. I am currently working on a Sun 4500 cluster with Veritas. The cluster services each maintain their own nic/ip, that's 1 per instance. Obviously, each instance also has its own listener. This has been very easy to implement and not at all confusing. It also avoids things like where you can't use a 8.0.5+ listener for 8.0.4- instances. Each SID has its own listener at its own version level. I would suggest coming up with a good standard for determining ports and such however. For instance, I use 15 concatenated with the last 2 digits of the assigned IP. Before walking into the cluster world, I would have agreed with Tom. Of course now I have seperate HOMEs for each instance too. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Rachna, Do yourself a favor - use the most recent listener for all databases. Have only one listener running on a machine and use that for all databases on that machine. In your case, use the 817 listener. In the long run, it will be much easier and less confusing. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, October 16, 2002 2:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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).
RE: Multiple Listeners
Not always. 8.0.5+ listeners can not be used with 8.0.4- databases... John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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).
RE: Multiple Listeners
-Original Message- 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. I have seen later versions of the listener find instances on the box and automatically listen for them on port 1521. I don't remember the exact version that this start happening since I'm not good at remembering these kinds of facts. What appears to be happening is the spread of the Microsoft philosophy of Oh here. Let us HELP you with that ... whether you like or not. The reason we use a listener to match the version of the database is that, around here, Murphy has a B-I-G desk, in a corner office, and he works 24 hours per day, 7 days per week. -- 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).
RE: Multiple Listeners
That's because of the new feature of Auto Registration with Listener... I guess, it's about time to review docs for changes in 8i Release 2 (8.1.7)... there could be more such surprises :) - Kirti -Original Message- Sent: Wednesday, October 16, 2002 2:50 PM To: Multiple recipients of list ORACLE-L 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. - 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 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: Multiple Listeners
May be that was one of bugs in 8.0.5.. At present we have 9.0.1 listener for 7.3.4, 8.1.6, 8.1.7.2, 8.1.7.3, 8.1.7.4 and 9.0.1 databases on HP-UX. Not a problem. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Not always. 8.0.5+ listeners can not be used with 8.0.4- databases... John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
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 [EMAIL PROTECTED]@fatcity.com on 10/16/2002 02:23:35 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 21 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). -- 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
RE: Multiple Listeners
This is a platform specific statement. What you said is correct for TRU64. -Original Message- Sent: Wednesday, October 16, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Not always. 8.0.5+ listeners can not be used with 8.0.4- databases... John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L You can use the 'higher' version of the listener for all databases running on = higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 - 8.1.6 db7 - 8.1.6 db6 and db7 use the listener of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 - listener of 8.1.6 (status quo) db7 - listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gesler, Rich 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).
RE: Multiple Listeners
-Original Message- even Oracle will tell you that running multiple listeners is worse than foolish.:) Please supply the link to Oracle's article with this statement. -- 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).
RE: Multiple Listeners
-Original Message- Sent: Wednesday, October 16, 2002 4:20 PM 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. -New Stuff Yes, I cut a lot. :) I will agree that having 1 listener per box is all you _should_ need. However, due to experience with past bugs (and who knows when similar problems may appear in the future) and as you concede, running high availability fail over services, I would disagree with the assertion that multiple listeners are worse than foolish. A single listener is a single point of failure across multiple instances, eliminating that is not foolish, and there are other reasons one might want to run multiple listeners. What about extproc (if you need it for some reason). Oracle itself _requires_ 3 listeners for the apps the last time I checked (1 for the db, 2 for external program calls). To analyze network traffic, it is sometimes useful to be able to isolate particular port traffic. Multiple listeners allow for this kind of work too. So, while only 1 may be all that is necessary, there is no real reason, IMHO, that multiple listeners are inherently a bad practice. John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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).
RE: Multiple Listeners
-Original Message- but even Oracle will tell you that running multiple listeners is worse than foolish.:) Trust me, you only need one version of the Listener up. From O'Reilly's Oracle Net8 Configuration and Troubleshooting book, pages 70 - 71, under the sub-topic Why Use Multiple Listeners?: Even though one listener may be all you need, there are some management advantages to using more than one: redundancy and separation of environments. Two listeners can be used to provide redundancy in case one fails. Such a configuration not only protects you from the failure of one listener, it also enables you to more easily make changes that require a listener to be restarted. ... Separation of environments is another reason to use multiple listeners. If you have two databases running on a server, you may not want any part of those two database environments intertwined. That way, if you need to restart the listener for one database, you don't affect users of the other. ... End of quote. I might add, if you have multiple versions of Oracle running on a box and need to patch a version in such a way that requires a complete relinking of that version, you can stop only the processes associated with that version. The decision to run multiple listeners was not my decision to make here. But having worked in this environment for a while, I can say that it has never been a problem. -- 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).
RE: Multiple Listeners
You are right Kirti This is a new feature of 8i. It also does it in 9i. Ramon -Original Message- Kirti Sent: Wednesday, October 16, 2002 3:15 PM To: Multiple recipients of list ORACLE-L That's because of the new feature of Auto Registration with Listener... I guess, it's about time to review docs for changes in 8i Release 2 (8.1.7)... there could be more such surprises :) - Kirti -Original Message- Sent: Wednesday, October 16, 2002 2:50 PM To: Multiple recipients of list ORACLE-L 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. - 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 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez 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).
RE: Multiple Listeners
Okay, I will concede the point. Sometimes having multiple listeners can be a good thing. Although running older versions of the listener may not be. But you pay your money and you take your chances. Thank you for those who cited published sources. Please remember: what an Oracle analyst will tell you on the phone and what is printed in the documentation do not always match. If you have ever had a torturous TAR then you know what I mean. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Multiple Listeners
Congratulations !! Now one more point--- If one uses default listener name (listener) and default port (1521), databases (8i,+) will auto register with this listener first. Either do not use default names and ports, or make sure that you set your init.ora parameters (service_names?) correctly to register them with the listener you wanted those databases to use. I think there is Note on Metalink discussing this issue. I forget the note number at the moment - Kirti -Original Message- Sent: Wednesday, October 16, 2002 2:24 PM To: Multiple recipients of list ORACLE-L 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 [EMAIL PROTECTED] 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 21 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
RE: Multiple Listeners
It is my understanding that you don't need the; SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) section if you define the service_names entry in your init.ora files. You should do one or the other. Please correct if I'm wrong, but this is how it works on my 8.1.6 instances. -Original Message- Aschenbrenner Sent: Monday, July 16, 2001 6:27 PM To: Multiple recipients of list ORACLE-L Edward, Yes, you can setup multiple listeners. Here is an example: LISTENERDB1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521)) ) ) ) LISTENERDB2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1522)) ) ) ) SID_LIST_LISTENERDB1 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME1) (ORACLE_HOME = /path/to/oracle/home) ) ) SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) After you have set this up, you can start the listeners individually: lsnrctl start listenerdb1 lsnrctl start listenerdb2 Hope that helps... Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] (303)-858-6394 -Original Message- Carr Sent: Monday, July 16, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Multiple Listeners
The external procedures run under the authority of the user which started the listener that has the sid list entry for them. This does not always seem to work. If you submit your external procedure using dbms_job, for example, it will still run as Oracle. Or at least that is my experience. John -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: 17 July 2001 00:41 To: Multiple recipients of list ORACLE-L Subject: RE: Multiple Listeners If you are using external procedures, the listener for them should be different as well. The external procedures run under the authority of the user which started the listener that has the sid list entry for them. If you place the entry in the main listener and that listener is initialized by oracle, the external procedures run with the authority of the oracle OS user. Having a different listener which can be started by a less privileged account allows the external procedures to run with less authority. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 16, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Mladen, I can think of numerous reasons to have multiple listeners. For example, imagine a server with several databases where you sometimes wanted to restrict outside access on just one database. Meanwhile still allowing local users on that server to access that particular database. In this case restricted mode wouldn't work, and downing the listener would restrict remote access to all the databases. With multiple listeners you could shutdown the listener for just that database. Outside users would then be unable to connect, but local users would still be able to work. The other databases would continue as usual... Another example, Veritas Cluster, is the reason I use multiple listeners. You need to be able to failover the listener for just one database, not all of them! Alan -Original Message- Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Multiple Listeners
Can you give me an example where this is so. One of my external procedures is used to send a page should something go awry. I ran a job to send the page; the sender of the page was the user who started the extproc listener and not oracle. Just to be perfectly clear, I am speaking of the operating system user and not of the database user. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 17, 2001 3:01 AM To: Multiple recipients of list ORACLE-L The external procedures run under the authority of the user which started the listener that has the sid list entry for them. This does not always seem to work. If you submit your external procedure using dbms_job, for example, it will still run as Oracle. Or at least that is my experience. John -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: 17 July 2001 00:41 To: Multiple recipients of list ORACLE-L Subject: RE: Multiple Listeners If you are using external procedures, the listener for them should be different as well. The external procedures run under the authority of the user which started the listener that has the sid list entry for them. If you place the entry in the main listener and that listener is initialized by oracle, the external procedures run with the authority of the oracle OS user. Having a different listener which can be started by a less privileged account allows the external procedures to run with less authority. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 16, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Mladen, I can think of numerous reasons to have multiple listeners. For example, imagine a server with several databases where you sometimes wanted to restrict outside access on just one database. Meanwhile still allowing local users on that server to access that particular database. In this case restricted mode wouldn't work, and downing the listener would restrict remote access to all the databases. With multiple listeners you could shutdown the listener for just that database. Outside users would then be unable to connect, but local users would still be able to work. The other databases would continue as usual... Another example, Veritas Cluster, is the reason I use multiple listeners. You need to be able to failover the listener for just one database, not all of them! Alan -Original Message- Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Re:RE: Multiple Listeners
Dick, Well, I've not seen the bug you describe and we have over 20 db's in one listener on several different boxes. We are in 8.1.6 on Compaq Tru64. We did have a problem trying to get one listener in 8.1.6 to listed for 8.0.x and 7.3.x databases and WWS discovered that a bug they thought was fixed in 8i was not fixed for Compaq. We're now looking at OID. Any horror/success stories out there? Stephen [EMAIL PROTECTED] 07/16/01 04:47PM Alex, This gets down to the amount of trust your damagement has in you. If theyare more tempted to listen to outside assertions that you have already heard,then it's time to move on because your being treated like a trained monkey. Mymanagement does ask questions on this type of subject when they've heardsomething new outside. It's normally just tossed in my direction as a "Hey Iheard that these folks are doing this. What do you think?". In which case Inormally find out what their doing why and what Oracle says about it as well. If it does not make sense, it ends up in the round file there is no morediscussion. It also helps to have management types who have some knowledge ofthe technology. The result is less of the problem you state. From a listener perspective, there is only one absolutely good reason thatI've found to run more than one listener per node that is that after you pass10 DB's in one listener it appears to run out of memory won't listen for theothers. I did find a bug on Metalink on the subject, but it was suppose to havebeen fixed in 8.0.6 though I've not verified that. Dick GouletReply SeparatorAuthor: "Hillman; Alex" [EMAIL PROTECTED]Date: 7/16/2001 3:01 PMBecause the more listeners you have - the better. If your damager ask youhow many listeners you are running and you answer one and he/she ( no sexizm:-)) heard that someone running 2 or 3 ( from another moro... err damager) -how would you explain why you are running only one. I hope that Ross can add more reasons to run at least 2 or better 3listeners.Alex Hillman-Original Message-Sent: Monday, July 16, 2001 6:21 PMTo: Multiple recipients of list ORACLE-LIt is possible to define 3 listeners on 3 different ports, each oneserving another database, but why would you do dat? You have 3 littledatabases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit fromhaving 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Gogala, Mladen INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hillman, Alex INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of ma
Multiple Listeners
Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. winmail.dat
RE: Multiple Listeners
It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Multiple Listeners
Edward, Yes, you can setup multiple listeners. Here is an example: LISTENERDB1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521)) ) ) ) LISTENERDB2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1522)) ) ) ) SID_LIST_LISTENERDB1 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME1) (ORACLE_HOME = /path/to/oracle/home) ) ) SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) After you have set this up, you can start the listeners individually: lsnrctl start listenerdb1 lsnrctl start listenerdb2 Hope that helps... Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] (303)-858-6394 -Original Message- Carr Sent: Monday, July 16, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Multiple Listeners
Because the more listeners you have - the better. If your damager ask you how many listeners you are running and you answer one and he/she ( no sexizm :-)) heard that someone running 2 or 3 ( from another moro... err damager) - how would you explain why you are running only one. I hope that Ross can add more reasons to run at least 2 or better 3 listeners. Alex Hillman -Original Message- Sent: Monday, July 16, 2001 6:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Multiple Listeners
Mladen, I can think of numerous reasons to have multiple listeners. For example, imagine a server with several databases where you sometimes wanted to restrict outside access on just one database. Meanwhile still allowing local users on that server to access that particular database. In this case restricted mode wouldn't work, and downing the listener would restrict remote access to all the databases. With multiple listeners you could shutdown the listener for just that database. Outside users would then be unable to connect, but local users would still be able to work. The other databases would continue as usual... Another example, Veritas Cluster, is the reason I use multiple listeners. You need to be able to failover the listener for just one database, not all of them! Alan -Original Message- Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re:RE: Multiple Listeners
ED, OK, looks like you've got 2 or more servers, each supporting a single DB or are you running parallel server? I'll assume the later since that would make more sense. Therefore, set up each listener to listen for requests on it's hostname and port 1521 which is just about the standard. I'd give each listener a specific name like 'listener_node_name' so that you can have everything in one file and use only what is needed. Kinda of like Alan suggested, but with different hostnames. I think he was thinking on multiple listeners on one host, not multiple listeners on multiple hosts. Dick Goulet Reply Separator Author: Edward W. Carr [EMAIL PROTECTED] Date: 7/16/2001 2:45 PM We are running Veritas Cluster Server and need it to be able to shutdown and startup the databases individually of themselves. We have the ability to run the any of the databases on any of the servers we choose, so I can run them on individual servers or all on the same server... I need to be able to do this!!! So any helpful hints would be appreciated!!! As I am not a D.B.A. I have a BIG learning curve ahead of me ... :) I have already had excellent help from the following: Alan Aschenbrenner Charlie Mengler Thanks Guys!!! -Original Message- Mladen Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward W. Carr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Multiple Listeners
However, to answer the question, you need to name the listeners something other then listener and you need to have them listening on different ports. When you use the lsnrctl command you have to reference the listener you are dealing with. There are reasons to have multiple listeners. For example, when running HP ServiceGuard I have setup the databases to be able to fail separately so they each have their own listener that fails with the database. I needed it with Trusted Oracle as well, but I believe that is case dependant. On listened for stuff coming from the secret side and the other from the other side. -Original Message- Sent: Monday, July 16, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Edward, One must ask, what benefit do you perceive you will obtain from having multiple listeners? The listener is only there to hear the end applications request for database service and pass them along to the appropriate dedicated server or dispatcher as required. Then it goes off to do other things. We have one HP with 9 different instances, one listener. Works fine all day. Dick Goulet Reply Separator Author: Edward W. Carr [EMAIL PROTECTED] Date: 7/16/2001 1:42 PM Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Multiple Listeners
We are running Veritas Cluster Server and need it to be able to shutdown and startup the databases individually of themselves. We have the ability to run the any of the databases on any of the servers we choose, so I can run them on individual servers or all on the same server... I need to be able to do this!!! So any helpful hints would be appreciated!!! As I am not a D.B.A. I have a BIG learning curve ahead of me ... :) I have already had excellent help from the following: Alan Aschenbrenner Charlie Mengler Thanks Guys!!! -Original Message- Mladen Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward W. Carr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Multiple Listeners
If you are using external procedures, the listener for them should be different as well. The external procedures run under the authority of the user which started the listener that has the sid list entry for them. If you place the entry in the main listener and that listener is initialized by oracle, the external procedures run with the authority of the oracle OS user. Having a different listener which can be started by a less privileged account allows the external procedures to run with less authority. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 16, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Mladen, I can think of numerous reasons to have multiple listeners. For example, imagine a server with several databases where you sometimes wanted to restrict outside access on just one database. Meanwhile still allowing local users on that server to access that particular database. In this case restricted mode wouldn't work, and downing the listener would restrict remote access to all the databases. With multiple listeners you could shutdown the listener for just that database. Outside users would then be unable to connect, but local users would still be able to work. The other databases would continue as usual... Another example, Veritas Cluster, is the reason I use multiple listeners. You need to be able to failover the listener for just one database, not all of them! Alan -Original Message- Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re:RE: Multiple Listeners
Alex, This gets down to the amount of trust your damagement has in you. If they are more tempted to listen to outside assertions that you have already heard, then it's time to move on because your being treated like a trained monkey. My management does ask questions on this type of subject when they've heard something new outside. It's normally just tossed in my direction as a Hey I heard that these folks are doing this. What do you think?. In which case I normally find out what their doing why and what Oracle says about it as well. If it does not make sense, it ends up in the round file there is no more discussion. It also helps to have management types who have some knowledge of the technology. The result is less of the problem you state. From a listener perspective, there is only one absolutely good reason that I've found to run more than one listener per node that is that after you pass 10 DB's in one listener it appears to run out of memory won't listen for the others. I did find a bug on Metalink on the subject, but it was suppose to have been fixed in 8.0.6 though I've not verified that. Dick Goulet Reply Separator Author: Hillman; Alex [EMAIL PROTECTED] Date: 7/16/2001 3:01 PM Because the more listeners you have - the better. If your damager ask you how many listeners you are running and you answer one and he/she ( no sexizm :-)) heard that someone running 2 or 3 ( from another moro... err damager) - how would you explain why you are running only one. I hope that Ross can add more reasons to run at least 2 or better 3 listeners. Alex Hillman -Original Message- Sent: Monday, July 16, 2001 6:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Multiple Listeners
You just place the different listeners in the listener.ora file. Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).