Came across this issue at a customer site or should I say my Liron ran across the issue and asked Arty and myself to investivate. He gave us the hint that it looked like XML Database was not installed.
Check which options are selected in the database
Check what is actually installed
So we can see how that it is missing. Now just need to install it.
Reference
exec sys.dbms_network_acl_admin.create_acl (acl => 'test.xml', description => 'test acl', principal => 'test', is_grant => true, privilege => 'resolve') ;
PLS-00201: identifier 'DBMS_XEVENT.XDBREPOSITORYEVENT' must be declaredCheck which options are selected in the database
select * from v$option order by value,parameter;
PARAMETER VALUE
---------------------------------------------------------------- ----------
Active Data Guard FALSE
Advanced Compression FALSE
Advanced replication FALSE
Application Role FALSE
Automatic Storage Management FALSE
Backup Encryption FALSE
Basic Compression FALSE
Bit-mapped indexes FALSE
Block Change Tracking FALSE
Block Media Recovery FALSE
Change Data Capture FALSE
Data Mining FALSE
Data Redaction FALSE
Database resource manager FALSE
Deferred Segment Creation FALSE
Duplexed backups FALSE
Enterprise User Security FALSE
Export transportable tablespaces FALSE
Fast-Start Fault Recovery FALSE
File Mapping FALSE
Fine-grained Auditing FALSE
Fine-grained access control FALSE
Flashback Database FALSE
Flashback Table FALSE
Join index FALSE
Managed Standby FALSE
Materialized view rewrite FALSE
OLAP FALSE
Online Index Build FALSE
Online Redefinition FALSE
Oracle Data Guard FALSE
Oracle Database Vault FALSE
Oracle Label Security FALSE
Parallel backup and recovery FALSE
Parallel execution FALSE
Partitioning FALSE
Point-in-time tablespace recovery FALSE
Real Application Clusters FALSE
Real Application Testing FALSE
Result Cache FALSE
SQL Plan Management FALSE
SecureFiles Encryption FALSE
Server Flash Cache FALSE
Spatial FALSE
Streams Capture FALSE
Transparent Data Encryption FALSE
Trial Recovery FALSE
Unused Block Compression FALSE
Coalesce Index TRUE
Connection multiplexing TRUE
Connection pooling TRUE
DICOM TRUE
Database queuing TRUE
Flashback Data Archive TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Java TRUE
OLAP Window Functions TRUE
Objects TRUE
Parallel load TRUE
Plan Stability TRUE
Proxy authentication/authorization TRUE
Sample Scan TRUE
Transparent Application Failover TRUE
XStream TRUECheck what is actually installed
select comp_name, status from dba_registry;
COMP_NAME STATUS
----------------------------------- -----------
Oracle Enterprise Manager VALID
Oracle Expression Filter VALID
Oracle Workspace Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALIDSo we can see how that it is missing. Now just need to install it.
spool xdb_install.log
set echo on;
connect / as sysdba
shutdown immediate;
startup;
@D:\oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\catqm.sql xdb users temp no
-- substitute the parameters with appropriate values
@D:\oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlrp.sql
spool off
COMP_NAME STATUS
------------------------------------- -----------
Oracle XML Database VALID
Oracle Enterprise Manager VALID
Oracle Expression Filter VALID
Oracle Workspace Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
exec sys.dbms_network_acl_admin.create_acl (acl => 'test.xml', description => 'test acl', principal => 'test', is_grant => true, privilege => 'resolve') ;
Reference
Comments
Post a Comment