Oracle Startup Error Messages
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
Exception detected. The root cause is java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
Typically this occurs when attempting to open a connection when TNS is not running. Ensure the TNS listener is started and properly configured.
Start the Oracle TNS Listener.
Windows start the OracleXETNSListener service.
Linux login as Oracle and run lsnrctl start.
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
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.
Start the Oracle Database.
Windows start the OracleServiceXE service.
Linux login as Oracle and run dbstart.
Exception detected. The root cause is java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress
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.
Wait for the database service to start. If it does not start check the database alert.log to see what the underlying issue is.