RE: auto start of listener with pwd

  • From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
  • To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Dec 2005 13:20:27 -0600

For what its worth, here's what we do for both auto start and stop (and
any other auto-maint work, like testing if its up or not):

[[ -z "$ORACLE_HOME" ]] && ORACLE_HOME=`cat /etc/oratab | grep "^\*" |
cut -d':' -f2`
$ORACLE_HOME/network/admin/listener.ora | cut -d' ' -f3`

IN_UPPER_CMD=`echo $1 | awk '{print toupper($1)}'`

echo "set password $LISTENER_PASS
exit" | $ORACLE_HOME/bin/lsnrctl

Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762

> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> On Behalf Of Joe Smith
> Sent: Thursday, December 01, 2005 12:13 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: auto start of listener with pwd
> List,
> I need to password protect the listener on my Solaris 8 9iRel2 db.  If
> password protect the listener will the listener auto start upon server
> reboot when the dbora/dbstart/dbstop scripts are called?  Or do I need
> supply the password in the above mentioned scripts to stop|start the
> listener upon startup|shutdown of the server such as:
> su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start  <password here>"
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's
> --
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.

Other related posts: