|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 10th, 2005, 08:25 AM
|
|||
|
|||
|
how to check oracle server availability
I have a web page allowing user to query a remote oracle server. But this oracle sever is often offline. I need to have a program to check whether this server is available or not, and display a warning message if it is offline.
Does anyone knows the best way to check it? Thanks.
|
|
#2
May 10th, 2005, 08:27 AM
|
||||
|
||||
|
A login
 Add a simple login script to the login page, trap the appropriate error and display warning to users. You can also check if listener is on with tnsping but it's more complicated IMHO
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > how to check oracle server availability |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
