What Should I Do If the Oracle Link Connectivity Test Is Successful on the Link Creation Page but Fails on the Links Page?

Symptom

On the page for creating an Oracle link, the link connectivity test is successful.

On the Links page, the Oracle link connectivity test fails. The following information is displayed.

Failed to connect to the server. Check whether the IP address, hostname, and port number are correct, and whether the network security group and firewall are correctly configured. For details, see the ORA-01005 null password given. logon denied(Cdm 0941) message returned by the database.

Solution

Check whether the IP address, hostname, and port number are correct, and whether the security group and firewall are correctly configured. Locate the fault by referring to the message returned by the database. It is found that the password of the Oracle database contains less than eight characters. Create another Oracle link with the password of the Oracle database set correctly, and the issue is rectified.