How check that Oracle Database is Up?

Question

For our application we have configuration file for connection to the Oracle Databese (url, user, pass).

Application start for 2-5 minutes. If some wrong with databese i see this in logs, but i must wait this 2-5 minutes... it is lost of time...

So I try find most quickly and simply way to determine that with database all ok and database online.

Do you have any idea how can I do it?

Thanks.

Answer 1

You should use/write a script that will connect to the server and see if your database is online. Here the Oracle guys will help. Just execute it from a batch/shell script (see Running Scripts From SQL Command Line) and see it's output. If everything is alright than you have your answer.

Or just try with SQL*Plus client.

Answer 2

It might be wise to run an actual query against the database as well. This just ensures that you can both connect and query. I would make it something very simple and fast, such as:

SELECT pk_column 
  FROM sometable
WHERE rownum <= 1