Skip to main content

PLS-00201: identifier 'DBMS_XEVENT.XDBREPOSITORYEVENT' must be declared when creating ACL

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.
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 declared

Check 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                                                          TRUE


Check 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       VALID


So 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

Popular posts from this blog

Cancel or abort adop session

ADOP is in my opinion still pretty half baked. This is a critical tool that just isn't as intuitive as the old adpatch was. However we move with the times and get the hang of the new way of doing things. Along the way you might want to abort or cancel a patching cycling. With the two file systems and db editioning this can be a bit more to manage. I have learnt the hard way so you need to use the full cleanup after aborting a session.
adop phase=abort
adop phase=cleanup cleanup_mode=full

Creating new WLS domain ends with exit code 255

Cloning the instance I ran into this weird error. Was not sure what to do but after learning my lesson I dug through the error logs after seeing this in the adcfgclone log file.
START: Creating new WLS domain.
Running /u03/APPLYES/YES/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u03/APPLYES/YES/fs2/EBSapps/comn/util/jdk64 -al /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u03/APPLYES/YES/fs2/FMW_Home/user_projects/domains/EBS_domain_YES -tmw /u03/APPLYES/YES/fs2/FMW_Home -mpl /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply -silent true -debug true -domainAdminPassword /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/tempinfo.txt
Script Executed in 1903 milliseconds, returning status 255
ERROR: Script failed, exit code 255

Dig a bit deeper into the log files
cd /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply
cat CLONE2016-01-10_04-37-11PM.log

Failed to initialize the application 'EBSDataSource' due to error weblogic.application.ModuleException after FNDCPASS apps change

Started testing password changes in our clone environments. Weblogic seems to love throwing you curve balls and when I changes the apps password with the below:
FNDCPASS apps/$APPS_PASS 0 Y system/system SYSTEM APPLSYS $APPS_PASS
I was not able to start the weblogic managed servers. A look in the log an I found this:

weblogic.application.ModuleException:
        at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:327)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:517)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:159)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:45)
        at weblogic.application.internal.BaseDep…