Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Stopping a listener
I had a problem with our MTS configured listener on AIX.
Bouncing the listener would disconnect the database from it, causing
all future connections to be dedicated by default.
In order to get back to Multi Threaded connections, we had to always bounce the databases after bouncing the listener.
Something we did wrong in configuration?
Akshay Jain
-----Original Message-----
From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com]
Sent: Tuesday, June 06, 2000 5:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Stopping a listener
Tom,
I believe you are right on Solaris also. I once have to bounced a heavily used listener. No one noticed at all.
Or I am just lucky that time! :)
Winnie
"Tom Pall" <tpall_at_cdproc.com> on 06/06/2000 01:12:13 PM
To: steve_at_arzoo.com, "Oracledba" <oracledba_at_QuickDoc.co.uk>, "Oracle-L"
<oracle-l_at_fatcity.com>
cc: (bcc: Winnie Liu/HQ/ISC)
Sparc Solaris 2.6, 2.7. When I stop the tcp listener, the dedicated
processes remain,
but new people cannot log in. When I restart, everything is back to
normal.
Recently on a box with Oracle 8.0.5 and 8.1.6 were running, each with its
own listener
(one on port 1521, the other on 1526). I shut down the 8.0.5 listener,
refreshed the
8.1.6 listener (listener.ora file edited for listening on ports 1521 and
1526 for both databases).
Nobody noticed. And this is a heavily hit back end to an e-commerce site.
----- Original Message -----
To: Oracledba <oracledba_at_QuickDoc.co.uk>; Oracle-L <oracle-l_at_fatcity.com>
Sent: Tuesday, June 06, 2000 1:23 PM
> What's the effect of stopping a TCP listener on Solaris? I thought it
> always stopped any existing connections but here's what it says in a clip
> from Appendix A of the Net8 Admin Guide:
>
> "On some platforms and with some protocols, when a listener is stopped
> any Net8 connections currently running are shut down. In some
> situations the connections continue, but it is then not possible to
> start the listener again until the running processes have been closed."
>
>
> Are there any protocols which do not get immediately disconnected on
> Solaris?
>
>
> Steve Orr
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
(updated daily)
> to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
-- Author: INET: Winnie_Liu_at_infonet.com 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: 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 mayReceived on Wed Jun 07 2000 - 09:13:21 CDT