Re: lsnrctl set log_status off doesn't work for a nmaed listener
Date: Mon, 18 May 2015 14:09:59 -0400
Message-ID: <CAGvtKv5AE4OjzhYpqgUSVwTQOEuhrxHws3Bmi-ubZsexWM8Bow_at_mail.gmail.com>
Ashoke,
logrotate is not an oracle supplied tool...the 'logrotate' command is not available on Solaris, but there is a Solaris equivalent, called 'logadm,' described here in the documentation:
http://docs.oracle.com/cd/E23823_01/html/817-0403/emcby.html
Thanks,
--Rajesh
On Mon, May 18, 2015 at 12:59 PM, Mandal, Ashoke < ashoke.k.mandal_at_medtronic.com> wrote:
> Hi Rajesh/Hans/Mladen,
>
>
>
> Thanks for the tips. I am reading the documentations and will follow
> accordingly.
>
> I have never used logrotate utility. Is it an oracle supplied tool or UNIX
> tool? Could you send the information on how to use it on Oracle Solaris 10
> server.
>
>
>
> Ashoke
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Rajesh Aialavajjala
> *Sent:* Wednesday, May 13, 2015 4:36 PM
> *To:* fuzzy.graybeard_at_gmail.com
> *Cc:* ORACLE-L (oracle-l_at_freelists.org)
>
> *Subject:* Re: lsnrctl set log_status off doesn't work for a nmaed
> listener
>
>
>
> Ashoke,
>
>
>
> To add to what Hans posted..you can find syntax and examples using named
> listeners in the following MOS documents...
>
>
>
> *How to Disable Logging to the Sqlnet.log and the Listener.log (Doc ID
> 162675.1)*
>
> *How to Rotate or Purge Listener Log Data to Avoid Large listener.log
> File? (Doc ID 1457196.1)*
>
> *Description and Usage of the ADMIN_RESTRICTIONS_<listener_name> Parameter
> (Doc ID 272633.1)*
>
>
>
> Thanks,
>
>
>
> --Rajesh
>
>
>
> On Wed, May 13, 2015 at 5:28 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com>
> wrote:
>
> I know the documentation is difficult to find (http://docs.oracle.com ->
> Database -> All Database Documentation -> all Oracle Database books -> Net
> Services Reference) so here is a direct link to that setting, including an
> explanation.
> http://docs.oracle.com/database/121/NETRF/lsnrctl.htm#NETRF119
>
> /Hans
>
>
>
> On 13/05/2015 1:10 PM, Mandal, Ashoke wrote:
>
> Hello Mladen, Thanks for the tips. I will try to use the korn shell. But
> could you help me in understanding the following syntax.
>
>
>
>
>
> The syntax for disabling log_status of a default listener(LISTENER):
>
> lsnrctl set log_status off
>
>
>
> Could you please let me know what is the syntax for disabling log_status
> of an named listener (e.g listener_phx09db1)
>
> lsnrctl set log_status off listener_phx09db1 -> This doesn’t work
>
>
>
> Ashoke
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Mladen Gogala
> *Sent:* Wednesday, May 13, 2015 12:52 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: lsnrctl set log_status off doesn't work for a nmaed
> listener
>
>
>
> - You don't have to stop logging to remove the logs. Just remove it.
> Just do it.
> - There is a utility called "logrotate" which was written for just
> such things.
> - Don't start your script with "#!/bin/csh". That is a very grave
> style error. Scripts are started by "#!/usr/bin/env perl" or
> "#!/usr/bin/perl -w". C-shell is a nightmare from the past that should be
> forgotten, especially on Solaris which supports both logrotate and the full
> complement of modern shells, like bash and zsh. Even the old-fashioned
> Korn-shell is far better than C-shell monstrosity.
> - There is "ardrci" utility which supports "purge" command. I have
> never used it on listener.log since logrotate completely satisfies my needs
> as far as listener.log is concerned, but it works great on the RDBMS homes
> and even allows you clean traces, cores and log entries automatically.
> - Did I forget to tell you never to use C-shell?
>
>
>
> On 05/12/2015 05:09 PM, Mandal, Ashoke wrote:
>
> Hello,
>
>
>
> I am trying to recycle the listener.log for the listener on the database
> server using cshell script but it is not working for me. Any help is
> highly appreciated.
>
>
>
> Thanks,
>
> Ashoke
>
> *The crontab entry: *
>
> #Delete the old files from adump, bdump, cdump, udump and recycle the
> listener log.
>
> 0 5 * * 0
> /admin/install/dmas/shell_scripts/cleanup/oracle_clean_dmas_server.csh
> tlwdmas phx09db1 > /dev/null 2>&1
>
> oracle_clean_dmas_server.csh <db_name> <virtual_server_name>
>
>
>
> *The content of the oracle_clean_dmas_server.csh script:*
>
>
>
> #!/bin/csh -v
>
>
>
> setenv ORACLE_SID $1
>
> setenv SERVER $2
>
> setenv ORAENV_ASK NO
>
> . /usr/local/bin/coraenv
>
>
>
> cd $ORACLE_HOME/network/log
>
> lsnrctl set CURRENT_LISTENER listener_$SERVER
>
> lsnrctl set log_status off
>
> mv listener_$SERVER.log listener_$SERVER.old
>
> lsnrctl set log_status on
>
>
>
>
>
> *The errors:*
>
> cd $ORACLE_HOME/network/log
>
> lsnrctl set CURRENT_LISTENER listener_$SERVER
>
>
>
> LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 12-MAY-2015
> 13:47:01
>
>
>
> Copyright (c) 1991, 2011, Oracle. All rights reserved.
>
>
>
> Current Listener is listener_phx09db1
>
> lsnrctl set log_status off
>
>
>
> LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 12-MAY-2015
> 13:47:01
>
>
>
> Copyright (c) 1991, 2011, Oracle. All rights reserved.
>
>
>
> Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
>
> TNS-12541: TNS:no listener
>
> TNS-12560: TNS:protocol adapter error
>
> TNS-00511: No listener
>
> Solaris Error: 146: Connection refused
>
> mv listener_$SERVER.log listener_$SERVER.old
>
> mv: cannot access listener_phx09db1.log
>
>
>
> lsnrctl set log_status on
>
> LSNRCTL for Solaris: Version 11.2.0.3.0 - Production on 12-MAY-2015
> 13:37:11
>
>
>
> Copyright (c) 1991, 2011, Oracle. All rights reserved.
>
>
>
> Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
>
> TNS-12541: TNS:no listener
>
> TNS-12560: TNS:protocol adapter error
>
> TNS-00511: No listener
>
> Solaris Error: 146: Connection refused
>
>
>
>
>
>
>
> [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email
> is proprietary to Medtronic and is intended for use only by the individual
> or entity to which it is addressed, and may contain information that is
> private, privileged, confidential or exempt from disclosure under
> applicable law. If you are not the intended recipient or it appears that
> this mail has been forwarded to you without proper authority, you are
> notified that any use or dissemination of this information in any manner is
> strictly prohibited. In such cases, please delete this mail from your
> records. To view this notice in other languages you can either select the
> following link or manually copy and paste the link into the address bar of
> a web browser: http://emaildisclaimer.medtronic.com
>
>
>
> --
>
> Mladen Gogala
>
> Oracle DBA
>
> http://mgogala.freehostia.com
>
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 18 2015 - 20:09:59 CEST