11g Upgrade - Network ACL
I want to upgrade my oracle 10g database to 11g. the utlui112.sql script shows following -
WARNING: --> Database contains schemas with objects dependent on network packages.
.... Refer to the Upgrade Guide for instructions to configure Network ACLs.
.... USER MDMSYS has dependent objects.
According to documentation , it is not clear whether I need to install XML DB before upgrade or after upgrade to 11g.
I run the following query and result is as follows -
SQL >SELECT * FROM DBA_DEPENDENCIES WHERE referenced_name IN ('UTL_TCP','UTL_SMTP','UTL_MAIL','UTL_HTTP','UTL_INADDR')
AND owner NOT IN ('SYS','PUBLIC','ORDPLUGINS');
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
------------------------------ ------------------------------ ----------------- ------------------------------ ---------------------------------------------------------------- -----------------
REFERENCED_LINK_NAME DEPE
-------------------------------------------------------------------------------------------------------------------------------- ----
MDMSYS MDM_JOB PACKAGE BODY PUBLIC UTL_TCP SYNONYM
HARD
MDMSYS MDM_JOB PACKAGE BODY MDMSYS UTL_TCP NON-EXISTENT
Can someone plaease help on how I can configure the network ACLs?