Re: lsnrctl set log_status off doesn't work for a nmaed listener

https://www.opencsw.org/package/logrotate/

On 05/18/2015 02:09 PM, Rajesh Aialavajjala wrote:
> 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 <mailto: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>
> [mailto: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 <mailto:fuzzy.graybeard_at_gmail.com>
> *Cc:* ORACLE-L (oracle-l_at_freelists.org
> <mailto: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 <mailto: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>
> [mailto: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 <mailto: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
>
>

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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