Message-Id: <10703.123981@fatcity.com> From: karl craven Date: Thu, 7 Dec 2000 23:59:32 -0800 (PST) Subject: Re: How to remotely start/stop oracle listener service? 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 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@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@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@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@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). __________________________________________________