Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to check the database is available

How to check the database is available

From: <kinwho_at_my-deja.com>
Date: Sun, 15 Aug 1999 07:59:00 GMT
Message-ID: <7p5s01$v57$1@nnrp1.deja.com> 





Hi,



I need to write an UNIX script to detect whether the instance is up and
the databse is online.  The script is run on the same machine of the
instance, but my database user login does not have sa role.  I could
grep on the Oracle process to detect the instance is up.  But, I don't
know how to detect the database is online.  Any suggestion or idea?



Thanks,


Kin Ho




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Sun Aug 15 1999 - 02:59:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US