在应用中直接上报数据时,获取ORACLE 11G(10g没事)主机IP和实例时候,执行下列SQL语句出现错误:
SELECTlower(utl_inaddr.get_host_address||':'||SYS_CONTEXT ('USERENV','DB_NAME'))
FROMdual ;
试图连接到超级用户,给当前用户授予select any dictionary,错误依旧
grant select any dictionary to test;
查询了下网上,有说用ORACLE发邮件也出类似错误的,解决方法都差不多,找了个类似的:
ORA-24247: network access denied by access control list (ACL)错误:
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.'UTL_INADDR", line 654
ORA-06512: at "SYS.'UTL_INADDR", line 671
ORA-06512: at line 1
按照其解决方案做了下,果然解决问题,在此记录下:
首先连接到超级用户:
SQL>Conn / as sysdba;
已连接。
SQL>
1创建ACL
SQL> begin
2dbms_