Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I start/stop a sql/net v2 listener while keeping the other running ???

Re: How do I start/stop a sql/net v2 listener while keeping the other running ???

From: <soverby_at_nspr.com>
Date: 1998/03/09
Message-ID: <6e0vas$j5f$1@nnrp1.dejanews.com>#1/1

Have you tried?

           lsnrctl stop

In article <3501bcae.181146495_at_news.maska.net>,   ab_at_sib.qc.ca wrote:
>
> On Fri, 06 Mar 1998 04:28:31 GMT, rprendin_at_magi.com (Robert Prendin)
> wrote:
>
> Well, what I mean, was a way to stop the tcp/ip listener as we did in
> sql/net v1.
>
> So that no one can attempt to connect to the DB via a tcp/ip listener
> outside our business hours...
>
> And I don't want a DB solution while a simple novcron (cron job under
> novell) would do the trick...
>
> It seem that the tool furnished with Oracle DB under NT lack a way to
> create multiple listener name...
>
> I have posted my question to Oracle support, but have yet to receive
> any answer...
>
> >Have you considered 'alter system enable/disable restricted session'
> >command? Which would not allow any connections to anyone without the
> >restricted session privelege.. This will allow you to pick and choose
> >who is able to connect and change the state of the DB at your leisure,
> >or perhaps I have really misunderstood what you are attempting to do.
> >
> >Cheers, Robert Prendin
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US