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
