Alarms repeatedly fire for the following rules
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}}
Ran the attached SQL Plus instant client on the FglAM on Linux
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 sqlpus is installed properly by running "sqlplus" 4). edit the test.sh and set the right connection parameters 5). chmod 775 test.sh and run the script: ./test.sh
Note: the script will run for 30 mins, use the following to run this in the background, run: nohup ./test.sh &
The error message "ORA-12547: TNS:lost contact" was identified.
The issue was resolved by changing the host IP address.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz