This forum is currently locked. You can't register or post questions at this time. (read more)

Alert log errors occurred in b/w given time duration

All posts relating to Oracle database administration.

Moderator: Tim...

Arunkumar
Member
Posts: 2
Joined: Tue Nov 27, 2012 7:35 pm

Alert log errors occurred in b/w given time duration

Postby Arunkumar » Tue Nov 27, 2012 8:08 pm

Hi,

Need shell script to get Alert log errors that occurred in past 24 hours & also b/w given time duration. I am using (Red Hat 4.1.2) and 11.1.0.7

For example: If we run the script it should prompt me for date/time, it should fetch me the errors occured during that time.

Date:27
Month:Nov
Year:2012
HH:08
MM:20
SS:43
It should fetch me the errors occured at this point of time from the alert log. If there are no errors just display a message "no errors" and display the actual text from alert log at that time as,
NO ERRORS
Actual message:
Tue Nov 27 08:20:43 2012
Archived Log entry 8354 added for thread 1 sequence 2710 ID 0x1ea92ad6 dest 1

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Alert log errors occurred in b/w given time duration

Postby Tim... » Wed Nov 28, 2012 9:04 am

Hi.

Well, I never do this because I use EM (or Grid Control) to report on alter log errors, so I never have to manually parse the file.

If you plan to do this, you should probably use the ADRCLI command SHOW ALERT to output the relevant information.

http://docs.oracle.com/cd/B28359_01/ser ... m#BGBDCIHD

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Arunkumar
Member
Posts: 2
Joined: Tue Nov 27, 2012 7:35 pm

Re: Alert log errors occurred in b/w given time duration

Postby Arunkumar » Wed Nov 28, 2012 7:55 pm

Thanks for the information Tim., will look into the docs... but looks like it will be great if i get a script...

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Alert log errors occurred in b/w given time duration

Postby Tim... » Sun Dec 02, 2012 12:03 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 5 guests

cron