How To Change e-mail Alert Settings on Exadata database servers and cell servers

Firstly, check Exadata database servers mail configurations. If you can write dbmcli command ,you will see a configuration like this output.

[root@exadbnode1 ~]# dbmcli

DBMCLI> list dbserver detail
         name:                   exadbnode1
         coreCount:              192/192
         cpuCount:               384/384
         diagHistoryDays:        7
         fanCount:               12/12
         fanStatus:              normal
         httpsAccess:            ALL
         id:                     
         ilomIpAddress:          
         interconnectCount:      2
         interconnect1:          re0
         interconnect2:          re1
         ipaddress1:             
         ipaddress2:             
         kernelVersion:          5.4.17-2136.322.6.5.el8uek.x86_64
         locatorLEDStatus:       off
         makeModel:              
         managementIpAddress:    
         metricFGCollIntvlInSec: 0
         metricHistoryDays:      7
         metricStreamEndPoint:  
         metricStreamIntvlInSec: 60
         msVersion:              OSS_23.1.16.0.0_LINUX.X64_240710
         notificationMethod:     mail,snmp
         notificationPolicy:     critical,warning,clear
         powerCount:             2/2
         powerStatus:            normal
         releaseImageStatus:     success
         releaseTrackingBug:     36809713
         releaseVersion:         23.1.16.0.0.240710
         rpmVersion:             23.1.16.0.0.240710
         smtpFrom:               exadbnode1
         smtpFromAddr:           relay365@test.com
         smtpPort:               25
         smtpServer:             smtp.office365.com
         smtpStartTLS:           TRUE
         smtpToAddr:             senderoracle@test.com
         smtpUseSSL:             FALSE
         snmpSubscriber:         host=exadbnodedb01.test.local,port=3872,snmpUser=localSnmpUser,type=v3
                                 host=exadbnodedb02.test.local,port=3872,snmpUser=localSnmpUser,type=v3
                                 host=129.2.4.20,port=1162,community=public,type=asr,asrmPort=16161
                                 host=exadbnodedb01.test.local,port=3872,snmpUser=localSnmpUser,type=v3ASR,asrmPort=16161
                                 host=exadbnodedb02.test.local,port=3872,snmpUser=localSnmpUser,type=v3ASR,asrmPort=16161
                                 host=129.2.45.33,port=162,snmpUser=orarom,type=V3ASR,asrmPort=8234
         snmpUser:               name=localSnmpUser, authProtocol=SHA, privProtocol=AES
                                 name=orarom, authProtocol=SHA, privProtocol=AES
         status:                 online
         temperatureReading:     33.625
         temperatureStatus:      normal
         upTime:                 
         msStatus:               running
         rsStatus:               running

Now change mail configuration. In this example we change smtp relay settings.

DBMCLI> ALTER DBSERVER smtpServer='test-com.mail.protection.outlook.com',smtpFromAddr='senderoracle@test.com',smtpFrom='Oracle Exadata Database Machine',smtpToAddr='senderoracle@test.com',notificationPolicy='critical,warning,clear',smtpUseSSL='TRUE',smtpPort=25,notificationMethod='mail,snmp';

Send test mail.

DBMCLI> alter dbserver validate mail
DBServer exadbnode1 successfully altered

STORAGE SERVER (CELLS)

Now connect exadata cell node and check configuration.

[root@exadbnode1 ~]# ssh exadbnode1celadm01

[root@exadbnode1celadm01 ~]# cellcli

CellCLI> list cell detail
         name:                   exadbnode1celadm01
         accessLevelPerm:        remoteLoginEnabled
         bootDeviceStatus:       normal
         cellVersion:            OSS_23.1.16.0.0_LINUX.X64_240710
         cpuCount:               128/128
         diagHistoryDays:        7
         doNotServiceLEDStatus:  off
         fanCount:               12/12
         fanStatus:              normal
         flashCacheMode:         WriteBack
         httpsAccess:            ALL
         id:                     
         ilomIpAddress:          
         interconnectCount:      2
         interconnect1:          re0
         interconnect2:          re1
         iormBoost:              10.9
         ipaddress1:             
         ipaddress2:             
         kernelVersion:          5.4.17-2136.322.6.5.el8uek.x86_64
         locatorLEDStatus:       off
         makeModel:              
         managementIpAddress:    
         memoryGB:               1512
         metricFGCollIntvlInSec: 0
         metricHistoryDays:      7
         metricStreamEndPoint:  
         metricStreamIntvlInSec: 60
         notificationMethod:     mail,snmp
         notificationPolicy:     critical,warning,clear
         offloadGroupEvents:    
         powerCount:             2/2
         powerStatus:            normal
         releaseImageStatus:     success
         releaseVersion:         23.1.16.0.0.240710
         rpmVersion:             cell-23.1.16.0.0_LINUX.X64_240710-1.x86_64
         releaseTrackingBug:     36809713
         rollbackVersion:        23.1.9.0.0.231215.1
         smtpFrom:               exadbnode1celadm01
         smtpFromAddr:           relay365@test.com
         smtpPort:               25
         smtpServer:             smtp.office365.com
         smtpStartTLS:           TRUE
         smtpToAddr:             senderoracle@test.com
         smtpUseSSL:             FALSE
         snmpSubscriber:         host=exadbnodedb01.test.local,port=3872,snmpUser=localSnmpUser,type=v3
                                 host=exadbnodedb02.test.local,port=3872,snmpUser=localSnmpUser,type=v3
                                 host=129.2.4.20,port=162,community=public,type=asr,asrmPort=16161
                                 host=129.2.45.33,port=162,snmpUser=orarom,type=V3ASR,asrmPort=8234
         snmpUser:               name=localSnmpUser, authProtocol=SHA, privProtocol=AES
                                 name=orarom, authProtocol=SHA, privProtocol=AES
         status:                 online
         temperatureReading:     27.0
         temperatureStatus:      normal
         upTime:                 
         cellsrvStatus:          running
         msStatus:               running
         rsStatus:               running

DBMCLI> ALTER CELL smtpServer='test-com.mail.protection.outlook.com',smtpFromAddr='senderoracle@test.com',smtpFrom='exadbnode1celadm01',smtpToAddr='senderoracle@test.com',notificationPolicy='critical,warning,clear',smtpUseSSL='TRUE',smtpPort=25,notificationMethod='mail,snmp';

DBMCLI> ALTER CELL VALIDATE mail
Cell exadbnode1celadm01 successfully altered