You can also get a list of services and just about everything else running
on Win2K by using Windows Management Instrumentation (WMI) in VBScript or
JavaScript. And it's all part of the OS.
"Paul Drake" <drak0nian_at_yahoo.com> wrote in message
news:1ac7c7b3.0303022219.6f952ec7_at_posting.google.com...
> "Bill Davison" <wdavison_at_fpcc.net> wrote in message
news:<3e62a8bc_at_news.starnetinc.com>...
> > Since each database in Windows has its own service, you can search for
> > service names. There's a command line utility in the Windows 2000
Resource
> > Kit called Service List (sclist.exe). I can email it to you off list if
you
> > like, size is only 6KB. One caveat - depending on how you shut down
your
> > databases it's possible for the database to be down even though its
service
> > is still running.
> >
> > Finding the Oracle home for each DB is trickier, I think the only answer
is
> > to pull it out of the registry. There are probably some add-on Perl
> > packages you can download for this. On Windows 2000 I think you're
looking
> > for
> >
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleService<your_sid>
> > \ImagePath. There's another windows resource kit tool called regdmp.exe
> > that you can use instead of Perl, but it spits out everything under
> > OracleService<your_sid>, so you'd have more output than you want.
> >
> > <dan1999a_at_attbi.com> wrote in message
> > news:yVj8a.310694$HN5.1353446_at_rwcrnsc51.ops.asp.att.net...
> > > Hi Oracle DBAs,
> > >
> > > In UNIX, to get a list of Oracle databases on a server, I do this in
my
> > > script:
> > > grep ^[A-Z,a-z] /etc/oratab
> > >
> > > Is there a way that I can script out getting a list of Oracle
databases
> > > and its Oracle Home in a Windows environment?
> > > I'm trying to write a script that
> > > will run for each Oracle database on a server.
> > > Also, is there a way of doing this using PERL?
> > >
> > > Thanks in advance.
> > >
> > >
>
> Bill,
>
> I was hoping to find such a tool at:
> http://www.microsoft.com/windows2000/techinfo/reskit/tools/default.asp
>
> where microsoft provides a subset of W2K Resource Kit tools.
> Its not there. Might just have to shell out the bucks to get the
> Resource Kit.
> The Professional version is only $38.25 on bookpool.
> The Server version lists at $299 - discounted to $164.95, but out of
> stock.
> That's too steep for me.
>
> As sclist appeared to only provide details as to services that are
> running, I think that a simple "net start" command could provide the
> same info.
>
> If one dumps out a "system info report" (w2K) aka "diagnostics report"
> (nt4) one could parse the contents of that, but again, the tool to
> create such a report in a command line fashion is part of the resource
> kit. This report tends to have all services - whether started or not -
> listed.
>
> other thoughts:
>
> If the server is configured in an OFA fashion,
>
> 1. examine all of the password file names in each
> %ORACLE_HOME%\Database
> 2. examine all of the ifiles names in each %ORACLE_HOME%\Database
> 3. examine all of the folders under %ORACLE_BASE%\Admin
>
> guess that isn't much help.
>
> Paul
Received on Mon Mar 03 2003 - 21:32:14 CST
