连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show parameter job_queNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
SQL> show parameter aqNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
登录:http://lw:1158/em/console/admin
配置邮件警告,配置如下:发件 (SMTP) 服务器 smtp.163.com
将发件人标识为 oracle alert
发件人的电子邮件地址 [email protected]
点击测试邮件服务器后出现如下结果:
smtp.163.com: 测试失败, 返回消息: "Sending failed; nested exception is: javax.mail.MessagingException: 553 authentication is required,smtp5,D9GowLBrwzELuFZLwBdTAg--.34690S2 1263974411 "
C:\Documents and Settings\user>ping smtp.163.comPinging smtp.163.split.netease.com [123.125.50.133] with 32 bytes of data:Reply from 123.125.50.133: bytes=32 time=39ms TTL=47
Reply from 123.125.50.133: bytes=32 time=40ms TTL=47
Reply from 123.125.50.133: bytes=32 time=41ms TTL=47
Reply from 123.125.50.133: bytes=32 time=41ms TTL=47Ping statistics for 123.125.50.133:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 39ms, Maximum = 41ms, Average = 40ms在10g下配置邮件警告,还需要注意些什么呢?跟版本有关系吗?
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show parameter job_queNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
SQL> show parameter aqNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
登录:http://lw:1158/em/console/admin
配置邮件警告,配置如下:发件 (SMTP) 服务器 smtp.163.com
将发件人标识为 oracle alert
发件人的电子邮件地址 [email protected]
点击测试邮件服务器后出现如下结果:
smtp.163.com: 测试失败, 返回消息: "Sending failed; nested exception is: javax.mail.MessagingException: 553 authentication is required,smtp5,D9GowLBrwzELuFZLwBdTAg--.34690S2 1263974411 "
C:\Documents and Settings\user>ping smtp.163.comPinging smtp.163.split.netease.com [123.125.50.133] with 32 bytes of data:Reply from 123.125.50.133: bytes=32 time=39ms TTL=47
Reply from 123.125.50.133: bytes=32 time=40ms TTL=47
Reply from 123.125.50.133: bytes=32 time=41ms TTL=47
Reply from 123.125.50.133: bytes=32 time=41ms TTL=47Ping statistics for 123.125.50.133:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 39ms, Maximum = 41ms, Average = 40ms在10g下配置邮件警告,还需要注意些什么呢?跟版本有关系吗?
解决方案 »
- 请教10g rac性能问题
- 如何减小表空间大小?
- 在type body中,动态SQL如何使用
- 问个小白的问题 有了plsql developer 还用得着sqlplus吗?
- 请教:oracle备份成sql格式文件用的是什么命令?
- 忘记一条sql怎么写了,大概的意思如下
- 为什么在创建数据链时系统会自动在数据联名的后面加上".us.oracle.com"的后缀呢?
- sqlserver的@@IDENTITY在oracle中怎样实现?
- 怎么保证查询数据正确呢?
- oracle字符号集的问题,为什么在win2000上用client上的sqlplus选出的数据是乱码???
- oracle block 能同时存储不同表中数据吗?
- 一个分页的oracle存储过程,不会写啊~请各位大人给写个,我学习学习~
在上文中只看见你输入了邮件服务器的发送服务器smtp.163.com和你的邮箱号,但你登陆邮件服务器时,
163会鉴权的,所以你要向163提供你的用户名和密码。
登陆邮件服务器应该用登陆账号:username和密码,在什么位置配置啊
/*初始化邮件服务器信息,连接邮件服务器*/
L_CONN := UTL_SMTP.OPEN_CONNECTION(P_SERVER, P_PORT);
UTL_SMTP.HELO(L_CONN, P_SERVER);
/* SMTP服务器登录校验 */
IF P_NEED_SMTP = 1 THEN
UTL_SMTP.COMMAND(L_CONN, 'AUTH LOGIN', '');
UTL_SMTP.COMMAND(L_CONN, UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.BASE64_ENCODE(UTL_RAW.CAST_TO_RAW(P_USER))));
UTL_SMTP.COMMAND(L_CONN, UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.BASE64_ENCODE(UTL_RAW.CAST_TO_RAW(P_PASS))));
END IF;
/*设置发送地址和接收地址*/
UTL_SMTP.MAIL(L_CONN, P_SENDORADDRESS2);
UTL_SMTP.RCPT(L_CONN, P_RECEIVERADDRESS2);