Database Administration (MOSC)

MOSC Banner

how to update email server on dba_network_acls

edited Oct 6, 2017 9:15AM in Database Administration (MOSC) 2 commentsAnswered ✓

My email server has been changed.

I got errors during sent emails from my 11g database.

smtp_out_server has change to new email server IP.

Testing email can send out without any problem

When I ran my procedure, DOCADMIN.PK_NOTIFICATION1, I got,

ORA-06512: at "SYS.UTL_MAIL", line 662

ORA-06512: at "SYS.UTL_MAIL", line 679

ORA-06512: at "DOCADMIN.PK_NOTIFICATION1", line 312

ORA-29278: SMTP transient error: 421 Service not available"

select * FROM dba_network_acls;

I got old email server ip

Please help. Thanks

Lily W

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center