2 Replies Latest reply: Oct 21, 2002 6:17 PM by 354346 RSS

    unable to send mail using utl_smtp even after the installation went fine.

    354346
      I followed the following procedure to install utl_smtp package

      SEND MAIL THROUGH DATABASE BY UTL_SMTP
      This is a feature of Oracle 8i (8.1.6 release 2) . We can send mail thorough database by using UTL_SMTP package.
      To make it work check the following configuration before proceeding

      X X java option must be installed in the database.
      X X TCPconnection class (plsql.jar) must be loaded.

      X X Init parameters


      SHARED_POOL_SIZE > = 65M
      JAVA_POOL_SIZE >= 50M
      50M free in the SYSTEM tablespace
      250M of rollback segment space

      STEP 1.
      Run initjvm.sql through svrmgrl or by connecting as SYS
      ON UNIX AT SQL/SVRMGRL : $ORACLE_HOME/javavm/install/initjvm.sql
      STEP 2 :
      ON UNIX AT UNIX PROMPT :
      $ORACLE_HOME/plsql/jlib>loadjava -f -v -r -u sys/**** plsql.jar

      The following output will be expected after running above command.
      initialization complete
      loading : oracle/plsql/net/TCPConnection
      creating : oracle/plsql/net/TCPConnection
      loading : oracle/plsql/net/InternetAddress
      creating : oracle/plsql/net/InternetAddress
      loading : META-INF/MANIFEST.MF
      creating : META-INF/MANIFEST.MF
      resolver :
      resolving: oracle/plsql/net/InternetAddress
      resolving: oracle/plsql/net/TCPConnection

      STEP 3:
      Run initplsj.sql through SVRMGRL or SYS
      ON UNIX AT SQL/SVRMGRL : @$ORACLE_HOME/rdbms/admin/initplsj.sql

      The following output is expected

      Call completed.
      Call completed.

      the installation went exactly specified.
      but when i tried to send an email following error occured.

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

      please help me out.it is very urgent.
      regards
      vishal