How to check if Oracle is down after open a connection

[Guest_imported]

Part of our web site's home page (the top half) reads an Oracle table and dynamically displays the News items.

After trying to open an Oracle data connection, I would like to check if the Oracle server is down. If it is, I would like to have the page skip the SQL statements to display the News items and just go to display the rest of the page which is straight HTML.

Please, can anyone give me some suggestions for this. Thanks.

 

[carp]

The only thing I can think of is trying to select status from v$instance. If the instance is up but the database is not open, you will get a response. However, this requires the account you are connecting as to have select privileges on the V$INSTANCE view.

 

[Guest_imported]

another problem is sometimes the listener and not the database. tnsping is a fine utility for that purpose.
regards
SteenB

 

[faheemrao]

It is pretty much straite forward that if you make a conection from you application and the function or method of your application does not throgh and Exception its mean that your connection is succesful and database is Up. once you connect to Database, and dataabse is down after your Connection established, then run your SQL statement ,and I recomend to use try {} catch block to find out what is the result of your SQL query.