Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

oracle_ocm having dependency

edited Jun 10, 2013 5:40AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center