How to fix the Oracle error ORA-28505: cannot get non-Oracle system capabilities from string?

In this post, you’ll learn more about the Oracle ErrorORA-28505: cannot get non-Oracle system capabilities from string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-28505: cannot get non-Oracle system capabilities from string

Reason for the Error ORA-28505: cannot get non-Oracle system capabilities from string

ORACLE was unable to retrieve capability information for the non-Oracle system connected through a heterogeneous database link. This capability information should be stored in data dictionary tables viewable with the HS_CLASS_CAPS or HS_INST_CAPS data dictionary views.

How to fix the Error ORA-28505: cannot get non-Oracle system capabilities from string ?

You can fix this error in Oracle by following the below steps

Contact the DBA to check the server data dictionary table named in the error message. If table contents are incorrect, the DBA should restore all data dictionary content for this FDS_CLASS_NAME and/or FDS_INST_NAME. It usually is sufficient to delete all current data dictionary content for this class and/or instance and initiate a new connection to let the connected agent upload new data dictionary content to the server.