Error when setting up Network ACLS for Banner on 11g

There is some additional code to setup ACLS in 11g, this example was done in 11.2.0.1

From SUNGARDHE FAQ 1-4W1JEA – Banner and Oracle Database 11g FAQ

Instructions followed on how to setup a network ACL…but you may encounter an error while following their example.

begin
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(‘mailserver_acl.xml’,

begin

*

ERROR at line 1:

ORA-31001: Invalid resource handle or path name

“/sys/acls/mailserver_acl.xml”

ORA-06512: at “SYS.DBMS_NETWORK_ACL_ADMIN”, line 384

ORA-06512: at line 2

‘BANSSO’,
TRUE,
‘connect’);
commit;
end;
/

Add a drop acl command before running either the add privilege or create_acl commands….the following worked for me. The acl name has to match, in this example provided by SunGard it is called mailserver_acl.xml.

begin
DBMS_NETWORK_ACL_ADMIN.DROP_ACL(‘mailserver_acl.xml’);
end;
/

Advertisements

About April C Sims

Oracle DBA for over a decade...enough said.
This entry was posted in 11g, banner and tagged . Bookmark the permalink.

2 Responses to Error when setting up Network ACLS for Banner on 11g

  1. Brian Tran says:

    Can’t drop either:

    SQL> begin
    2 dbms_network_acl_admin.drop_acl(‘mailserver_acl.xml’);
    3 end;
    4 /
    begin
    *
    ERROR at line 1:
    ORA-31001: Invalid resource handle or path name “/sys/acls/mailserver_acl.xml”
    ORA-06512: at “XDB.DBMS_XDB”, line 337
    ORA-06512: at “SYS.DBMS_NETWORK_ACL_ADMIN”, line 428
    ORA-06512: at line 2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s