Forum Stats

  • 3,757,525 Users
  • 2,251,241 Discussions
  • 7,869,855 Comments

Discussions

Required Help regarding SMTP_OUT_SERVER

AFF-MMCL
AFF-MMCL Member Posts: 4 Red Ribbon

I already setup SMTP_OUT_SERVER for UTL_MAIL and test server its working fine, but next day when i use command "show parameter SMTP_OUT_SERVER" , it shows blank, no parameter set. How to fix it permanently so if the applications bounce, the data will always be there.

Best Answer

  • Paulzip
    Paulzip Member Posts: 8,445 Blue Diamond
    edited Jan 2, 2021 2:54PM Accepted Answer
    conn sys/password as sysdba
    alter system set smtp_out_server='smtp.domain.com' scope=both;
    

     SCOPE=BOTH makes the change for the current instance and preserves it through any future bounces.

    AFF-MMCL

Answers