Dataguard'dan mail Atma

Mail atma işleminde hata alınırsa

begin
SYS.UTL_MAIL.SEND (
      'ali.ates@xxxx.com.tr',
      'ali.ates@xxxx.com.tr',
      nvl(null,''),
      nvl(null,''),
      'TEST',
      'test_mesaj',
     -- 'text/html; charset=us-ascii',
   --  'text/plain; charset=us-ascii',
      'html',
      1
   );
end;



Error at line 2
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-06512: at line 14
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.UTL_MAIL", line 654
ORA-06512: at "SYS.UTL_MAIL", line 671
ORA-06512: at line 2

Script Terminated on line 19.

Çözüm


alter system set smtp_out_server='10.112.2.26:25' scope=both;

begin
SYS.UTL_MAIL.SEND (
      'ali.ates@XXXX.com.tr',
      'ali.ates@XXXX.com.tr',
      nvl(null,''),
      nvl(null,''),
      'TEST DRATED',
      'test_mesaj',
     -- 'text/html; charset=us-ascii',
   --  'text/plain; charset=us-ascii',
      'html',
      1
   );
end;