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
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
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
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
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
Really awesome content thank you for sharing useful information
from
oracle fusion training
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
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
Thanks for sharing, 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.
oracle fusion financials online training
Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
oracle fusion financials training in Hyderabad
I read this content really awesome.You provided another one great article.
I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.
oracle fusion scm online training
oracle fusion financials online training
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.
Oracle Fusion Financial Online Training
Really thanks for sharing such a wonderful blog.
Oracle Fusion Taleo Online Training
Excellent article. really i am interesting to read this article. thanks for posting this article.
An astounding web diary I visit this blog, it's inconceivably magnificent. Strangely, in this current blog's substance made point of fact and sensible. The substance of information is instructive.
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.
Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery
I have read your blog it is very helpful for me. I want to say thanks to you. I have bookmark your site for future updates. Can you guess how much these celebrities are worth? Test your knowledge with Celebrity net worth.
Amazing Article,Really useful information to all So, I hope you will share more information to be check and share here. if you want Tax consultants in bangalore
GST consultants in bangalore click on it
If you are dealing with digital currencies in some way, the first and most essential step before https://www.golchinonline.ir/index.php/newposts/news/6344-%D8%A8%D8%B1%D8%B1%D8%B3%DB%8C-%D8%A7%D8%B1%D8%B2-%D8%AF%DB%8C%D8%AC%DB%8C%D8%AA%D8%A7%D9%84-%D8%A7%D9%84%D9%88%D9%86.html investing is that you should always research and acquire knowledge before trading a digital currency. Then, as you know, due to fluctuations in capital markets, it is better to use small amounts for investment for less risk.
Kaspersky Anti-Virus features include real-time protection, detection and removal of viruses, trojans, worms, spyware, adware, keyloggers, malicious tools and auto-dialers, as well as detection and removal of rootkits
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
Kaspersky.com/activation
You can download and install norton setup from Norton.com/setup. Norton may receive annual renewal billing, cancellations, refunds, subscriptions, credit card updates, purchases by Norton membership. Visit Norton.com/setup to activate or renew your Norton membership. And a valid Norton membership ensures that your security is always updated. You should activate or renew your subscription before the trial or membership period ends so that all Norton features can continue to be used and your computer is protected. For more information, you can contact our team at Norton.com/setupand get more and more information.
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
Norton.com/setup
با این نکات عالی مراقبت از پوست خود را بیاموزید