Re: easy ways to know oracle is up

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 24 Apr 2007 12:56:12 +0200
Message-ID: <59661tF2ien71U3@mid.individual.net>

On 24.04.2007 12:54, betelge87 wrote:
> We are trying to develop a script which detects if oracle server is
> running correctly. We have seen that lot of oracle process are running
> and with ps is not easy to know if oracle is really running. On the
> other hand we saw that through sqlplus is possible to start a
> connection and see if oracle is answering. Is there any standard or
> easy way to do this?

It depends on what you really want to test. Maybe a simple "select 1 from dual" is sufficient. Maybe not.

robert Received on Tue Apr 24 2007 - 05:56:12 CDT