short answer: no
Longer answer:
you would have to have a separate listener for each database to stop
the services only for one database. Or you could edit the listener.ora
file, remove the one database you wanted to stop listening for, stop
the listener (this won't disconnect anyone already logged in, but will
stop anyone else logging in to ANY database) and restart the listener
with all the databases you want to continue listening for. I *think*
you might be able to just reload the listener but I'm not sure it would
stop listening for that one database and I don't have a test machine
available to try it on
- kommareddy sreenivasa <kommacnu_at_yahoo.com> wrote:
> 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).
>
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: Rachel Carmichael
INET: wisernet100_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).
Received on Mon Feb 10 2003 - 07:48:39 CST
