Linux. Oracle. Connection failed Error: -999

LYCIA


Problem

The “Connection failed   Error:  -999” error message appears while connecting to Oracle database on Linux OS.

Solution

  1. Open the $LYCIA_DIR/etc/inet.env file.
  2. Add or edit the value of the QXDEBUG environment variable as follows: QXDEBUG=UuBbSsedPptLlCcmGOzAzKzQ
  3. Save changes.
  4. Restart the application.
  5. Check if $QUERIX_BASE/apache-tomcat/logs/lycia-web.log file contains these lines:
    u SqlError : Error number -999 (21561)
    e SqlError : ORA-21561: OID generation failed

“ORA-21561: OID generation failed” error message indicates that either host is not specified in the /etc/hosts file, or the hostname cannot be resolved via DNS request.
To fix the error, you need to ensure the host is specified in the /etc/hosts file and the DNS record for the host is correct.

For example, if the hostname is 'host.my.domain', the following line must present in the /etc/hosts file:
127.0.0.1 host.my.domain host