Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-24248: XML DB extensible security not installed

gl32546848Mar 14 2014 — edited Mar 14 2014

Oracle : 11.2.0.3

OS : Linux

Issue When I login as sys

SQL> SELECT global_name,utl_inaddr.get_host_address FROM global_name;

GLOBAL_NAME

--------------------------------------------------------------------------------

GET_HOST_ADDRESS

--------------------------------------------------------------------------------

VDLEO002.compsec.COM

125.102.136.220

where as when I run as user

SQL> SELECT global_name,utl_inaddr.get_host_address FROM global_name;

SELECT global_name,utl_inaddr.get_host_address FROM global_name

                   *

ERROR at line 1:

ORA-24248: XML DB extensible security not installed

ORA-06512: at "SYS.UTL_INADDR", line 19

ORA-06512: at "SYS.UTL_INADDR", line 40

ORA-06512: at line 1

SQL> show user

USER is "OSDBA"

what could be the reason ?

any grants of privilege    missing or public synonym to be created ?

SQL> select comp_name from dba_registry;

COMP_NAME

--------------------------------------------------------------------------------

Oracle Database Catalog Views

Oracle Database Packages and Types
This post has been answered by Solomon Yakobson on Mar 14 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 11 2014
Added on Mar 14 2014
8 comments
6,893 views