Re: Confirming Database is Down on Windows
Date: Wed, 11 Mar 2009 11:22:19 -0700
On Wed, Mar 11, 2009 at 10:42 AM, Charlotte Hammond < charlottejanehammond_at_yahoo.com> wrote:
> Simply connecting doesn't confirm it either: I get an "ORA-01034 ORACLE
> not available" if I try to connect (even as SYS) to a database doing a
> transactional shutdown, even though the users who are doing the transactions
> are still merrily working away.
I'm confused as to why this is insufficient.
eg. If my database monitor cannot connect to the database, I am going to investigate. It doesn't matter at that time if the listener has died, or a 'shutdown' was issued and users are still working away, it should still be investigated IMO.
Maybe a little more background as to what you are trying to accomplish is in order.
Certifiable Oracle DBA and Part Time Perl Evangelist