A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Check Database is running / not
Joined: Jul 29, 2004
Sep 29, 2004 06:23:00
i want to check through
code whether my oracle database on the server machine (solaris platform) is up and running.
How can i do that? any hints / ideas....
Joined: Jun 02, 2003
Sep 29, 2004 18:08:00
send a 'select sysdate from dual' and check the response.
author & internet detective
Joined: May 26, 2003
Sep 29, 2004 18:34:00
Do you want to know if the database as a whole is running or a particular instance?
Either way, you would do a query. But the specific query would vary. Also note that you are checking the query doesn't throw an exception. Not a specific return value.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: Check Database is running / not
error in jdbc connection
Check Instance of database running/not
Pinging a Remote DataBase
getting error ORA-125 : TNS :no listener while try to login toad
DataBase Server ping
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014