Oracle DB Error ORA-28522 error initializing heterogeneous capabilities

The following is the cause of this error:

Oracle was unable to retrieve capability definitions for the non-Oracle system instance, probably because the underlying data dictionary table does not exist or is formed incorrectly.

Action you can take to resolve this issue: Verify that the Oracle server's Heterogeneous Services data dictionary was installed correctly. If the Heterogeneous Services data dictionary is not installed, execute the CATHS.SQL script in the $ORACLE_HOME/rdbms/admin directory. If the connected agent, identified by FDS_CLASS_NAME, requires a custom installation script for the Oracle server, verify that the script has been run. If both scripts were executed and the error persists, contact customer support of the agent vendor.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related