Monitoring database servers for hardware failures in Exadata used to be an issue. We have CELLCLI for storage servers where we can make many administration tasks and set SMTP configuration to receive e-mail for hardware failures. For the DB servers we were able to configure SMTP Client on database server's ILOMs for email alerts but it was not a straightforward and easy configuration as we do in CELLCLI.
With Exadata Storage Server Release 12.1.2.1.0 now we have a new command-line interface called DBMCLI to to configure, monitor, and manage the database servers. Like with the CELLCLI, we can monitor the status of hardware component, stop/start services, set thresholds, list alert history, configure SMTP with DBMCLI.

Detail here:
http://docs.oracle.com/cd/E50790_01/doc/doc.121/e51951/app_dbmcli.htm#DBMMN22053

An example output of "list dbserver detail"

DBMCLI> list dbserver detail
         name:                   dm01dbadm01
         bbuStatus:              normal
         coreCount:              8
         cpuCount:               16
         diagHistoryDays:        7
         fanCount:               16/16
         fanStatus:              normal
         id:                     1323FML0GM
         interconnectCount:      2
         ipaddress1:             192.168.1.1/22
         kernelVersion:          2.6.39-400.248.3.el6uek.x86_64
         locatorLEDStatus:       off
         makeModel:              Oracle Corporation SUN FIRE X4170 M3
         metricHistoryDays:      7
         msVersion:              OSS_12.1.2.1.1_LINUX.X64_150316.2
         powerCount:             2/2
         powerStatus:            normal
         releaseImageStatus:     success
         releaseVersion:         12.1.2.1.1.150316.2
         releaseTrackingBug:     20240049
         status:                 online
         temperatureReading:     22.0
         temperatureStatus:      normal
         upTime:                 62 days, 2:37
         msStatus:               running
         rsStatus:               running


To configure SMTP on database server:

DBMCLI> ALTER DBSERVER smtpServer='mailserver.domain.com', smtpFromAddr='exadata@domain.com', smtpFrom='exadata', smtpToAddr='someone@domain.com,anotherone@domain.com', notificationPolicy='critical,warning,clear', notificationMethod='mail', smtpPort=25, smtpPwd=somepassword, smtpUseSSL=FALSE
DBMCLI> ALTER DBSERVER VALIDATE MAIL
DBServer dm01dbadm01 successfully altered

"list dbserver detail" output after configuring SMTP:

DBMCLI> list dbserver detail
         name:                   dm01dbadm01
         bbuStatus:              normal
         coreCount:              8
         cpuCount:               16
         diagHistoryDays:        7
         emailFormat:            text
         fanCount:               16/16
         fanStatus:              normal
         id:                     1323FML0GM
         interconnectCount:      2
         ipaddress1:             192.168.1.1/22
         kernelVersion:          2.6.39-400.248.3.el6uek.x86_64
         locatorLEDStatus:       off
         makeModel:              Oracle Corporation SUN FIRE X4170 M3
         metricHistoryDays:      7
         msVersion:              OSS_12.1.2.1.1_LINUX.X64_150316.2
         notificationMethod:     mail
         notificationPolicy:     clear
         powerCount:             2/2
         powerStatus:            normal
         releaseImageStatus:     success
         releaseVersion:         12.1.2.1.1.150316.2
         releaseTrackingBug:     20240049
         smtpFrom:               exadata
         smtpFromAddr:           exadata@domain.com
         smtpPort:               25
         smtpPwd:                ******
         smtpServer:             mailserver.domain.com
         smtpToAddr:             someone@domain.com,anotherone@domain.com
         status:                 online
         temperatureReading:     21.0
         temperatureStatus:      normal
         upTime:                 62 days, 3:05
         msStatus:               running
         rsStatus:               running

12 Responses so far.

  1. deeksha says:

    this blog is really interesting and thus it shows many ways to get a good job and it is very much exclusive too.


    Salesforce Training in Chennai Adyar

  2. Sathya G says:


    thank you for sharing such a nice and interesting blog with us. hope it might be much useful for us. keep on updating...
    ROI Services in Chennai

  3. Geetha says:

    Great information shared in this blog. Helps in gaining concepts about new information and concepts.Awsome information provided.Very useful for the beginners.
    android Training in Chennai

  4. sathya says:

    Superb i really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your updation.
    Software Testing Training in Chennai

  5. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.

    Salesforce Training in Chennai

  6. Padhma says:

    Wow really the execution model will clearly explain the concepts. So far we need to know more like this. So please keep update like this.

    Car Wash Services in Mumbai

  7. Jeffy says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information. I would like to suggest your blog in my dude circle. please keep on updates. hope it might be much useful for us. keep on updating...
    seo company in chennai
    Digital Marketing company in chennai

  8. charan says:

    Really awesome content thank you for sharing useful information

    from

    oracle fusion training

  9. Jeffy says:

    Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
    seo company in india
    digital marketing company in india
    seo company in chennai
    digital marketing company in chennai

  10. Shalini says:

    Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Digital Marketing Company in India

  11. sathya says:

    I read this content really awesome.You provided another one great article.I hope this information may change my business carrier.I can remember these things whenever taking the decision.

    Hadoop Training in Chennai

  12. jeslin says:

    It is really a great and useful piece of info. I’m glad that you shared this helpful info with us. Please keep us informed like this. Thank you for sharing.

    Car Spa at Doorstep in Mumbai

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -