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