On Apr 24, 2:46 pm, Jomon P Jacob <jacob.jo..._at_gmail.com> wrote:
> You can use the following commans in unix :>> PROCS='ps -ef | grep <DB_SID> | wc -l`>> if [ ${PROCS} -ge 4 ]> then> echo " Database is up and running"> else> DBRUN="Database is down"> fi>> Or even You can use the following command to check whether any of the> mandaatory process is running :> % ps -ef | grep pmon>> This will list you the whether the pmon process for the particular DB> is up and runing> eg :> pmon_mydb

We have added these ps tests into the script. With this we are sure
when
DB is up. On the other hand we want to know when DB is up and is
actually
working as should, that is, is open and answer queries. So we have
adapted
below ideas.

>> In windows you may> 1 ) Set the ORACLE_SID> 2 ) Start the SQLPLUS as " sqlplus "/ as sysdba" <===> provided you have rights ( or use sys/passwd)> 3) It dispaly " connnected to an idle instance" if the db> is down>> or else Query :> SQL> select status from v$database;