When a Framework application start up it will continue to try and connect to the database every 0.5 seconds and will log any error messages that cause the connection to fail. The following are common error messages that framework generates.
The Network Adapter could not establish the connection
Error
Exception detected. The root cause is java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Issue
Typically this occurs when attempting to open a connection when TNS is not running. Ensure the TNS listener is started and properly configured.
Resolution
Start the Oracle TNS Listener.
Windows start the OracleXETNSListener service.
Linux login as Oracle and run lsnrctl start.
ORA-12505
Error
Exception detected. The root cause is java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Issue
The database trying to be connected to is not running. Ensure the Oracle database is running and that the FDatabaseManager.url in the project’s server.properties file is correct.
Resolution
Start the Oracle Database.
Windows start the OracleServiceXE service.
Linux login as Oracle and run dbstart.
ORA-01033
Error
Exception detected. The root cause is java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress
Issue
Oracle Database is in the process of initializing or shutting down. Typically this occurs when the database service is in the process of starting or stopping.
Resolution
Wait for the database service to start. If it does not start check the database alert.log to see what the underlying issue is.