FW: auto start of listener with pwd

To find the process on the OS, just grep for tns. Ruth

-----Original Message-----
From: Mark Brinsmead [mailto:mark.brinsmead_at_shaw.ca] Sent: Thursday, December 01, 2005 10:13 PM To: rgramolini_at_tax.state.vt.us
Cc: joe_dba_at_hotmail.com; oracle-l_at_freelists.org Subject: Re: auto start of listener with pwd

This is mostly correct. To *start* a password-protected listener, no password is required.

If you want to STOP, STATUS, or RELOAD the listener (using 'lsnrctl', that is), you'll need to provide the password first.

You *can* however, STOP a password-protected listener (locally only) using 'kill -9'. Well, on UNIX platforms, anyway. I doubt Oracle Support would sanction this behaviour, but I also doubt it would do much harm (beyond maybe causing gaps in logfiles or something). That said, I *rarely* do this, and use it only as a last resort.

You don't need to be a rocket scientist to figure out which process to kill (or even to write a shell script than can do this). I suppose it would be kinda nice if Oracle would code the listener so that SIGHUP ('kill -1') would cause it to RELOAD, but that's not really necessary, I guess... ;-)

Cheers,
-- Mark.

Ruth Gramolini wrote:

>If I recall, you don't need a password to start the listener. You do need
>one to stop it or get its status.
>
>Someone correct me if I am wrong.
>
>
>

--
http://www.freelists.org/webpage/oracle-l