ORA-24248: XML DB extensible security not installed


bash-4.1$ cd $ORACLE_HOME/rdbms/admin

bash-4.1$ sqlplus "/ as sysdba";

SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL>

SQL> spool install_xml_db.log
SQL> @catqm xdb sysaux temp YES
-- xdb is the password for XML Database repository schema
-- sysaux is the default tablespace for XML Database repository schema.
-- temp is the default temporary tablespace for XML Database repository schema.
-- YES is for using secure files for xdb$resource
.
.
.
[output trimmed]
.
.
.
SQL> declare
 2 suf varchar2(26);
 3 stmt varchar2(2000);
 4 begin
 5 select toksuf into suf from xdb.xdb$ttset where flags = 0;
 6 stmt := 'grant all on XDB.X$PT' || suf || ' to DBA';
 7 execute immediate stmt;
 8 stmt := 'grant all on XDB.X$PT' || suf || ' to SYSTEM WITH GRANT OPTION';
 9 execute immediate stmt;
 10 end;
 11 /

PL/SQL procedure successfully completed.

SQL>spool off

SQL> set linesize 1000
SQL> set pagesize 100
SQL> 
SQL> select comp_name , status from dba_registry;

COMP_NAME STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------
Oracle XML Database VALID
Oracle Workspace Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Real Application Clusters VALID

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: