Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

11g Upgrade - Network ACL

shakilshaikhSep 22 2010 — edited Sep 23 2010
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2010
Added on Sep 22 2010
3 comments
3,733 views