Re: Listener Log growth

From: Rajesh Aialavajjala <r.aialavajjala_at_gmail.com>
Date: Fri, 17 Jan 2014 08:41:19 -0500
Message-ID: <CAGvtKv4QcWXxWpZgk4SdfjkN3aO-8=vs5f8F3e50-EzoSjNX_g_at_mail.gmail.com>

Ndidi,
 That is interesting - did Oracle Support give you a Bug # for reference - in terms of the inability of ADR to manage the mentioned log files ?

 You should be able to purge/manage listener and scan_listener logs by using the "set base" and "set home" commands inside adrci

Copied from
http://martincarstenbach.wordpress.com/2010/06/16/where-are-the-logs-for-the-scan-listeners/

[grid_at_rac11gr2node2 ~]$ adrci

ADRCI: Release 11.2.0.1.0 - Production on Wed Jun 16 20:58:17 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

ADR base = "/u01/app/oracle"
adrci> set base /u01/app/grid/product/11.2.0/crs/log adrci> show home
ADR Homes:

diag/tnslsnr/rac11gr2node2/listener_scan1
diag/tnslsnr/rac11gr2node2/listener_scan3
diag/tnslsnr/rac11gr2node2/listener_scan2

adrci> set home diag/tnslsnr/rac11gr2node2/listener_scan1

Alternatively you may look at the steps outlined in "Diagnostic Destination For Listeners Is Under Grid_home/Log Instead Of Oracle_base/Diag (Doc ID 1269109.1)"

I'd used the former method w/ success in an environment that was running the same versions as yours - it did help that we had role separation so my fix was to have 2 "listener logtrim" scripts in place...

Thanks,

--Rajesh

On Fri, Jan 17, 2014 at 7:43 AM, Ndidi Ibeachum <chinedui_at_live.co.uk> wrote:

> Oracle Ver. 11.2.0.3 (RAC)
> RHEL 5 -x86-64
>
> Dear Listers;
>
> I use ADR which is quite helpful but it does not manage certain log files
> with these the listener and scan_listener logs being the exception.
> Checking with oracle support, they admit that it wont work and is being
> treated as a bug.
>
> Setting the log_file for the lsnrctl console to rename the log file will
> not work with ADR enabled and
> neither renaming the file or moving it does the job without some hiccups.
>
> Its like circular mayhem; To be (ADR) or not to be (Manually).
>
> What then could be a good approach for handling listener and scan_listener
> log growth?
>
> Your opinions would be appreciated.
>
> Thanks in advance.
>

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

Received on Fri Jan 17 2014 - 14:41:19 CET