Combine dcli and adrci in order to monitor exadata logs 1

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>

How to open files starting with + (plus) using vi

Oracle names the ASM trace files with the instance name. If you try to open a file whose name starts with + (plus) ,  you cannot use quotes or  escape character.
Instead you have to use -- in order to get rid of options.
vi -- +ASM8_s001_8349.trc