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

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.