ERROR: java.sql.SQLException: Got minus one from a read call
This error occurs when the connection from the manager to the database is not successful.
To fix this error:
1. Check the status of the database using the following command. The status for the ArcSight database should be “OPEN”.
root# su oracle oracle$ sqlplus / as sysdba SQL> select instance_name,status from gv$instance;
2. Check the status of the Oracle listener using the following command. The output should include the Start Date and Uptime if it is running.
cd /usr/local/arcsight/db/bin ./arcdbutil lsnrctl status
3. Check the TCP.INVITED_NODES parameter in the “sqlnet.ora” file (/home/oracle/OraHome11g/network/admin/sqlnet.ora). The manager IP address or host name should be included as a valid host in this parameter.