Ferhat's Blog

There will be only one database

Combine dcli and adrci in order to monitor exadata logs 1

Posted by fsengonul on November 15, 2010

When I complained about the number of log files in exadata, one of my old managers said “look into all of them, what is your job?”.  When someone uses the phrase “What is your job, do it”, you can be sure that he has become a manager.

Any way , I have 8 nodes and planning to add 8 more. Just on the db side I’ll be dealing with 32 log files(rdbms+asm). Support Workbench is not working on our 10g grid.  So I’ve to find my own way to deal with alert logs.

Let’s start with the great dcli tool which enables us to send commands to all of the nodes.

alias d=’dcli -g dbs_group -l oracle’      #did I mentioned that I like shortcuts?

alias ardbms=’d “. .bash_profile;adrci exec=\”set homepath diag/rdbms;show incident -orderby create_time dsc -last 1\”” | grep ORA’

##.bash_profile is not executed when called on ssh pubkey authentication. I have to set homepath to differ  ASM log and RDBMS log.

alias aasm=’d “. .bash_profile;adrci exec=\”set homepath diag/asm;show incident -orderby create_time dsc -last 1\”” | grep ORA’

And the results:

oracle@exa01:/home/oracle>ardbms
exa01: 521262               ORA 600 [kghGetHpSz1] 2010-11-05 20:09:15.653000 +02:00
exa02: 360947               ORA 7445 [kdddrp()+4490]          2010-11-05 20:09:13.617000 +02:00
exa03: 421426               ORA 600 [17114] 2010-11-05 19:38:12.011000 +02:00
exa04: 380831               ORA 600 [kghGetHpSz1] 2010-11-05 20:09:15.178000 +02:00
exa05: 340958               ORA 7445 [kdddrp()+4490]          2010-11-05 20:09:13.622000 +02:00
exa06: 421002               ORA 600 [17114] 2010-11-05 20:09:10.340000 +02:00
exa07: 420902               ORA 600 [kghGetHpSz1] 2010-11-05 20:09:15.290000 +02:00
exa08: 401024               ORA 600 [kghGetHpSz1] 2010-11-05 20:09:15.752000 +02:00
oracle@exa01:/home/oracle>aasm
exa01: 283206               ORA 600 [kfdAuDealloc2]                                     2010-10-09 03:33:30.213000 +03:00
exa02: 201846               ORA 600 [kfdAuDealloc2]                                     2010-10-25 10:44:29.577000 +03:00
exa03: 209532               ORA 600 [kfdAuDealloc2]                                     2010-10-08 07:19:47.167000 +03:00
exa04: 169206               ORA 600 [kfdAuDealloc2]                                     2010-10-08 05:31:59.524000 +03:00
exa05: 218297               ORA 603                                                    2010-10-25 10:44:26.094000 +03:00
exa06: 193544               ORA 600 [kfdAuDealloc2]                                     2010-10-02 01:40:26.776000 +03:00
exa07: 225713               ORA 600 [kfdAuDealloc2]                                     2010-10-08 22:44:54.792000 +03:00
exa08: 169570               ORA 600 [kfdAuDealloc2]                                     2010-10-05 23:41:12.890000 +03:00
oracle@exa01:/home/oracle>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: