Error
Error Code:
ORA-28557
ORA-28557: Missing FDS Names
Description
The ORA-28557 error occurs when attempting to connect to a non-Oracle system using a Heterogeneous Services database link. This error indicates that the agent supporting the non-Oracle system did not return the required `FDS_CLASS_NAME` and/or `FDS_INST_NAME` values, which Oracle needs to configure the link.
Error Message
ORA-28557: unknown string for database link to non-Oracle system
Known Causes
4 known causesIncorrect Agent Configuration
The Heterogeneous Services agent might be misconfigured, preventing it from properly communicating with the non-Oracle system and retrieving the necessary FDS names.
Missing Agent Installation
The required Heterogeneous Services agent for the specific non-Oracle system might not be installed on the Oracle server.
Network Connectivity Issues
Network problems could prevent the Oracle server from reaching the Heterogeneous Services agent, leading to a failure in retrieving the FDS names.
Agent Version Incompatibility
The version of the Heterogeneous Services agent might be incompatible with the Oracle Database version or the non-Oracle system version.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service