Re: ADRCI

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Fri, 15 Jan 2016 22:46:41 +0530
Message-ID: <CAABGLuKaWauOVA-9AAbcX7dhq59+LSyR1G9Y72t5eUMPR0Y+hg_at_mail.gmail.com>

I use SQL Query for same information to avoid using various utilities. Here is the query below.
Again if you are looking only from ADRCI then like above Rajest mentioned.

col ORIGINATING_TIMESTAMP for a40
col MESSAGE_TEXT for a80
set linesize 500
SELECT
originating_timestamp,
message_text
FROM
sys.x$dbgalertext
WHERE
message_text LIKE '%&Text%';

Thank You.

On Fri, Jan 15, 2016 at 10:32 PM, Rajesh Aialavajjala < r.aialavajjala_at_gmail.com> wrote:

> Woody,
>
> Don Seiler (a frequent contributor to this list) had this example in
> http://www.nocoug.org/download/2011-08/Seiler_Pythian_Learning_to_Love_the_ADR.pdf
>
> "show alert -p "message_text like '%ORA%' and originating_timestamp >=
> systimestamp-30" -term" indicating you can use "AND" in adrci...
>
> Thanks,
>
> --Rajesh
>
> On Fri, Jan 15, 2016 at 11:59 AM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
>> The doc is terrible in this case. I had to figure this one out myself.
>>
>> show alert -p "MESSAGE_TEXT LIKE 'ORA-%' and ORIGINATING_TIMESTAMP >
>> systimestamp - 1"
>>
>> Seth Miller
>>
>> On Fri, Jan 15, 2016 at 10:28 AM, Woody McKay <woody.mckay_at_gmail.com>
>> wrote:
>>
>>> Hi, (12.1.0.2 in win64)
>>>
>>> Does anyone have an example of using adrci to view ORA- errors after a
>>> specific date/time?
>>>
>>> I have a good command for seeing all ORA- errors in the alert log, but
>>> would like to check it after a specific data and time. The docs don't show
>>> if AND or OR can be used for two predicates
>>>
>>> adrci> show alert -p "MESSAGE_TEXT LIKE 'ORA-%'"
>>>
>>> Was wondering if somehow I can add -p originating_timestamp or something
>>> like that.
>>>
>>> My overall goal is to monitor the DB alert log for ORA- errors and send
>>> a notification on new errors. I started a perl, but got excited when I saw
>>> ADRCI. OEM cost more than leadership will spend.
>>>
>>> Thoughts?
>>>
>>> --
>>> Sincerely,
>>>
>>> Woody
>>>
>>
>>
>

-- 
Nassyam Basha.
*Oracle Database Consultant*| *Pythian * <http://www.pythian.com/>
[image: ACED Profile]
<https://apex.oracle.com/pls/apex/f?p=19297:4:::NO:4:P4_ID:13140>
Oracle 11g Certified Master
<http://education.oracle.com/education/otn/NassyamBasha.htm>
Co-Author: Oracle Data Guard 11gR2
<http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900>
Co-founder of Oraworld-team <http://www.oraworld-team.com>

[image: Facebook] <https://www.facebook.com/nassyambasha>  [image: Twitter]
<https://twitter.com/oracle_ckpt>  [image: LinkedIn]
<https://in.linkedin.com/in/nassyambasha>  [image: Google +]
<https://plus.google.com/+NassyamBasha>   [image: CKPT Blog]
<http://www.oracle-ckpt.com/>
<https://www.facebook.com/nassyambasha>

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

Received on Fri Jan 15 2016 - 18:16:41 CET