This content has been marked as final. Show 11 replies
One possibility is that in your ASSIGN_ACL is not listing the port. For example:
BEGINHave you verified that firewalls, etc. are not standing between the data server and the mail server?
dbms_network_acl_admin.assign_acl(acl => 'psoug-org-permissions.xml',
host => '*.psoug.org', lower_port => 80);
How to i verify about firewalls?
even after assigning port, it is giving the same error. The same code was working when i did with oracle 10g as database and OWB 10g.
do I need to give any additional grants to the user?
Other than a grant of execute on DBMS_NETWORK_ACL_ADMIN no.
My guess is that somehow you made an error, perhaps in IP Address, in your ACL definition.
i got IP address by pinging my mail server.
And the missing port number?
For Oracle Warehouse Builder 11g running in 11g dB you need to set the ACL for the OWBSYS user. For example:
EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('acl_for_owb_cc.xml', 'ACL for Control Center', 'OWBSYS', TRUE, 'connect');
For Oracle Warehouse Builder 10.2.0.4 running in 11g dB you need to set the ACL for the OWB repository owner. For example:
EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('acl_for_owb.xml', 'ACL for OWB', 'MY_OWB_REPO_OWNER', TRUE, 'connect');"
I also had to grant the smtp server we work on. You can do did with the following statement:
acl => 'acl_for_owb_cc.xml',
host => 'smtpserver.local'
Can you please send me all the steps required to send email. I am trying also to send mail after job completion and showing the same error.