RE: lsnrctl commands
- To: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Feb 2007 08:49:59 -0700
I have been able to get multiple commands to go into the lsnrctl command
using:
lsnrctl << EOF
set password $LSNR_PASS
show log_directory
exit
EOF
I was hoping to be able to get the commands on 1 line so that I could
redirect the output through awk and mine the directory and name
information.
Honestly, it's a 'nice to have' and not a requirement because the
$ORACLE_HOME and the listener.log names are consistent across servers
here.
Steve Smith
Envision Technology Partners / MSHA MSIS Team
Desk: 303-231-5499
-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx]
Sent: Tuesday, February 27, 2007 6:04 AM
To: tony.vanlingen@xxxxxxxxxxxxxx; Smith, Steven K - MSHA
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: lsnrctl commands
You can get it to work on NT or Unix by echoing your commands into a
temporary file and then passing that file into lsnrctl
echo set password pa55w0rd > lsn.cmd
echo show log_directory >> lsn.cmd
echo exit >> lsn.cmd
lsnrctl < lsn.cmd
Tom
--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity
to whom it is addressed. If you are not the intended recipient, you are
hereby notified that any disclosure, dissemination, copying or
distribution of this transmission or its attachments is strictly
prohibited. In addition, unauthorized access to this transmission may
violate federal or State law, including the Electronic Communications
Privacy Act of 1985. If you have received this transmission in error,
please notify the sender immediately by return e-mail and delete the
transmission and its attachments.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tony van Lingen
Sent: Monday, February 26, 2007 10:43 PM
To: Smith.Steven@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: lsnrctl commands
On unix:
$ lsnrctl <<EOF
> set password pa55w0rd
> show log_directory
> EOF
...
In windows I don't think you get it to work - unless you use
Cygwin...but that would be cheating :)
Cheers,
Tony
Smith, Steven K - MSHA wrote:
> Is there any way to run multiple lsnrctl commands on the same command
> line? Our listeners are password protected. I'm putting together a
> script to rotate the logs and I want to dynamically pull the log
> directory and file name from the lsnrctl utility. I'm having trouble
> finding the syntax to execute both the set password and the show
> log_directory on the same lsnrctl command prompt.
>
> for an example of what I'm trying to accomplish:
>
> lsnrctl set password pa55w0rd show log_directory
>
> But this syntax doesn't work past the 'set password'
>
> Thanks
>
>
> Steve Smith
>
> Envision Technology Partners / MSHA MSIS Team
>
> Desk: 303-231-5499
>
>
>
___________________________
Disclaimer
WARNING: This e-mail (including any attachments) has originated from a
Queensland Government department and may contain information that is
confidential, private, or covered by legal professional privilege, and
may be protected by copyright.
You may use this e-mail only if you are the person(s) it was intended to
be sent to and if you use it in an authorised way. No one is allowed to
use, review, alter, transmit, disclose, distribute, print or copy this
e-mail without appropriate authority. If you have received this e-mail
in error, please inform the sender immediately by phone or e-mail and
delete this e-mail, including any copies, from your computer system
network and destroy any hardcopies.
Unless otherwise stated, this e-mail represents the views of the sender
and not the views of the Environmental Protection Agency.
Although this e-mail has been checked for the presence of computer
viruses, the Environmental Protection Agency provides no warranty that
all viruses have been detected and cleaned. Any use of this e-mail could
harm your computer system. It is your responsibility to ensure that
this e-mail does not contain and is not affected by computer viruses,
defects or interference by third parties or replication problems
(including incompatibility with your computer system).
E-mails sent to and from the Environmental Protection Agency will be
electronically stored, managed and may be audited, in accordance with
the law and Queensland Government Information Standards (IS31, IS38,
IS40, IS41 and IS42) to the extent they are consistent with the law.
___________________________
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
