Ferhat's Blog

There will be only one database

Archive for November, 2010

Turkcell Exadata Podcast

Posted by fsengonul on November 24, 2010

You may listen our exadata podcast from

http://streaming.oracle.com/ebn/podcasts/media/9547030_Turkcell_111810.mp3

 

 

 

Posted in Exadata, oracle | 1 Comment »

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>

Posted in Exadata, linux, oracle | Leave a Comment »

Yet another great TROUG Oracle Day

Posted by fsengonul on November 5, 2010

I had great time in Oracle Day . Had 2 presentations and met great people. The guests on our TROUG activity shows that we have the potential to achieve  everything on our user group. Great days are coming.  Stay tuned.

Below you may also find our exadata presentation in Turkish.

Turkcell Exadata OracleDay_Türkçe

Posted in Uncategorized | 1 Comment »