SMTP error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SMTP error

  1. #1
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    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

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width