ORA-24248: XML DB extensible security not installed

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After installing the Oracle repository, setting up the connection profile, and testing the connection, we are receiving the following error: ORA-24248: XML DB extensible security not installed.

Environment

CA Test Data Manager
TDM
Datamaker
Oracle

Cause

If you or your DBA did not install the Oracle XML database, you will receive this error message. 
A default installation of Oracle will include these features and packages.
In Oracle releases prior to 11g, the only way to limit access to the network via these packages was to restrict privileges on the packages.
So if you have restrictions on your environment (especially Cloud platforms) where Oracle was installed, you may see this error. 

Resolution

To resolve this issue, please reach out to your database administrator (DBA) and they will be able to work with you to find the root cause.
You will either need to install the XML DB or have the restrictions lifted in your environment. 

If you have an Oracle Support account, you can sign in and use the resolution from this knowledge document: https://support.oracle.com/knowledge/Oracle%20Database%20Products/825075_1.html