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@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx>
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
