Test Data Manager

Tech Tip: ORA-24248: XML DB extensible security not installed

  • 1.  Tech Tip: ORA-24248: XML DB extensible security not installed

    Posted 11-29-2017 09:22 PM

    This document can also be viewed at https://support.ca.com/us/knowledge-base-articles.TEC1223749.html
    To see more documents like this, check out our TDM knowledge base here: CA Test Data Manager

    Issue:

    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 

    If you do not have an Oracle support account, this document also reviews how to resolve this: http://oracleflash.com/40/ORA-24248-XMLDB-extensible-security-not-installed.html