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