Re: Cannot set listener status to off to archive file

fitzjarrell_at_cox.net wrote:
> Massa Batheli wrote:
> > oracle_at_dev1 /opt/app/oracle/product/8.1.7/network/log >lsnrctl set
> > log_status nbodevd2 off;
> >
> > LSNRCTL for HPUX: Version 8.1.7.0.0 - Production on 11-DEC-2006
> > 11:56:12
> >
> > (c) Copyright 1998 Oracle Corporation. All rights reserved.
> >
> > NL-00857: wrong number (0 - 1 needed) of arguments to "log_status"
> > oracle_at_dev1 /opt/app/oracle/product/8.1.7/network/log >
> >
> >
> >
> > Massa Batheli wrote:
> > > Thanks
> > > I will send the exact error and a cut and paste of the command.
> > > The file has become 2G large and I am exploring the possibility of
> > > having one file a year.
> > >
> > > Thanks
> > > Massa
>
>
> You can't use SET from the command line as you're attempting to do:
>
> oracle_at_dev1 /opt/app/oracle/product/8.1.7/network/log >lsnrctl
>
> LSNRCTL for HPUX: Version 8.1.7.0.0 - Production on 11-DEC-2006
> 11:56:12
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> LSNRCTL> set log_status nbodevd2 off
>
>
> The above should do what you're expecting.
>

Massa you can set it up something like this ...

#!/bin/ksh
. /somefile/to_setup/your_environment

lsnrctl << EOF
set log_status somename off
exit
EOF Password protection for listener is also recommended. I don't remember if this is supported in 8.1.7 ( I think so but ? ). Received on Mon Dec 11 2006 - 13:55:05 CST