Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Cellcli can be used to change e-mail alert settings on cell servers.
To find out the current situation:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | CellCLI> list cell detail ......... notificationMethod: mail notificationPolicy: critical,warning,clear ......... smtpFrom: "Oracle Database Machine" smtpFromAddr: exadata@company.com smtpPort: 25 smtpPwd: ****** smtpServer: 192.168.1.10 smtpUser: exadata smtpUseSSL: FALSE ..... |
To change:
1 2 3 4 5 6 7 | CellCLI> ALTER CELL smtpServer='192.168.1.20', - smtpFrom='Company Oracle Support', - smtpPwd='new_password', - notificationPolicy='critical,warning,clear', - notificationMethod='mail,snmp' |
To test:
1 2 | CellCLI> ALTER CELL VALIDATE mail Cell orclcel01 successfully altered |
If there is an email with the subject “CELL orclcel01 Test Message” after the test, it means no problem.
To close alert emails:
1 | CellCLI>alter cell notificationMethod=null |
To open alert emails:
1 | CellCLI>alter cell notificationMethod='mail,snmp' |
1 | CellCLI>alter cell notificationMethod='mail' |
