RE: common listener

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Mon, 10 Feb 2003 07:24:12 -0800
Message-ID: <F001.0054853F.20030210072412@fatcity.com>

How about just a 'Reload' insead of stop and start? Much faster.

Ron Smith

-----Original Message-----
Sent: Monday, February 10, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L

Srinivas

   Stopping the listener does not affect existing connections, but only users that are trying to connect. Therefore you can modify the listener.ora file, then stop and start the listener without affecting your users. I would recommend that you avoid doing this when a lot of your users are logging in, like the first thing in the morning.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, February 10, 2003 6:04 AM
To: Multiple recipients of list ORACLE-L

Hi DBA's

I have a common listener setup for 4 database on a server.

i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB).

is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases)

Thnaks in advance,
Srinivas

---

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: kommareddy sreenivasa
  INET: kommacnu_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Smith, Ron L.
  INET: rlsmith_at_kmg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Feb 10 2003 - 09:24:12 CST