Oracle agent connectivity alarms keep firing with "Connection reset by peer, connect lapse 0 ms., Authentication lapse 0" (4227618)

Alarms repeatedly fire for the following rules

• ASM - Usability Connection Availability
• DBO - Usability Connection Availability

The are no network latency issues and the listener is available available.

There are numerous Oracle agent errors similar to the following

ERROR [ConnectionManagementThread-[OraclePool-main2]-[Wed Oct 28 08:43:43 MSK 2020][OracleProfile\{host='HOSTNAME', instance='INSTANCENAME', username='USERNAME', asSysDBA=false, ports='1521', useSSL=false, properties={oracle.jdbc.ReadTimeout=1800000}}]] com.quest.qsi.fason.framework.connections.common.AbstractConnectionManagement - "Exception occurred during connecting"
com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkConnectionException: IO Error: Connection reset by peer, connect lapse 0 ms., Authentication lapse 0 ms.- Profile:OracleProfile{host='HOSTNAME', instance='INSTANCENAME', username='USERNAME', asSysDBA=false, ports='1521', useSSL=false, properties={oracle.jdbc.ReadTimeout=1800000}} 

To investigate the issue,

Install a SQL*Plus client on the Linux FglAM to capture any TNS error messages from the connection. Attached to this knowledgebase article is a copy of the zip file containing the SQL*Plus RPM. Readers must be logged in to download the file.

1. Login the FglAM host and run the following command to install the sqlplus rpm
   rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
   rpm -ivh oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
2. Add the following in your ~/.bash_profile:
   ORACLE_HOME=/usr/lib/oracle/12.1/client64
   PATH=$ORACLE_HOME/bin:$PATH
   LD_LIBRARY_PATH=$ORACLE_HOME/lib
   export ORACLE_HOME
   export LD_LIBRARY_PATH
   export PATH
3. Test if the SQL*Plus is installed properly by running "sqlplus"
4. Edit the test.sh and set the right connection parameters by replacing HOSTNAME.DOMAIN.COM and SIDNAME with the appropriate values for the connection.
5. chmod 775 test.sh
6. Run the script: ./test.sh

Results from a previous case

The error message "ORA-12547: TNS:lost contact" was identified. The issue was resolved by changing to the host IP address.