Check if Oracle database is running

Ben

New member
Joined
Apr 10, 2006
Messages
1
Programming Experience
3-5
Hello everyone,
I'm writing some code for disaster recovery. I need to have an
application which accesses Oracle Server to determine if the database is up or not. I know in SQL has a method "databasepropertyex" which returns the status of the database but im afraid i am not able to use this instruction with Oracle :confused:

Any suggestions??

Thanks!

Ben
 
you can open the connection in a try/catch block. If the connection fails, then you can perform your error handling in the catch part of the block. If the connection is successful, then use the finalize part of the block to proceed.
 
Back
Top