SMTP error

[SAJI]

I Configured oracle 8.1.6 for SMPT.
When i try to send mail , this is the error i am getting.
can anyone help me
Run %ORACLE_HOME/javavm/plsql/jlib/initjvm.sql
Run %ORACLE_HOME/rdbms/java/install/initplsj.sql
the above 2 file i fired using @d:\.....\ \ .
both the files executed succesfully.



ERROR at line 1:
ORA-20001: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 83
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "SYS.SEND_MAIL", line 12
ORA-06512: at line 1

[rohitsn]

Hi,
This error is comming from your SMTP mail server and is being propogated into the UTL_SMTP package. Typically this error indicates that you are not using the correct email server name in the UTL_SMTP.OPEN_CONNECTION() call. An easy way to determine your correct email host is to review your email client configuration. If you are using Netscape, for example, you would check under 'preferences' then 'mail servers' to find this information.

Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com

[julian]

Originally posted by SAJI
I Configured oracle 8.1.6 for SMPT.
When i try to send mail , this is the error i am getting.
can anyone help me
Run %ORACLE_HOME/javavm/plsql/jlib/initjvm.sql
Run %ORACLE_HOME/rdbms/java/install/initplsj.sql
the above 2 file i fired using @d:\.....\ \ .
both the files executed succesfully.



ERROR at line 1:
ORA-20001: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 83
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "SYS.SEND_MAIL", line 12
ORA-06512: at line 1

Did you run loadjava -force -verbose -user sys/password@db %ORACLE_HOME/plsql/jlib/plsql.jar between initjvm.sql and initplsj.sql. If not, that is why. You will have to reinstall JVM.

[SAJI]

my problem solved

Julian,

Check your mailhost - 'abc.com'


abc.com = proxy server
check proxy settings of your internet explorer .
this will work . this is working for me.

are you using any internet server like ms proxy or wingate ?
if yes. give the abc.com as the IP number of the proxy server