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.
Whitehorses is specialized in succesfully implementing Oracle SOA solutions: BPEL, OSB, WebLogic & BPM
{ 1 comment… read it below or add one }
Hi,
I tried to implement the sample in your Apex 4.0 cookbook for Google Maps and cannot get the map to show. Do you have any errata or any changes to share that could help in getting the example to work? I have tried it on a couple different Apex environments and cannot get the map to show. Any suggestions on diagnosing the problem?
Pat
{ 1 trackback }