EMN0 and DBMS_AQELM
I need to know what mailserver/port are setup for my Oracle Standard instance for oracle server alert notifications. I see the package DBMS_AQELM allows one to set these values but there is no call for getting currently set values. We have oracle database control off.
The need arise from the fact that I did not receive tablespace pct full alerts and also the process EMN0 is not running. We prefer not to run oracle database control.
Any suggestions for:
1> How to check thoes values for mailserver/port for email notifications?
2> How to make sure EMN0 is up and running all the time?!