shutdown password protected listener

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 02 Jan 2007 15:18:40 -0600
Message-ID: <BAY133-F39C25A5794F52EDF2C056697BA0@phx.gbl>

How do I shutdown the LISTENER with a password in a script. I have this default script called "oracle".

It starts and stops the databases and listener. When I changed the default listener settings for security reasons starting the listener is easy, it does not require the password. However shutting down down the listener is the problem.

PWD=${2} case "$1" in

'start')

                su - oracle -c "/oracle_home/bin/lsnrctl start LISTENER_ORCL"

'stop')

                su - oracle -c "/oracle_home/bin/lsnrctl set current_listener LISTENER_ORCL"

		su - oracle -c "/oracle_home/bin/lsnrctl set password ${2}"
		su - oracle -c "/oracle_home/bin/lsnrctl stop"

this last command fails. It points to the default listener LISTENER. Not the correct listener,
i.e. LISTENER_ORCL.

How do I shutdown a password protected listener thru a shell script?

thanks.

---

Fixing up the home? Live Search can help http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmemailtaglinenov06&FORM=WLMTAG

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

Received on Tue Jan 02 2007 - 15:18:40 CST