RE: Oracle on NT

To see if the database is running you are going to have to write a sqlplus script and spool the output. All you need is to do something like

sqlplus user/pword @dbtest.sql

REM dbtest.sql
spool dbup.txt
select user from dual;
spool off
exit

If the db is down you will have an error note in dbup.txt. Otherwise, it will just show your username

The reason for this is that Oracle on NT is a multithread single service. If you look in taskmanager all you will see is one ORACLE.EXE running. This process contains all the threads for SMON, PMON, ARCH, DBWR, LGWR, CKPT, etc. WinNT resource kit has a tool (obviously not for free, it's Microslop) to actually look at the threads within a process. The services in NT can still be shown as running without the DB being up so don't trust the service being up to equal db available. Another way to handle DB up/down notification stuff is to install OEM and use the events to track and report on this.

Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
rodney.holman_at_lodgenet.com
Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation

> -----Original Message-----
> From: Paul Drake [SMTP:paled_at_home.com]
> Sent: Wednesday, October 25, 2000 3:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle on NT
>
> nstetson_at_csc.com wrote:
> >
> > Does anyone have any scripts on NT to determine if the Oracle service is
> > running?
> >
> > I am also interested in a script to determine if the database itself is
> > up/down when the service is running.
> >
> > Thanks,
> > Nancy
>
>
> Nancy,
>
> This is very crude - in fact, so much so that I am doubting whether to
> post it at all.
> So far, you've received no reply, so I guess that this is better than
> nothing.
> This was on W2K Pro:
>
> C:\>(net start) > net_start.txt
>
> C:\>find "Ora*" net_start.txt
>
> ---------- NET_START.TXT
> Backup Exec Oracle Agent
> OracleOraHome81TNSListener
> OracleServiceDEV
> OracleServiceRCV
> OracleWebAssistant0
>
> Its mighty crude, but its headed in the right direction.
> Maybe the NTResKit has a few posix-compliant GNU gems that will process
> this in one command.
>
> hth,
>
> Paul
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Drake
> INET: paled_at_home.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Oct 25 2000 - 06:53:54 CDT