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
- Open the $LYCIA_DIR/etc/inet.env file.
- Add or edit the value of the QXDEBUG environment variable as follows: QXDEBUG=UuBbSsedPptLlCcmGOzAzKzQ
- Save changes.
- Restart the application.
- 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
Related articles