Oracle Database Discussions

Dear all,
we recently upgraded our database from 10g to 11g (11.1.0.7) on Window platform and as a result our send_email function does not work any more. So, we followed the instruction here http://www.oracle.com/technology/pub/articles/oracle-database-11g-top-features/11g-security.html and all possible sources to try to make our send_email function work again.

Here is the process and result we got

SQL> SELECT ANY_PATH
2 FROM RESOURCE_VIEW
3 WHERE ANY_PATH LIKE '/sys/acls/%.xml';

ANY_PATH
--------------------------------------------------------------------------------
/sys/acls/ANONYMOUS/ANONYMOUS1db3674051747c494bf2f82729dfc8_acl.xml
/sys/acls/all_all_acl.xml
/sys/acls/all_owner_acl.xml
/sys/acls/bootstrap_acl.xml
/sys/acls/ro_all_acl.xml
/sys/acls/ro_anonymous_acl.xml


SQL> set serveroutput on
SQL> begin
2 mailserver_acl(
3 'smtppkg.xml',
4 'ACL control on UTL_SMPT',
5 'XXXX',
6 TRUE,
7 'connect',
8 'xx.xx.xx.xx',
9 25);
10 end;
11 /
Error dropping ACL: smtppkg.xml
ORA-31001: Invalid resource handle or path name "/sys/acls/smtppkg.xml"
Error creating ACL: smtppkg.xml
ORA-00980: synonym translation is no longer valid
Error assigning ACL: smtppkg.xml
ORA-31001: Invalid resource handle or path name "/sys/acls/smtppkg.xml"
ACL commited.....

PL/SQL procedure successfully completed.

The statement ORA-00980: synonym translation is no longer valid is kind of strange. I checked that both the package and public sysnonym DBMS_NETWORK_ACL_ADMIN do exist in the database.

However, I seemed like that I couldn't find the directory "/sys/acls" in the database server. there is a directory c:/.../xdk/acls though. Is it supposed so or not? or the setting for Window Server is somehow different?

Did I miss something? Any solution to the problem I faced?

Your help would be much appreciated.