DBMS_JAVA.GRANT_PERMISSION 'SYS:JAVA.NET.SOCKETPERMISSION' has not been granted (Doc ID 1082251.1)

Symptoms

Executing a java stored procedure (JSP) may fail with:

Exception -->java.security.AccessControlException:
the Permission (java.net.SocketPermission <hostname.net> resolve) has not been granted to '<schema>'.
The PL/SQL to grant this is dbms_java.grant_permission( '<schema>','SYS:java.net.SocketPermission', 'siebeldev.emdeon.net', 'resolve' )

Executing the following to assign the permission to the user results in the same exception.

SQL> exec dbms_java.grant_permission( '<SCHEMA>','SYS:java.net.SocketPermission', '<HOSTNAME>', 'resolve,connect');

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.