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 <[EMAIL PROTECTED]> 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: [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). > __________________________________________________ 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: [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).