ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Enalbe mail feature for oracle DB.(oracle10G)

Enalbe mail feature for oracle DB.(oracle10G)

原创 Linux操作系统 作者:zzhen163 时间:2010-12-13 11:17:40 0 删除 编辑
a. This step is used to config the email server to send alert email.

    1. Run script. "@?/rdbms/admin/utlmail.sql" at sqlplus prompt.
    2. Run script. "@?/rdbms/admin/prvtmail.plb" at sqlplus prompt.

b. ALTER SYSTEM SET smtp_out_server = 'xxxx.xxx.com';
c. test the email server.
        BEGIN
          sys.utl_mail.send(sender     => 'xxxxx@xxxx.com',
                        recipients => 'xxxxx@xxxxx.com',
                        subject    => 'test',
                        message    => 'test');
        END;
        /
 d. Please run command: GRANT EXECUTE ON UTL_MAIL TO user who will use mail feature; such as
       SQL>GRANT EXECUTE ON UTL_MAIL TO xxxxxx;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/223555/viewspace-681606/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-09-27

  • 博文量
    35
  • 访问量
    64181