Error Message "ORA 12170 TNS Connect Timeout" Reported While Connecting Oracle Databases through Host Operation in the Bastion Host

Symptoms

Error message "ORA:12170 TNS Connect Timeout" was reported while connecting to Oracle databases through host operation in the bastion host.

Possible Causes

The network between the client and the virtual IP address is disconnected.

Solution

1. Check the network communication.
   • Port for connections between your PC and the bastion host: 1521
   • Port for connections between the bastion host and the database: port 1521 used for Oracle databases by default

2. If the network communication is normal, capture packets on the bastion host and check whether the database IP address managed by the bastion host is the actual IP address of the database node instead of the virtual IP address of the Oracle database.