Alguma dica pessoal?
Em 10/03/2015 18:20, "Samuel Santos" <samuel.gsan...@gmail.com> escreveu:
> *Segue a versão do 'meu' Oracle:*
>
>
> SQL*Plus: Release 11.1.0.6.0 - Production on Tue Mar 10 18:12:28 2015
>
> Copyright (c) 1982, 2007, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
>
>
> *Estou tentando disponibilizar o serviço de envio de SMTP através do
> Oracle, seguindo o procedimento abaixo:*
>
> create or replace procedure mailserver_acl(
> aacl varchar2,
> acomment varchar2,
> aprincipal varchar2,
> aisgrant boolean,
> aprivilege varchar2,
> aserver varchar2,
> aport number)
> is
> begin
> begin
> DBMS_NETWORK_ACL_ADMIN.DROP_ACL(aacl);
> dbms_output.put_line('ACL dropped.....');
> exception
> when others then
> dbms_output.put_line('Error dropping ACL: '||aacl);
> dbms_output.put_line(sqlerrm);
> end;
> begin
>
> DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(aacl,acomment,aprincipal,aisgrant,aprivilege);
> dbms_output.put_line('ACL created.....');
> exception
> when others then
> dbms_output.put_line('Error creating ACL: '||aacl);
> dbms_output.put_line(sqlerrm);
> end;
> begin
> DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(aacl,aserver,aport);
> dbms_output.put_line('ACL assigned.....');
> exception
> when others then
> dbms_output.put_line('Error assigning ACL: '||aacl);
> dbms_output.put_line(sqlerrm);
> end;
> commit;
> dbms_output.put_line('ACL commited.....');
> end;
> /
>
> show errors
>
>
> begin
> mailserver_acl(
> 'mailserver_acl.xml',
> 'ACL para liberar SMPT',
> 'TESTE',
> TRUE,
> 'connect',
> '10.204.8.20',
> 25);
> end;
> /
>
> *Só que estou 'tomando' o erro ao tentar executar o comando abaixo:*
>
>
> SQL>
> SQL> begin
>
> DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('mailserver_acl.xml','TESTE',TRUE,'connect');
> commit;
> end;
> /
> begin
> *
> ERROR at line 1:
> ORA-31001: Invalid resource handle or path name
> "/sys/acls/mailserver_acl.xml"
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
> ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 247
> ORA-06512: at line 2
>
> *Alguém poderia me orientar na resolução deste problema?*
>
>
> Atenciosamente,
>
> Samuel Geraldo dos Santos
>
