When you upgrade your APEX installation on an Oracle 11g database, you might get network access problems like not being able to send email or create a web service reference. This is because the ACL (access control list) has not been well configured.
The Oracle 11g database is shipped with APEX 3.01 pre-installed. This APEX installation resides in schema FLOWS_030000. In order to be able to communicate over the Internet, this user gets the connect and the resolve privileges which can be granted with the package dbms_network_acl_admin. After upgrading, the APEX installation will reside in the APEX_030200 schema. This is a new created user and does not yet have the connect and the resolve privileges by default!
To grant connect privileges to a host for the APEX_030200 user, execute the following script:
begin dbms_network_acl_admin.create_acl (acl => 'acl_user.xml' ,description => 'Description' ,principal => 'APEX_030200' ,is_grant => true ,privilege => 'connect' ,start_date => null ,end_date => null); -- DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'acl_user.xml' ,principal => 'APEX_030200' ,is_grant => true ,privilege => 'resolve'); -- DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'acl_user.xml' ,host => '<name of website or host, i.e. soap.amazon.com>'); -- commit; end; /
This script must be executed by the SYS or SYSTEM user.APEX webservice references and ACL,