Oracle Workflow ORA-24247

If you see the following errors:

ORA-24247:Network access denied by access control list(ACL) ORA-06512 at......

 

1. Run the following sql statements as sys user:

EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('acl_for_owb_cc.xml', 'ACL for Control Center', 'OWBSYS', TRUE, 'connect');

EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('acl_for_owb.xml', 'ACL for OWB', 'BIREPOWN', TRUE, 'connect');

begin

dbms_network_acl_admin.assign_acl(

acl => 'acl_for_owb_cc.xml',

host => 'your exchange server'

);

commit;

end;

2. make sure PERL5LIB is unset.

3. Change $ORACLE_HOME/owb/bin/admin/ Runtime.properties

From:

property.RuntimePlatform.0.NativeExecution.FTP.security_constraint = DISABLED

property.RuntimePlatform.0.NativeExecution.Shell.security_constraint = DISABLED

property.RuntimePlatform.0.NativeExecution.SQLPlus.security_constraint = DISABLED

property.RuntimePlatform.0.NativeExecution.OMBPlus.security_constraint = DISABLED

To:

#property.RuntimePlatform.0.NativeExecution.FTP.security_constraint = DISABLED

#property.RuntimePlatform.0.NativeExecution.Shell.security_constraint = DISABLED

#property.RuntimePlatform.0.NativeExecution.SQLPlus.security_constraint = DISABLED

#property.RuntimePlatform.0.NativeExecution.OMBPlus.security_constraint = DISABLED

property.RuntimePlatform.0.NativeExecution.FTP.security_constraint = NATIVE_JAVA

property.RuntimePlatform.0.NativeExecution.Shell.security_constraint = NATIVE_JAVA

property.RuntimePlatform.0.NativeExecution.SQLPlus.security_constraint = NATIVE_JAVA

property.RuntimePlatform.0.NativeExecution.OMBPlus.security_constraint = NATIVE_JAVA