Hi Karl,
Thanks for your input. This will atleast help me in
know the status. However, I will try with ssh option.
Thanks a lot.
Muru
--- karl craven <karl_craven_at_yahoo.com> wrote:
> muru,
> i can help you out on one part of your quest in
> shutting down a
> listener on a host.
>
> there are a couple of proviso's though and they are:
>
> a) you know the host name
> b) you know the listeners name if not using default
>
> shutting down the listener:
>
> this works fr the unix world at least and im sure
> you would follow the
> same process to achieve the same in the nt world.
>
> 1) make a copy of the listener.ora file into a
> directory of you choice
> 2) modify your TNS_ADMIN variable to reflect this
> 3) edit the listener.ora file and modify the HOST=
> to the system that
> you wish to connect to
> 4) run the lsnrctl executable and it will connect to
> that host
>
> now you can run all of the normal commands the most
> useful being
> services, status etc so that you can see the actual
> sids being serviced
> on that system.
>
> obviously 'shutdown' is one of them.
>
> however, you can not utilise the 'startup' option as
> oracle tries to
> create socket files on your host for the host that
> you are working
> against.
>
> sorry can't give you the full solution.
>
> the previous suggestion using rsh/ssh is about the
> only other way that
> i can think you could achieve this but most
> definately go with the ssh
> option as rsh allows snooping for passwords in the
> clear etc.
>
> hth
> karl
>
>
> --- Srinivas Rao Pulla <spulla_at_deploy.com> wrote:
> >
> > Probably these are some of the many ways we can
> do the task at the
> > OS
> > level, installing an rshd, or sshd, or a telnetd
> on the remote NT
> > server, if using a rshd/sshd we can fire a
> command from remotely and
> > interactively in case of a telnet server. There
> are lot many
> > freeware's
> > available on the web for the above said tools.
> >
> > Please let me know if you want more info on this,
> if it matches your
> > requirement.
> >
> > Srinivas
> >
> > Bala Muru wrote:
> >
> > > Hello Lists,
> > >
> > > I have to remotely manage few Oracle 8.1.5
> databases
> > > in NT4.0. I am able to remotely startup and
> shutdown
> > > instances but, I am stuck in remotely starting
> and
> > > shutting down listener services. Can anybody
> help me
> > > on this, please?
> > >
> > > Any help would be highly appreciated.
> > >
> > > TIA,
> > > Muru
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Shopping - Thousands of Stores. Millions
> of Products.
> > > http://shopping.yahoo.com/
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: Bala Muru
> > > INET: muru321_at_yahoo.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 may
> > > also send the HELP command for other information
> (like
> > subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Srinivas Rao Pulla
> > INET: spulla_at_deploy.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 may
> > also send the HELP command for other information
> (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of
> Products.
> http://shopping.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: karl craven
> INET: karl_craven_at_yahoo.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 may
> also send the HELP command for other information
Received on Fri Dec 08 2000 - 11:13:31 CST
