RE: auto start of listener with pwd

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Thu, 1 Dec 2005 13:20:27 -0600
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E36012AB8CA@CWYMSX04.Corp.Acxiom.net>

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`
LISTENER_PASS=`grep "PASSWORDS_LISTENER" $ORACLE_HOME/network/admin/listener.ora | cut -d' ' -f3`

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

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

Dave

---

Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com>

---

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Joe Smith
> Sent: Thursday, December 01, 2005 12:13 PM
> To: oracle-l_at_freelists.org
> Subject: auto start of listener with pwd
>
> List,
>
>
> I need to password protect the listener on my Solaris 8 9iRel2 db. If
I
> password protect the listener will the listener auto start upon server
> reboot when the dbora/dbstart/dbstop scripts are called? Or do I need
to
> 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
FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

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.

---

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

Received on Thu Dec 01 2005 - 13:27:29 CST