Re: 11g Listener Logs

From: Mladen Gogala <gogala.REMOVETHISmladen_at_google.com>
Date: Mon, 23 Apr 2012 17:16:30 +0000 (UTC)
Message-ID: <jn42pe$ppc$1_at_solani.org>

On Mon, 23 Apr 2012 06:17:57 -0700, ExecMan wrote:

> Hi,
>
> I'm trying to find a good way to parse / audit the 11g listener logs.
> In our 10g databases this was pretty simple. A couple of procedures and
> an external table pointing to the log and I can run queries and gather
> stats by the hour, connect counts from different hosts, etc.
>
> But, for 11g with the log being in XML and could be a number of logs,
> I'm not quite sure how to get this accomplished. I've been searching
> around and trying to brainstorm and was looking to see what anyone else
> has done. I'm sure I'm not the first who wants to parse the listener
> log and get stats / counts.
>
> Thanks!

Are you aware of the v$diag_alert_ext table? It also contains the messages for the Oracle*Net home:

SQL> select distinct adr_home from v$diag_alert_ext;

ADR_HOME

---

diag/tnslsnr/dmc125/listener
diag/rdbms/apexdb/apexdb

Then, there is a wonderful new utility called ADRCI. Unfortunately, I have no problems that I can show:

dmc125:oracle>adrci

ADRCI: Release 11.2.0.3.0 - Production on Mon Apr 23 13:13:28 2012

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

ADR base = "/mnt/san-oracle/u01/app/oracle" adrci> set home diag/tnslsnr/dmc125/listener adrci> show problems

ADR Home = /mnt/san-oracle/u01/app/oracle/diag/tnslsnr/dmc125/listener:

---

0 rows fetched

adrci> show incident

ADR Home = /mnt/san-oracle/u01/app/oracle/diag/tnslsnr/dmc125/listener:

---

0 rows fetched

If only Oracle would make some trouble that I could share....

-- 
http://mgogala.freehostia.com

Received on Mon Apr 23 2012 - 12:16:30 CDT