Skip to main content

Posts

Showing posts with the label Security

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