oracle_ocm having dependency
hi,
was preparing for a upgrade from 10.2 to 11.2.0.3 with this oracle notes :
did a query on the source database with:
column REFERENCED_NAME format a20
SELECT OWNER, REFERENCED_NAME FROM DBA_DEPENDENCIES
WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_INADDR')
AND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS');
and result shows that ORACLE_OCM have access to the below network packages:
OWNER REFERENCED_NAME
------------------------------ --------------------
ORACLE_OCM UTL_INADDR
ORACLE_OCM UTL_INADDR
base on the example on note 958129.1, it show grant access to the package UTL_HTTP:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTL_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'TOOLS', is_grant=>TRUE, privilege=>'connect');