EXADATA 监控手册资料

EXADATA监控手册

CDQAUy

文档控制

变更记录

日期作者版本号变更参考文件

审阅

姓名职位

发行

拷贝号姓名地址

0录

SMTP配置方法3

1.1数据库SMTP配置方法.........................................................................3

1.1.1定义SMTP服务器.........................................................................3

1.1.2测试SMTP服务器.........................................................................4

1.1.3设置接收邮件的E-mail地址................................................................4

1.1.4Alert的维护..............................................................................5

1.2存储服务器SMTP配置方法.....................................................................7

2SNMP配置方法.............................................................................9

2.1数据库SNMP配置方法.........................................................................9

2.2存储服务器SNMP配置方法....................................................................10

2.3硬件SNMP配置方法..........................................................................10

1SMTP配置方法

1.1数据库SMTP配置方法

1.1.1定义SMTP服务器

以sysman用户登录EMconsole,点击右上角setup选项卡，然后选择Notificatior

Methods选项卡，显示配置界面如下：

OQACLGEnterpriseManager、$*><吐

GridControl11g_____________________________________________HomeTarpeisDeplosmemsa-rtsComplianceJobsReponsMyOracleSuppon

EnterpriseFanaoerConflQuratlon|METJ(切对七SemesardReporter

OvecvgwofNotificationMethods

RotesWDtifcmcn^tethoclsafcwyoutoobbaiydefredrffemmechEntsmsforsenct^anotrtcattons.Thesenebdee^nai,SNKPtrapsardrurmgcustomsapts.Cnee

defiedJLUfcatKnMethodsareusedbyNotjftcationRUestosendMftcatmstoadmrtstratasfcraferts.pofcyvtoUttcnscr灿statuscharges.Eachadiw«tiMo(

h«NototkatonRUe$dHntd«iprofom。.

itiflcattonMaMServer

pthods

Enttrcri»Mr^gtrroqur«$thaktowtighlcrmationto$«nderniirotiffc4ticn$bymwn$offtottftutcnRute$.Wxnx»cifyngrrUbcfe.Rten/.App%

SMTPservers,separ^ee«hsewbyacommaorspace.、TwMailServersj

E-rr^Custofn^Kyi

PjtcNxiStvoQjtQcrqMai(SVTTP)Sen*ef|

.・th>任rat$taVE-QC4^YQE*”d♦:SMYPlSt力Pwl21itut*1,nopc«tQtp*of»dfar讣.xtrtt.0EiarrfJ»:SMTPLMyS«rvw4tT),

Et^koutsUserName「

RecKtnM例的f5H.SMTP田.”—mH.，乂XfS.

P必桢心Password「

金・Qfy讣・TJcarm7pauwwiwlMuiwlfo*alSMTPiwm.

ManagementPack

ConftmPMSword|

MCSS

BdenwySencfefAs|

McrMtodnaTemoiares

Sender'sE-cnalActoress|-

CarecSwAction

上3,UseSeareCem9cgO

「US,ifavMiblo

ManaoefnecuFluxns「SSL

axrecw

ScriptsandS、MPTraps

DasErchanoe

BeforeEnterprMriagcronwrdnottkjtixnbymwn$ofOScomcnndi,K/SQlcroceckw.orSMMPtrw,theymuttfirstgdefned第NoWkatdn

CtentSvstgrnMetkxB.AdrrrtstratorscantheiusethesemethodsrMDOficatcnRutes.

An^vzernGrtdAdd|0SCcm(T«Td3，G。)

ControlNameTypeSupportRepeatNotifications

MnnnttfirArinnmafhndcinMYI

«TIPRemecrtetoaeateNotrftagRUesncrcfeftosendnotifcatfcns3meansoftheserrethods.

RepeatNotifkations

RepeatnotAzatons^owyoutobenotifiedrepeated^atxxitth©samemetricoravaUbity曲tCneeenabled,youneedtochooseth©Roceat

WOftcatxmscptxxinftoticatonRUsthatwluseit.Ifyouds^bterepeatnotticatonscnthtspw,MrepeatnoSc秋msMstop.

「SendRepeatNotA:ation$

RepeatFrequency(mnutes)[15-

MaxmunRepeat^toWkatons后~

htoro|Yarogts|PadcriTnerrs|Nects|CcmduyKR|jobs|Reoats|QradeSuccat|Setup|H©回ences|Heto|Logout

©IE,2910.QntkW勿n

gkB>2冲2</OrKkftWHxs

O*«rhMiesMyU**dtmM*iWt>«br仆但6”CMMMA.

AhmitOartAFnt«r»KPMsraosrL

具体配置示例如下:

OutgoingMail(SMTP)Server-smtpOl.mycorp.com:587,smtp02.mycorp.coni

UserName-myadmin

Password-******

ConfirmPassword-******

IdentifySenderAs-EnterpriseManager

Sender*sE-mailAddress-mgmt_rep@mycorp.com

UseSecureConnection-No:E-mai1isnotencrypted.

1.1.2测试SMTP服务器

SMTP服务器配置结束后，点击TestMailServers效验，确认收到由上节Sender's

E-mailAddress定义邮件地址发出的信息。

1.1.3设置接收邮件的E-mail地址

以sysman用户登录EMconsole,点击右上角Preferences选项卡，显示配置界面如卜:

ORACL.G'EnterpriseManager11gSotupRotafscxoaHdpUxuit

DatabaseControlDatabase

Preferences

General

Password

ChangingtheSfSMANuserpasswordrequiresaspecaloperationwhichGdesertedintheOracleEnterprbeManager

E-mailAddresses

TheseaddressesareusedtosendrKMifcationstoyou.YoucanspectymulipteaddressesifyouwanttobenoWedin

clfferentways,andtheformattouseforeachaddress.Lateron.youwilneedtodefineaNotifcatioaSchedulebeforetny

e-mainotifcaticoscanbesenttoyou.

SelectE-mailAddressMessageFormat

Noe-mailaddressesspeciied

AddAnotherRow)

点击AddAnotherRow选项卡，在E-mailAddresses柩中添加接收警告信息的邮箱地

址，可以选择多个地址。

完成以上配置后，各种数据库alert将会发送到已配置邮件中。

1.1.4Alert的维护

1.查看MetricsandThresholds

以sysman登录主面，点击AllMetrics链接,界面如下:

AllMetrics

CollectedFrcmTargetJun23,200912:19:28PMPOT毫

ExpandAllICollapseAll

Collection

MetiicsThiesholdsScheduleUploadInteivalLastUpload

Vem112

AArchiveAreaSomeEvery15MinutesEveryCollectionJun23.200912:19:16PM

ADataFailureSomeEvery5MinutesEveryCollection-

►DatabaseFilesNoneServerGeneratedServerGeneratedServerGenerated

ADatabaseJobStatusAllEvery5MinutesOnAlertJun23,200910:55:43AM

ADatabaseLimitsSomeServerGeneratedServerGeneratedServerGenerated

ADatabaseReplayNoneReal-timeOnlyn/an/a

ADatabaseReplayClientNoneServerGeneratedServerGenerated-

ADatabaseServicesNoneServerGeneratedServerGeneratedServerGenerated

ADatabaseVaultAttemptedNoneEvery1HourOnAlert-

Violations-CommandRules

ADatabaseVaultAttemptedNoneEvery1HourOnAlert-

Violations-Realms

ADatabaseVaultConfigurationAJIEvery1HourEveryCollection-

Issues-CommandRules

ADatabaseVaultConfigurationAllEvery1HourEveryCollection-

Issues-Realms

ADatabaseVaultPolicyChangesAllEvery1HourEveryCollection-

ADeferredTransactionsAJIEvery5MinutesOnAlertJun23.200910:55.19AM

►DumpAreaSomeEvery15MinutesEveryCollectionJun23.200912:1916PM

t>EfficiencyNoneServerGeneratedServerGeneratedServerGenerated

►FailedLoginsAJIEvery30MinutesEveryCollectionJun23.200911:32:；4AM

2.设置MetricsandThresholds

点击MetricandPolicySettings,可以设置警告和危急的阀值，当超过阀值时

可以显示在主页的Alert栏，界面如下：

MetricandPolicySettings

、Cancel-、OK)

MetricThresholdsPolicies

ViewMetricswiththresholds回

ComparisonWarningCriticalCollectiveCollection

MetiicOpeiatorThiesholdThieshohlActionsSchedule

L

AccessViolationMatchesNoneEvery5Minutes

AccessViolationStatus>bNoneEvery5Minutes

ArchiveAreaUsed(%)>80NoneEvery15Minutes

*

ArchiverHungMatchesNoneEvery5Minutes

ArchiverHungStatus>0NoneEvery5Minutes

AuditedUser=SYSNoneEvery15Minutes

AverageUsersWaitingCount

Administrative>ioNone

Application>10None

|30

Cluster>None

Commit>30None

VAlerts

CategoryAllv、GojCriticalx1Warning44

Alert

Seveiity~CateqoiyN«)meImpactTiicjcjeied

XIncidentGenericInternalInlernalerror(ORA-600I157QjndeiacledSep9.2JO9

Errorin/U31/app/oracle/dia^/rdbrns/test/tesValerVlogxmlattime/hnenumberWedSeo912:27:48PM

1227222009)8777

ResponseUserLogonTimeUserlogontimeis687937m§ec$Sep9.2X0

(msec)801:32PM

UserAuditAuditedUserUwSYSloqqodonfrom【acnode2.@Sep3,2309

3:49:42PM

TablespacesTablespaceTablssoaceTESTMSSMNEWis86BsrcenlfullSep8.2X0

FullSpaceUsed(%)12:18:11PM

TablespacesTablespaceTablespaceTEST_/\SSMis87percentfullSep8.2309

FullSpaceUsed(%)1218:11PM

1.2存储服务器SMTP配置方法

在标准EXADATA安装过程中，现场售后工程师都会按照用户要求，使用onecommand完

成存储服务器SMTP的配置.如果需要变更SMTP配置，可以使用cellcli命令更改，但

是存储服务器的任何变更，建议由ORACLE售后工程师完成。

在各节点以cclladmin用户登录，执行如下命令:

cellcli-eALTERCELLsmtpServer=\，ntbexslO\,,smtpPort=\，25\*,

smtpUser=\，,smtpPwd=\，,

smtpUseSSL=false,smtpFrom=\，exadatamachine、’，

smtpFromAddr=\，exadata@abc.com\，,

smtpToAddr=\，zhoujm@abc.com,luye@abc.com,gefei@abc.com\，,

notificationMcthod=\，mail\，,

notificationPolicy=\*critical,warning,clear、'

说明：

当notificationPolicy设为critical时，发送硬件产生的警报或自动诊断库（ADR）

或BMC生成的警报。同时也可以在值超过定义的临界阈值时发送警报。

当notificationPolicy设为warning时，如果值超过了定义的警告阈值时发送警报。

当notificationPolicy设为clear时，如果值低于阈值，并且超过warning或critical

的边界，则发生警报。

具体配置请参见：《ExadalaStorageServerSoftwareUser,sGuide.pdf^

2SNMP配置方法

2.1数据库SNMP配置方法

以sysman用户登录EMconsole,点击右上角setup选项卡，然后选择Notification

Methods选项卜，显示配置界面如下：

STIPMetricseverityintormatbnwillbepassedasaone-hnemessageintheSNMPtrap.R